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
Bookmarks