View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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