for a combobox or listbox from the control toolbox toolbar,
on a worksheet
in design mode (upper left button on the control toolbox toolbar
depressed)
right click on the box and select properties
ListFillRange
Enter Sheet3!B9:B11 as an example
Get out of design mode
on a Userform
in the VBE, click on the box. Make sure the properties window is
visible (F4)
go to the rowsource property and enter
Sheet3!B9:B11

Or you can populate it with code. On a userform
Private Sub Userform_Initialize()
With Combobox1
.AddItem "Yes"
.AddItem "No"
.AddItem "Pending"
End With
End Sub

There is also a dropdown control on the Forms Toolbar. Beto gave you some
information on that. Post back if you need more.

--
Regards,
Tom Ogilvy

"Tibow" wrote in message
...
I'm having trouble using lists and combo boxes. Basically,
I'm new at using them.
I want a combo box/lists to have 3 values I can select,
Yes/No/Pending. I was thinking maybe lists/combos work
like validation, where you can store the value in the
control or on the worksheet, but can't get either way to
work. I've tried tinkering with row source and column
source but no luck.

Can anyone help me please....

Thanks