+ Reply to Thread
Results 1 to 5 of 5

Add Date Picker To 2 Textbox In VBA UserForm2

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Add Date Picker To 2 Textbox In VBA UserForm2

    Dear Export

    I have userform In that Twotextbox Need to be Pickdate from Popupcalender..while placing cursor on Textbox1 and textbox2 it popup shows Pickupcalender.... I tried with different code still failed

    Go to sheet Repor Wizard Form ,Click Report filter & Export cmd button

    find the attachment
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    09-21-2011
    Location
    Birmingham UK
    MS-Off Ver
    Excel 2003/7/10
    Posts
    2,188

    Re: Add Date Picker To 2 Textbox In VBA UserForm2

    Use the microsoft date and time picker instead of the calendar control. I have coded one when people wanted to keep the same look, date time picker should do the job.
    Hope this helps

    Sometimes its best to start at the beginning and learn VBA & Excel.

    Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
    Available for remote consultancy work PM me

  3. #3
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Add Date Picker To 2 Textbox In VBA UserForm2

    Dear sir

    I Inserted date picker & tried to insert date into textbox I couldnt complete it find the attachment...It seems like insert 12:00:00 AM..

    find the attachment.
    Attached Files Attached Files
    Last edited by breadwinner; 06-09-2014 at 04:59 AM. Reason: insert

  4. #4
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: Add Date Picker To 2 Textbox In VBA UserForm2

    Any experts can help on this?

  5. #5
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Add Date Picker To 2 Textbox In VBA UserForm2

    Hi breadwinner,

    This code in Userform2 module
    Please Login or Register  to view this content.
    and this code in the "Module1"
    Please Login or Register  to view this content.

+ 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. Replies: 7
    Last Post: 12-08-2013, 06:11 PM
  2. Date Picker - can't change start date
    By JohnFex in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-30-2013, 04:05 PM
  3. transer the date from userform2 to userform1 testbox1
    By Jeff up North in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2013, 06:45 PM
  4. Date Picker won't select current date: Userform
    By valkok in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-04-2011, 06:09 PM
  5. Date Picker Control will not display Current Date
    By SP Brian in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-04-2011, 01:33 PM

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