I want to pass a variable from a sub of my Module1 to a userform. Right now the value is put into the active sheet. The sub is called when the user clicks a textbox (the very textbox I would like to return the value after running the sub). Is this possible? Just curious.
Please Login or Register to view this content.
Last edited by terriertrip; 09-26-2017 at 09:17 PM.
Is it
?Please Login or Register to view this content.
How about ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Yeah I tried both of those, but no luck so far. I think it maybe close though. Unusually when the sub is called the first time, it immediately produces type mismatch error forWhen I reset and call the sub from the userform1 a second time, userform2 loads, however when the getdate function is executed,Please Login or Register to view this content.
bombs out here 'form already displayed; can't show modally. I've tried .show 0 and .show 1 but no luck.Please Login or Register to view this content.
Do I need to ensure that userform when initialized is modeless?
Is datevariable getting corret result?
I'm out so, can't test
Afraid not. I'll load a sample wk tomorrow.
Edit: make that today.
I've posted a sample workbook. I've decide to add a small calendar button to the textbox side. I will disable the textbox once we can get the calendar sub to work so the user can only change or add the date through the date picker.
Try this. Select calender button to select date. (Calendar form starts up with current date selected)
Result is put in disabled Textbox2.
Interesting. I was thinking along the same lines today with the calendar button, and in fact started building them into my forms with the hope that that would be the solution. Imagine my surprise to see this! Works great. Thanks bakerman2!
You're welcome and thanks for rep+.
BTW Any particular reason why you would call the userform through an outside sub as you can put the datevariable-code directly in the calendarbutton-click event.
No outside module needed then.
No problem. Thank you for the help!
Good point. Just keep it all in one routine. I'll have to save looking at class modules and object events for another day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks