I've got a macro that creates a new sheet. In that new sheet, in A1 I like to put a number of 20 digit (only 3 different types) but won't ask ever and ever the user to enter it with inputbox.
I remember about the option button, where I can put this numbers and let the user choose what he need.
How does I want the macro works:
- Start the Macro
- Creates sheet
- Let userform be visible
- Choose which number I need and confirm it with button on userform
- Let userform be invisible
- and Go on..
I don't know well userform so I don't know how it works...
Look at the Option Group in the userfrom and change the caption to the numbers you want and add several then name each option something like optFirst or optSecond then you would add a command button and the code would go behind the command button using either an IF statement or a Select Case statement.