Thread: Looping through different comboboxes in an excel sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default Looping through different comboboxes in an excel sheet
did you try UserForm1.ComboBox(j).
or UserForm1.ComboBox & j
" wrote:


Unfortunately I am not pleased with the userform approach and want to
do everything within an excel worksheet however vba within the excel
worksheet will not recognize the Controls("ComboBox" & j) portion of

Reply With QuoteReply With Quote