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