michaelehoudek
New Member
- Joined
- Jan 15, 2016
- Messages
- 21
I created a userform calendar with a checkbox for each day. The end user clicks on a button on the worksheet, which brings up the userform "Dates" My intent was to allow users to check the dates they wanted, then the VBA would paste a formula (=$H$1) into the corresponding dates on the worksheet calendar. I didn't know how much I don't know!
1> Once I Show the userform (calendar), how do I save the checkmarks? The VBA freezes on the form, and only proceeds when I "X" out of it (which erases the checks).
2> Once I figure out how to save the userform (named "Dates"), how do I paste my formula into the worksheet "Calendar".
3> I think I can fiqure out how to clear all the checkmarks when I bring the Dates userform back up, but would be handy to get some direction.
Thanks for any help you can offer. Please don't assume that I know more than I do!
1> Once I Show the userform (calendar), how do I save the checkmarks? The VBA freezes on the form, and only proceeds when I "X" out of it (which erases the checks).
2> Once I figure out how to save the userform (named "Dates"), how do I paste my formula into the worksheet "Calendar".
3> I think I can fiqure out how to clear all the checkmarks when I bring the Dates userform back up, but would be handy to get some direction.
Thanks for any help you can offer. Please don't assume that I know more than I do!