LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default How to control if a cell references versus list box or another cel

I have created a validation list box where I can choose to make a selection
from the list box. However in some instances I would like to make the cell
reference another cell in another worksheet using the = command if that other
cell contains specific information, otherwise I would like it to show the
list box function.

Presently I have to do one or the other. Is there a way to do this?
--
Dan
 
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
convert relative cell references to absolute cell references via amacro? Dave F[_2_] Excel Discussion (Misc queries) 1 May 15th 08 04:43 PM
Autofilter versus List Arun Excel Discussion (Misc queries) 1 August 19th 07 09:09 PM
How to control cell references when copying a formula? rmmshost Excel Discussion (Misc queries) 8 February 23rd 07 08:04 PM
difference between comm control on win 98 versus windows xp ned Excel Programming 0 October 2nd 04 11:24 AM
Form versus Control Mark[_22_] Excel Programming 7 October 13th 03 09:37 PM


All times are GMT +1. The time now is 09:45 AM.

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"