View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keaven keaven is offline
external usenet poster
 
Posts: 1
Default Adding the same content to multiple combo boxes

Okay.. here's the deal, i have a user form in excel that
gathers information. In one section there is a series of
six combo boxes. What i have been trying to do is have
code in the UserForm_Initialize() sub that adds items to
the combo boxes. All six combo boxes need the same
information added to them.

what i would like to do is something like:
for each X in (1,2,3,4,5,6)
with Me.ComboBoxX
.AddItem "a"
.AddItem "b"
end with
next

trying to get it to go through all 6 boxes.. but this is
not working and i cant figure out how to get it to work
without reapeating the .AddItem list for each and every
box. is there a faster way to do it?

-keaven