+ Reply to Thread
Results 1 to 12 of 12

DatePicker VBA for Userform on Excel 2011

  1. #1
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    DatePicker VBA for Userform on Excel 2011

    Is there any way to make a DatePicker work with Excel user form on a Mac. I have the addin for mac and can make the user form call the DatePicker from a control. But the only place the date chosen ends up on is the spreadsheet. I need the chosen date to be placed on the user form itself and then have the DatePicker close. I haven't created a workbook yet. I've just been trying to get it to work but no luck so far. Works great on a windows machine since the date picker is a control. Any help would be appreciated, Jim

  2. #2
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: DatePicker VBA for Userform on Excel 2011

    See if this works in Mac,
    can not test it myself


    Kind regards
    Leo
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    Leo, it looks like you spent some time working on this. I really appreciate it. It works fine when there is a number in the calendar to select. I can't switch months. When i play with the + and - buttons i can get it to go to another year, but the buttons won't keep cycling through the years. When I get the buttons to display the whole calendar, it will work correctly. I will keep working on it. Thanks for your help with this. Jim

  4. #4
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: DatePicker VBA for Userform on Excel 2011

    Jim,

    you mean the + and - buttons from month dont work ?

  5. #5
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    when it comes up it has current month but no numbers in the month. I push the month - and it goes to January with only the day number 1 showing(2-30 not visible). I push month - again and it shows all the day numbers in the calendar. I Push the month - or + but the month never cycles in "Label 1" but does cycle in "Label 3". Once again there are no day numbers populating the calendar. I try clicking on one of the "empty" day buttons just to see if anything happens,but nothing happens. The year - and + seem to work ok.
    Attached Images Attached Images

  6. #6
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: DatePicker VBA for Userform on Excel 2011

    Last edited by sanram; 09-10-2016 at 06:22 PM.

  7. #7
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    Thanks Sanram but as I stated in my initial post, i already have the addin for mac and also that I don't want the date to be placed into a cell on the worksheet. I need it to work with a user form.

  8. #8
    Valued Forum Contributor
    Join Date
    06-21-2013
    Location
    Bangladesh
    MS-Off Ver
    Excel 2000, Excel XP, Excel 2002, Excel 2007, Excel 2010, Excel 2013
    Posts
    975

    Re: DatePicker VBA for Userform on Excel 2011

    Sorry then. I have created a userform for DatePicker by myself. But it will not work on Mac.

  9. #9
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    I hear ya Sangam, Im thinking about Loading windows and office through bootcamp. Tired of having to work around everything. LeoTaxi is very close to making it work. Ill keep trying to figure it out for now. Trying to figure it out is the best part.

  10. #10
    Forum Expert
    Join Date
    08-16-2015
    Location
    Antwerpen, Belgium
    MS-Off Ver
    2007-2016
    Posts
    2,380

    Re: DatePicker VBA for Userform on Excel 2011

    Must be difference between Mac and Windows
    I use this long time and works 100 %
    Attached Images Attached Images

  11. #11
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    I noticed while stepping through the code for command button 1, that even thought "mydate" month is greater than 1, it skips straight to the "else" statement.

  12. #12
    Registered User
    Join Date
    04-28-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007, 2010, 2011 Mac. 2013,2016. I use 2011 and 2016 the most
    Posts
    90

    Re: DatePicker VBA for Userform on Excel 2011

    I finally got it working. Had to change the code a little. Thanks to LeoTaxi
    Attached Files Attached Files

+ 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] Using Datepicker in Userform VBA compatible to Excel 2013 64bit and 2007 32bit
    By ashburnadam in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-29-2019, 03:35 PM
  2. [SOLVED] Altering DatePicker to write to Textbox on userform
    By liquidmettle in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2015, 09:46 AM
  3. [SOLVED] Problem with a Excel Calendar Datepicker in a Floating VBA Userform
    By butterscotch in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 03-05-2015, 05:42 AM
  4. Colours in a Calendar Datepicker in a Floating VBA Userform
    By butterscotch in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-25-2015, 03:32 PM
  5. Programming DatePicker in UserForm
    By yidode in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-15-2015, 08:30 PM
  6. [SOLVED] call the userform to my columns as pop-up datepicker
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-31-2013, 06:26 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