View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
meflorence[_3_] meflorence[_3_] is offline
external usenet poster
 
Posts: 1
Default Data Input - User Form Drop-Down Box

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