Hello Everyone
i have an userform, i can set date picker in only one TextBox, how can i set that date picker for other TextBox were required,
TIA
Hello Everyone
i have an userform, i can set date picker in only one TextBox, how can i set that date picker for other TextBox were required,
TIA
define the code for each text box.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
Dear Keebellah how can i do this? what will be the code to do this, can you tell me this in details,
like for TextBox4, if i click TextBox4 then date picker show and after select a date it inputs on TextBox4,
again if i click on TextBox7, date picker show but if i write date then it inputs on TextBox4 not in TextBox7,
details plz to do this, tnx a lot
I don't have your code to see it here. But somewhere it tells you that the selected date is to be pasted someplace.
Check the VBA code or the worksheet event. without the file ...
The a look here or else Google for more.
Guessing is for us no option for answres
Last edited by Keebellah; 08-28-2019 at 06:36 AM. Reason: extra info
Hello
Im using this date picker for textbox2 (DOB) only, how can i use this date picker for textbox3 aslo,
TIA
I have not yet downloaded your file, but you use the same code in TextBox3 as you did in TextBox2.
That is if you did it yourself, if your are just copying code and not taking the time to understand it, then VBA is probably more complicated for you than you first thought ?
You have to make some changes:
in the Calendar form
You will have to add code that tells the calendar from which textbox you're callingPlease Login or Register to view this content.
and in Userform1 youhave to add this code
The important part is the commandbutton1_clickPlease Login or Register to view this content.
Dear Keebellah i know that "commandbutton1_click" is important and i don't know the code for that will tell "calendar from which textbox i'm calling and which textbox needs to place that date, and that's way i'm asking here for that, could u plz help me for that.
Thanks
Did you edit the code you have yourself or was this just picked from the internet or another post?
I'm asking this because I can tell you and do it for you but when you want to add a TextBox4 you will have the same problem, and you won't always have someone to do it for you
I'll do it later but I'm just explaining the dependency on others that will create for yourself if you don't even try
Just returned from short holiday.
I recognise this code
Just anticipating next problem.
You will notice the initialisation is set 2017 - 2030, to use beyond this range reset to your requirement.
It was initially intended for Worksheet_Change event operation, not multiple textboxes, without further coding.
This was initially used at a clients request, I personally prefer to steer clear of datepickers, preferring formatted textbox and speed number entry.
torachan.
Yeah, I'm not a fan at all of date pickers.
The OP will have to see if he/she can edit the code to make it work for other Textboexs, not that difficult, your code will do perfect, just requires a little imagination and perseverance and ... time, but it can be done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks