+ Reply to Thread
Results 1 to 4 of 4

Need Macro for Selected Date Calendar to textbox

  1. #1
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Need Macro for Selected Date Calendar to textbox

    Hi,

    I need a macro coding for pass calendar control date to selected textbox on userform. And when we open userform I want by default today's date in the textbox. Also, I want to join this textbox to Excel's cell C2. Please help me with this. I am attaching the excel sheet with the userform.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Need Macro for Selected Date Calendar to textbox

    You mean like this?

    Tim
    Attached Files Attached Files
    Last edited by harrisonland; 04-18-2020 at 01:58 PM.
    Never stop learning!
    <--- please consider *-ing !

  3. #3
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    Re: Need Macro for Selected Date Calendar to textbox

    Quote Originally Posted by harrisonland View Post
    You mean like this?

    Tim
    Thank you so much @harrisonland ! (TIM) This is exactly what I needed.

  4. #4
    Valued Forum Contributor
    Join Date
    06-22-2018
    Location
    Blackpool, England
    MS-Off Ver
    2019
    Posts
    408

    Re: Need Macro for Selected Date Calendar to textbox

    You're quite welcome and thanks for the rep!

+ 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] Please help - cell needs to show date selected on calendar
    By menolas in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-02-2016, 08:07 AM
  2. [SOLVED] Excel VBA, Macro Shortcut: Create Outlook Calendar Based On the Date of the Selected Cell
    By clprdctn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-08-2016, 10:23 AM
  3. Populating Calendar with name from another sheet when a date is selected.
    By Discussions63 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-25-2016, 09:27 PM
  4. Excel VBA - Closing calendar in userform incorrectly inserts date in the textbox
    By pi_tiger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-01-2015, 06:40 PM
  5. Populate data in Textbox when select date on calendar
    By imzhakmaya in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2014, 05:39 AM
  6. How to close a calendar control when a date has been selected?
    By Gordon1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 05:56 AM
  7. How can I after selecting date on the Calendar autoinsert text into a activex textbox
    By ethanalvin in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 07-29-2009, 06:10 PM

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