View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DangerMouse
 
Posts: n/a
Default Mask Drop Down List values


Hi all,

Just a quick question, is it possible to mask the values in a
validation drop down list?

I'm using the indirect function in many of my formulas and wish the
user to select the appropriate cell reference from a drop down list.

Thus A-Z is placed into formulas using INDIRECT however I would rather
more descriptive values in my drop down.

Is this possible?

Cheers


--
DangerMouse
------------------------------------------------------------------------
DangerMouse's Profile: http://www.excelforum.com/member.php...o&userid=27755
View this thread: http://www.excelforum.com/showthread...hreadid=550961