Quick question...

I am in the process of designing a User Form that will contain severa
different drop down boxes. Ideally, I would like the dropdown’s t
reference a list of cells on a visible worksheet within the workbook i
order for user’s to easily update “employee names”, “departments”, etc
as opposed to having to alter code [ e.g. .AddItem “Joe Blow” ].

I am familiar with adding “Input Ranges” when using Forms/Combo Boxe
but am uncertain how to proceed in a User Form environment. An
information you may be able to provide would be greatly appreciated.
Thanks in advance…..

Mik

--
Message posted from http://www.ExcelForum.com

You can use following code

Private Sub UserForm_Initialize()
ComboBox1.RowSource = Range("My_Range").Address
End Sub


meflorence < wrote:
Quick question...

I am in the process of designing a User Form that will contain several
different drop down boxes. Ideally, I would like the dropdown’s to
reference a list of cells on a visible worksheet within the workbook in
order for user’s to easily update “employee names”, “departments”, etc.
as opposed to having to alter code [ e.g. .AddItem “Joe Blow” ].

I am familiar with adding “Input Ranges” when using Forms/Combo Boxes
but am uncertain how to proceed in a User Form environment. Any
information you may be able to provide would be greatly appreciated.
Thanks in advance…..

Mike


---
Message posted from http://www.ExcelForum.com/

Mike,

Userform comboboxes have a RowSource and ControlSource property that you can
point at a worksheet range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"meflorence " wrote in message
...
Quick question...

I am in the process of designing a User Form that will contain several
different drop down boxes. Ideally, I would like the dropdown's to
reference a list of cells on a visible worksheet within the workbook in
order for user's to easily update "employee names", "departments", etc.
as opposed to having to alter code [ e.g. .AddItem "Joe Blow" ].

I am familiar with adding "Input Ranges" when using Forms/Combo Boxes
but am uncertain how to proceed in a User Form environment. Any
information you may be able to provide would be greatly appreciated.
Thanks in advance...

Mike


---
Message posted from http://www.ExcelForum.com/