S
simonsmith
Hi Guys,
I need to generate a lot of data and am wondering if a macro can help
to select the combo boxes for me. I have a "main" subject combo box and
then 4 "sub set" combo boxes under this
eg
Main Combo - Drinks
Choices Coffee, Tea, wine , beer
sub Combo 1 - Temperature
Hot, cold, chilled, room temperature
sub Combo 2 - Cost
$1,$2,$3
sub Combo 3 - Drink with
Cookie, crisps, apple,
(unlike this example all combinations are valid!!)
So each main topic must be manually selected, then every combination
under it gone through with a "macro" selecting the sub set combos. Once
each combination is selected an existing macro button is pushed to
generate the data based on the combo box selections, the process is
then repeated (next main subject selected manually all sub set
combinations gone through and data generated for each...)
FYI
the combo boxes already have small macros attached to them for other
things
Any ideas!!?
Cheers
Simon
I need to generate a lot of data and am wondering if a macro can help
to select the combo boxes for me. I have a "main" subject combo box and
then 4 "sub set" combo boxes under this
eg
Main Combo - Drinks
Choices Coffee, Tea, wine , beer
sub Combo 1 - Temperature
Hot, cold, chilled, room temperature
sub Combo 2 - Cost
$1,$2,$3
sub Combo 3 - Drink with
Cookie, crisps, apple,
(unlike this example all combinations are valid!!)
So each main topic must be manually selected, then every combination
under it gone through with a "macro" selecting the sub set combos. Once
each combination is selected an existing macro button is pushed to
generate the data based on the combo box selections, the process is
then repeated (next main subject selected manually all sub set
combinations gone through and data generated for each...)
FYI
the combo boxes already have small macros attached to them for other
things
Any ideas!!?
Cheers
Simon