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