+ Reply to Thread
Results 1 to 12 of 12

Calendar or DTPicker Userform replacement?

  1. #1
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Calendar or DTPicker Userform replacement?

    I have a customer who doesn't like add-ins.

    I have used the DTPicker in his workbook and want to replace it with a normal Userform that works like a Calendar to select dates.

    I think that I've seen that on this forum but can't find the thread.

    Can one of you organized gurus point me to it?
    Last edited by MarvinP; 07-04-2012 at 10:35 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Calendar or DTPicker Userform replacement?

    Does this help: Non-activex Datepicker Calendar Control
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

  3. #3
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Calendar or DTPicker Userform replacement?

    Hi MarvinP
    See if this link works for you.
    http://www.excelforum.com/excel-prog...r-control.html

    or this
    http://www.excelforum.com/excel-prog...from-user.html
    Last edited by jaslake; 07-04-2012 at 11:55 AM.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Calendar or DTPicker Userform replacement?

    Hey Palmetto,

    That might be great but Ozgrig won't let me download it unless I register. I'll see what others have first.

  5. #5
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Calendar or DTPicker Userform replacement?

    Hi John,

    I think the RoyUK (same as J&R) solution is an Add-In and not a generic Userform.

  6. #6
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Calendar or DTPicker Userform replacement?

    see if it helps you
    Attached Files Attached Files
    Last edited by john55; 07-04-2012 at 12:45 PM.
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  7. #7
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Calendar or DTPicker Userform replacement?

    Hi MarvinP

    This reference in not an add-in.
    http://www.excelforum.com/excel-prog...r-control.html

  8. #8
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Calendar or DTPicker Userform replacement?

    @ John55 - The frmCalendar-Roy.xlsm is the one I was looking for. Thanks. The Calendar-w.xlsm is an Add-In and makes us do a reference to use it. This is exactly what my customer doesn't want to do. I'll play with Roy one above and make it work for me.

    @ John (jaslake) it looks like I need to download an installer or sign up for their service before I can get this one. Things are chainging on the web now. Everyone wants our email address or tie us onto their pages.

  9. #9
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Calendar or DTPicker Userform replacement?

    Hi MarvinP

    Here's the download that I have stored on my computer.
    Attached Files Attached Files

  10. #10
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Calendar or DTPicker Userform replacement?

    My site has two userforms that can be used as replacements, in addition to the addin

    http://excel-it.com/free_addins.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  11. #11
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Calendar or DTPicker Userform replacement?

    Hey Roy,
    Can I just get the .xls or .xlsm files without having to install iLiVid on my machine too? It doesn't seem I can get the non-xla file without going through the download installer. Suggestions?

  12. #12
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Calendar or DTPicker Userform replacement?

    Don't nstall iLiVid. I'll remove them from 4Shared - this is a reply I received from 4Shared


    Please note that all 4shared downloads are free of charge. You don't need Premium to download from 4shared.
    Let me describe the download process for you:
    After you paste the link to your browser, you are taken to the file download
    page. There you should click on the 'Download Now' link and you will be taken to the countdown page. Wait for a
    few moments until the file download link appears. Then you will be able to
    download file by pressing on the 'Download file now' link.
    This is obviously not the case. I am re-vamping my website & the files will be held on the same server, but here's a temporary download link

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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