picker

Hello, I'm using Microsoft Office 16 in windows 10 / 64bit I'm looking for a solution to have a popup date picker in my userform I'v been searching for a solution long time ago, found a lot of solutions but most of them for 32bit, and some for 64bit but none of them worked correctly Please I...

Hiyas, I have a spreadsheet where there's a field in my table for a date. Currently, I'm entering in the date manually but, I wanted to try my hand at creating a userform with VBA and for the date, I wanted a date picker. Sadly, I've learned that 64 bit Excel doesn't have a built in date...

I have various tables with date fields and have recently set all of them to not show the date picker; but the date picker still shows in select queries using those tables (old queries and new queries). Is there a way I can remove it from the queries? The query property sheet doesn't seem to have...

Hello gods of Excel Universe!:cool: I have been trying now for a month figuring this out but to no avail. Also i have searched the forums and found none related to my issue. Basically, i just want my date picker to display the current month, although i have the "Today" date displayed at the...

Hi, I created a UserForm that requires a datepicker to show based on the value of combobox I tried Sub End_Date () If Me.TxtTenure.value = "Term" Then DTTenure.Show Else DTTenure.Hide End Sub that didn't work and looked through previous posts and couldn't find...

Hi Everyone, I put the Microsoft Date Picker in a cell and I noticed every time I open the workbook I have to work the mouse wheel to get it to activate. Is this normal and/or is there a way around that? Thank You!

This works very nicely https://stackoverflow.com/questions/26392482/vba-excel-to-prompt-user-response-to-select-folder-and-return-the-path-as-string Does anyone know if there's any way to disable the Tools Button ?

As the title states, how do I get the value of the date picker by debug.print. Thank you

I have returned to Access after a long break and using Access 2013 for the first time I have set up a table with a date field and a date picker but when I pick the date (Shows correctly as the right month and year in the date picker) I get this showing in the field 23/01/192323 I have the...

Hi guys, I seem to be having an issue getting excel to calculate properly. I have a table showing: Picker name(Col B) the time spent picking (Col C), units picked per person (Col D) and want to work out a pick rate(Col F). <colgroup><col width="160" style="width: 120pt; mso-width-source...

Hi guys,I'm trying to create a formula that will correctly search either of 2 ranges of data depending on if the reference cell contains certain text. Both ranges are on 2 different tabs to the summary tab where my reference cell is.My 2 ranges are:Input Corby Picker Data (Range) A:FInput GT BP...

I am using the DateTime picker and it will not hold the custom format even though it shows it has not been changed in the DTPicker properties. I have tried hard coding using dtpicker1.customformat but that doesn't hold either. Is it possible to create a date/time picker without using the activex...

Hi All, I have added date picker to multiple columns in excel for a tracking database. I do not want the time stamp included. I have tried setting the format of the date in format cells and all the suggestions on google. It works at first and when I save, shut down and restart the time stamp...

Hi I think this might be a quick question for someone.... I have a line in my code to input the date from a cell into a date picker IE.document.getElementById("startDatePicker").Value = Selection.Offset(0, 11).Value The cell is formatted to Short Date. For example 10/01/2018.. but when it is...

Hi, I am having an issue with the below piece of code for myfile picker , it is working fine for excel files but the csv files are notvisable when the file picker is open. Is there any way of being able select either a csv or xlsxfile through a file picker? Any help is greatly...

Hello, I want to create a series of inputboxes to ask questions to get the information I need to fill a row in my excelsheet. One of the question is asking the date of a transaction. I now use the code below to enter a date. Is it possible to add a calander oor date picker in an inputbox to...

I haveinserted a date picker but when other users on try and use it on differentmachines it does not work. They enable macros but when they click the button nothing happens, any ideas please.

I am new to Access (Using Access 2013). For that reason please forgive me for my layman's terms to describe what I am trying to achieve. I have created a 'Tasking' Form which records when tasks assigned to individual members of staff. The Form includes the following fields:- Task number (1 -...

Hi all, I am a new member here but I have visited this forum before to look for helpful solutions. Sadly, I cannot seem to find a thread for this one: my date and time picker outputs not dates but numbers albeit not random, and I do not know how to make it display real dates. When I pick...

Hey everyone, I have been looking online for the location of the date picker but all I have seen is that with 2016 64 bit versions of excel its a no go. Is that still current or has it been added. I have seen some addins but it is for a shared worksheet and if possible i would like to find a...