cycle through comboboxs with an integer
Controls("Combobox" & i).value= .......
"whylite" wrote:
Just wondering if this is possible. I know the code I have writen so far
doesn't work but any idea's would be great.
sub mysub()
dim i as integer
dim e as string
e = 1
for i = 1 to 75
ComboBox & i.value = sheets("list").range("D"& e)
e = e + 1
next i
end sub
--
Thanks!
Shane W
|