+ Reply to Thread
Results 1 to 6 of 6

Pick-up calendar

  1. #1
    Registered User
    Join Date
    11-14-2017
    Location
    Cairo,Egypt
    MS-Off Ver
    2010
    Posts
    75

    Pick-up calendar

    Dears,

    Please I need your support as I have a user-form which contained bottom for Pick-up calendar and all what I need is when I chose any date to be reflected " show" in textbox with label "Date selection".

    Q2 : And please I need to the possibility to convert my user-form to .exe file to run it as a program " In case I need to run it for any worksheet".

    N.B. I attached image for my userform & sample for my user-form file.

    Thanks in advance,
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Pick-up calendar

    In CalendarFrm Code window use Find And Replace Command to replace the below text.

    In Findwhat
    ActiveCell.Value

    In Replace With
    LL_Tool.TextBox11.Text

    Click Replace All


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    11-14-2017
    Location
    Cairo,Egypt
    MS-Off Ver
    2010
    Posts
    75

    Re: Pick-up calendar

    Many Thanks Sixthsense for your support & very sorry for late reply due to network failure in my area, Please I still need your support as until now I don't know how to attach your command to my User-Form. could you please send how to edit it.

    Thanks in advance

  4. #4
    Registered User
    Join Date
    07-26-2018
    Location
    Lithuania
    MS-Off Ver
    16.9
    Posts
    4

    Re: Pick-up calendar

    We are all the same

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

    Re: Pick-up calendar

    Replaced in this version
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    11-14-2017
    Location
    Cairo,Egypt
    MS-Off Ver
    2010
    Posts
    75

    Re: Pick-up calendar

    Many Thanks nigelog ....Finally I got it ..& again thank you Sixthsense ... Now nigelog helped me to understand what do you mean with find and replace .

+ 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. Replies: 3
    Last Post: 12-08-2016, 10:37 AM
  2. Formula to pick up data in a range of more than one calendar year
    By julstaff in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-11-2015, 06:15 AM
  3. how to force a date field to be entered so my pop up calendar appears to pick date
    By cmwilbur in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-29-2010, 10:19 AM
  4. Replies: 1
    Last Post: 08-03-2006, 09:35 AM
  5. [SOLVED] pick date from calendar in excel
    By Jeff L. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2006, 01:50 PM
  6. Populate a cell with a date using calendar pick
    By Shane Nation in forum Excel General
    Replies: 2
    Last Post: 01-29-2006, 03:50 PM
  7. have a calendar pop up in a cell to pick & insert a date in excel
    By helevansen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-29-2005, 05:05 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