How to use Userform checkboxs to paste formula into worksheet

[michaelehoudek]

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!

 

[michaelehoudek]

I can't figure out how to remove my post, but I did figure out how to solve my problems. Thanks for looking!