LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
can you make a drop down list in a drop down list? Sburlingham Excel Discussion (Misc queries) 18 October 12th 09 07:58 AM
drop down list help tech_2006 Excel Worksheet Functions 1 February 16th 06 07:59 PM
multiple select from the drop down list in excel. list in one sheet and drop down in sriramus Excel Discussion (Misc queries) 5 October 27th 05 06:55 PM
Refreshing drop down cell values... Dyce Excel Worksheet Functions 0 August 24th 05 10:49 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 06:37 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"