A really dumb question about combo boxes

[Dave]

Hi All:

This shouldn't be this hard to figure out (I must be having a bad hair day).

How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

It seems that no matter what I try I can't make the combo box list the data I need.

Thanks

Dave

[Aladin Akyurek]

On 2002-04-20 07:10, Dave wrote:
Hi All:

This shouldn't be this hard to figure out (I must be having a bad hair day).

How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

It seems that no matter what I try I can't make the combo box list the data I need.

Thanks

Dave

Use the Search facility if this board with combo to find a few threads where I describe how it's done using View|Toolbars|Forms.

[Ian Mac]

On 2002-04-20 07:10, Dave wrote:
Hi All:

This shouldn't be this hard to figure out (I must be having a bad hair day).

How do I use a combo box, on a user form, to display a range of cells from a work sheet named "Lists" with a range of A2 to the last cell with a value?

It seems that no matter what I try I can't make the combo box list the data I need.

Thanks

Dave

Goto Insert>Name>Define
Type something like D_List
in the Refers to box type:

=OFFSET(Lists!$A$2,0,0,COUNTA(Lists!$A:$A)-1)

in the Visual Basic Editor bring up the Properties box
Highlight the Combobox
In the RowSource in the proporties and type =D_List

[Dave]

Hi:

Thanks for the input! Works the way it should now.....Talk about making a guy feel stupid...

Thanks

Dave