+ Reply to Thread
Results 1 to 2 of 2

Update DatePicker from ListBox Event

  1. #1
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Update DatePicker from ListBox Event

    Hello forum,

    I'm trying to generate an interactive UserForm in which a User can set a schedule, view the schedule, and edit the schedule, all natively within said UserForm.

    I've gotten the ListBox to populate other Textboxes within the UserForm from a backend database, but am having issues updating DatePicker objects with the backend database date values. Looking at the Locals window, I can confirm that the value being recorded is the correct date, but the DatePicker object still displays the default date of 'Today'.

    Any thoughts?

    Please Login or Register  to view this content.
    dtTestComplete.Value is the DatePicker object in question that will not seem to update.

    Any help would be much appreciated!
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,302

    Re: Update DatePicker from ListBox Event

    Although it may look like a date from the database are you certain it is formatted as such and is not just a text string ????

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] DblClick event on listbox crashes Excel when I move the listbox as a result of the event
    By feanturi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-22-2022, 11:38 AM
  2. populate data in listbox based on selected on combobox and datepicker
    By ABDELFATTA in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-05-2020, 02:20 AM
  3. [SOLVED] Listbox update multiple items in Listbox
    By ricklou in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-12-2017, 02:28 PM
  4. ActiveX DatePicker: Specify Certain Available Dates/Frequency by Listbox Choice
    By excelforumkeys in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-31-2013, 07:11 PM
  5. [SOLVED] listbox change event won't trigger when listbox is updated
    By Highlander777 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 06-01-2013, 09:03 AM
  6. Editing listbox items in Dblclick event freezes Excel unless mouse moves over listbox
    By muneebmansoor in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-28-2013, 02:21 PM
  7. Replies: 12
    Last Post: 08-28-2012, 07:09 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1