+ Reply to Thread
Results 1 to 4 of 4

Substitute for DatePicker in User form

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    Mauritius
    MS-Off Ver
    2010
    Posts
    26

    Substitute for DatePicker in User form

    Hi Team,

    Due to some technical issue i am unable to have SP6 and i cant use DatePicker function in my user form...

    could you please suggest the alternate option to have calendar for sleecting a date in the user form.

    oR ELSE THE textbox with string however we need to restrict to write only date in the correct format.

    I hope its clear

    Regards

  2. #2
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,293

    Re: Substitute for DatePicker in User form

    try linking this to your textbox entries
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-05-2017
    Location
    Mauritius
    MS-Off Ver
    2010
    Posts
    26

    Re: Substitute for DatePicker in User form

    Thank,

    But how can i integrate this calendar in my user form i created
    file attached where i want to use this calendar for reporting Date

    Capture.PNG

    Please suggest how to do this to get it work as it really suites to my requirement...

    I want to put one blank text box in which your macro can be linked if possible....
    Attached Files Attached Files

  4. #4
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,354

    Re: Substitute for DatePicker in User form

    Try this one. Doubleclick in Combobox2 (Reporting Date) shows Calendar form. Select date and click Refresh
    Attached Files Attached Files
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

+ 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. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  2. [SOLVED] User-Form Problem: User can select headers in User Form (I want Header/no way to select)
    By navialivad in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-18-2014, 10:24 AM
  3. [SOLVED] User Form to execute search and return all values to the user form for editing
    By allwrighty in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-11-2013, 10:40 PM
  4. [SOLVED] Excel vba user form- open directly to user form not worksheet
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 04-24-2013, 05:07 PM
  5. [SOLVED] Excel user form- If/Then statement outcome to show on user form
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-18-2013, 09:16 AM
  6. Print preview from user form opened from a user form
    By Brunstgnegg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-13-2011, 05:12 AM

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