userform combobox fills from selection on sheet

**snb** · 11-26-2011, 07:36 AM

or:

Sub Userform_Initialize()
  for j=1 to 5
   me("Combobox" & j).list=sheets(1).range("B4:B13").value
  next
End Sub

**mdshotgun** · 11-26-2011, 04:07 PM

Thanks again for the code and help.

@snb for some reason your code does'nt work.It just fills the comboboxes with all the fruits.

@steffen your code is giving an error.

Thanks anyway for trying.

userform combobox fills from selection on sheet

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: userform combobox fills from selection on sheet

Re: userform combobox fills from selection on sheet

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions