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?

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?

Duhhh I didn't put the "!"

I am trying to get the code to allow my list to be the selection that the
user chooses from and the selected number goes to cell C3. Any ideas?

"Bob Umlas" wrote:

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?