Bin has attended:
Excel VBA Intro Intermediate course
Access Introduction course
Access Intermediate course
Access Advanced course
Excel VBA Advanced course
Data input box
Hi Is there any macro can create a msgbox which ask questions to do a multiple answer based on the rawdata?
I have some text based raw data which listed some options under same field. I wonder if it would be possible that when i ran a macro which manipulate the layout of the rawdata also ask question on which one out of the list is the right one.
Hope its clear. let me know
Thanks
Bin
RE: Data input box
Sorry in above I meant to do a pop up window like msgbox which listed all the options and also ask the peron who has triggered the macro to chose one of the options. the options are based on the listed options from the raw data.
Thanks
Bin
RE: Data input box
Hi Do you have any reply on this one?
Thanks
Bin
RE: 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
