View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Umlas Bob Umlas is offline
external usenet poster
 
Posts: 301
Default Problem with ComboBox

Works fine for me. Are you entering Sheet2!A1:A2000 in the Rowsource??


"TimN" wrote in message
...
I am trying to set the range for my combobox which is on a user form. I

want
to define a range on Sheet2 of A1:A2000 as the list of possible choices

for
the comboBox.

When I go to properties every thing I try results in an error "Could Not

Set
The Row Source Property. Invalid Property Type".

How do I define the range for my comboBox?