picker

  1. N

    Excel VBA Date Picker for win64 bit

    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...
  2. R

    Office 365 Insiders Excel 64 bit Userform Date Picker

    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...
  3. A

    How to remove date picker from query fields

    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...
  4. K

    Date Picker default value

    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...
  5. B

    Date Picker show based on a combobox value

    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...
  6. B

    Date Picker Help

    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!
  7. A

    Folder Picker

    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 ?
  8. P

    how to debug.print datepicker value

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

    date problem

    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...
  10. S

    HELP! Adding 24 has ruined my formula....

    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...
  11. E

    Vlookup search 2 ranges depending if the reference cell contains certain text

    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...
  12. P

    datetime picker is not holding custom format after saving sheet

    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...
  13. J

    Date Picker issue

    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...
  14. S

    VBA for IE Date Picker Question about cell format

    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...
  15. J

    VBA - File picker , XLSX & CSV

    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...
  16. A

    VBA Date picker or calendar in Inputbox?

    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...
  17. D

    Date Picker Users issue

    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.
  18. D

    Auto saving detail from Form fields in individual record to a subform and then clearing fields in main field.

    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 -...
  19. D

    Excel VBA Date and Time Picker

    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...
  20. T

    Is there any option for a date picker with 64 bit 2016???

    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...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top