Data input box

Hi Bin,

Thank you for the forum question.

First of all I want to apology the late answer.

You can create a userform with any number of option buttons.

In the private module for the userform you can use a decision code (If Then Else or Select Case).

If me.OptionButton1=true then
call (macro name)
elseif me.OptionButton2=true then
call (macro name)
elseif me.OptionButton3=true then
call (macro name)
end if

You can also create a drop down list in a userform where the user can select the option and then again you can use a decision code to tell Excel what you want to happen when an option is selected.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector