Thread: listbox
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default listbox

try doing it manually 1st until you get the format correct. Makesure the
Properties window shows the name of the Listbox when you add the RowSource.
don't use double quotes when you put the sheet name and cell range into the
RowSource box.

The try it from code. for testing you can read the setting by using a msgbox

msgbox("Source = " & userform1.listbox1.RowSource)

Make sure the names of the userform and listbox are the same as your code.

"eggpap" wrote:

I followed your tip but I get
a message similar to the following:
Impossible to set the rowsource property. Property value is not valid.

Emiliano