+ Reply to Thread
Results 1 to 3 of 3

Capturing date from frmCalendar into a textboxes.

  1. #1
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    Capturing date from frmCalendar into a textboxes.

    Hi
    As mentioned in the title I have a problem with capturing date from my calendar please see the userform....
    I have a 2 textboxes with 2 buttons to open the frmCalendar it works but it doesn't capture date from the calendar into my textbox.
    Any help will be greatly appreciated.


    Dan
    Attached Files Attached Files

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Capturing date from frmCalendar into a textboxes.

    Hello Dan,

    Happy New Year!

    A few years ago, I created a UserForm Calendar that would allow you to select where the output would go and format the date output.
    The attached workbook has this calendar installed and will copy each date into the correct control.
    Attached Files Attached Files
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Forum Contributor
    Join Date
    08-29-2011
    Location
    Wisbech England
    MS-Off Ver
    Excel 2010
    Posts
    308

    Re: Capturing date from frmCalendar into a textboxes.

    Hello Happy New Year!
    This is exactly what I was after!!!!
    Thank you a lot I really mean it :-)

    Dan

+ 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. Uses of frmCalendar in Excel VBA
    By Rodeltorre in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-13-2013, 04:12 AM
  2. FrmCalendar changes size
    By zplugger in forum Excel General
    Replies: 5
    Last Post: 10-27-2011, 10:22 AM
  3. frmCalendar
    By grahammal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2007, 06:15 AM
  4. frmCalendar
    By grahammal in forum Excel General
    Replies: 2
    Last Post: 01-08-2007, 09:26 AM
  5. Capturing a date field once only
    By Rob Svilts in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-27-2005, 08:22 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