VBA Questions

[ghoff12]

I have two questions...both of them are in VBA

1) Is there a way i can embed a combo box directly in the cell. so it the combobox is exactly the same size as the cell it needs to go in.

2) the other quesiton is, since i can't use control arrays in VBA (at least i don't think so) is there an easy way to reference around 30 combo boxes.

IF yes, can i get an example.

thanks!

[davidrobin]

Don't know about the first question but with the second question you could use the 'For Each...Next' loop to enumerate through the controls.

dim ctl as control

for each ctl in form1.controls
   if TypeOf  ctl is ComboBox then
      ...
      do something
      ...
   endif
next

I am not at work at the moment and am without my vb so you will have to check on the syntax.