Control Freak!! User Forms
Posted by wiggy on May 24, 2001 3:09 AM
Control freak. User Forms
I have designed a nice little user form, with a combination of option buttons, check boxes and command buttons.
Having assigned macros to each of the buttons, I now realise my mistake. As soon as I select any of the option buttons or check boxes the code associated with them runs (not a bad thing I hear you say!). But being the control freak that I am, I would like to be able to audit my selections before the code runs, i.e. to have the code run for each of the selected options once another button is pressed.
The macros for each of the buttons just select a particular range of information from a worksheet and paste it into another.
Does anyone have any bright ideas for giving me the power I crave!! :-p
Thanks for all suggestions