Option Button for Macro

[qwertysz]

Hello,

the uses of Option Button would be perfect for my macro but...

How to put Option Buttons on a Box like InputBox or MsgBox?

I don't like to put them o a spreadsheet, is it possible?

 

[mikerickson]

It sounds like you are looking for a userform.

http://contextures.com/xlUserForm01.html

 

[Trevor G]

Look in the VBA screen and select the Insert Menu and UserForm you can then use the design tools to build up a form with these controls.

 

[qwertysz]

Is the userform invisible?

I mean, it must appear only when I must choose one option but then disappear.. is it possible with the userform?

 

[mikerickson]

Where do you want the option button? On a userform?
"it must appear only when I must choose one option but then disappear"

I'm not sure how you want the user interface to function.

 

[qwertysz]

Hope I can let understand me...

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...

 

[mikerickson]

A userform could do that.

 

[Trevor G]

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.

 

[qwertysz]

Thanks a lot guys, have finally make it..