View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LaDdIe LaDdIe is offline
external usenet poster
 
Posts: 131
Default Userform Combo box to mimick Worksheet Cell validation list range.

Hi Everyone,

Is there a method which tells a Userform Combo box to mimick active
Worksheet Cell validation list range.

My worksheet contains data validation lists in various places,
I have designed a userform combo box, in order to 'quick search', but rather
than hard code the list range, I need the userform combo box to mirror the
data validation list range of the active cell.

Thanks.

LaDdIe