Hi,
I have uploaded a file with two Userforms: WystawWniosek and Calendarfrm.
The Calendarfrm is a userform that opens a calendar where we can pick up a date.
Whtat I want to do now is to open Calendarfrm when I click on field txtStartfrom and and the same time I want to leave the pickud value there.
So, when I click on 1st of Januafy the date appears in the field txtStartFrom.
Could you please give me a solution for this problem.
Thank you in advance.
https://www.excelforum.com/excel-pro...d-mm-yyyy.html
some answers in this thread
Thanks, but I cannot see the answer to my problem in this thread.
Could you indicate which part refers to that?
The last attachment from jindon contains the code to transfer data from the calendar userform controls to the database userform
I hope the attached would help both of you.
Thank you!
This is just what I needed.
jindon, lovely job...many thanks
You have the command button associated with the textbox to direct the value back to the textbox
Rather than adding 20 or so command buttons, if the calendar was launched from a textbox enter event, could the calendar or textbox be set to receive the value dynamically ie: if calendar launched from Textbox12 then calender value is written back to Textbox12 ????
Ill work away at the command buttons but would be so much cleaner if that possible
Last edited by nigelog; 05-26-2017 at 08:36 AM.
Change event of TextBox in this case is not a good idea, I think.
If change TextBox to Label control, it has Click event, that I prefer.
Thanks Jindon
I'll Work with that...
Appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks