Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
t_nellis
 
Posts: n/a
Default Can a conditional cell formula reference data selection in a comb.

I am setting up a conditional formula that changes depending upon the day of
the week that it is processed on. Can a combo box's value selection be
referenced in a cell fomula?
  #2   Report Post  
PCLIVE
 
Posts: n/a
Default

I'm sure someone else will answer you more clearly than myself. However,
you can set your combo box selection to a 'Linked Cell'. This will be the
cell you want your selection to show up in. The linked cell is set within
the Combo Box properties.

Once you've linked a cell for your results, you can then reference that cell
in whatever formula you want.

HTH,
Paul

"t_nellis" wrote in message
...
I am setting up a conditional formula that changes depending upon the day
of
the week that it is processed on. Can a combo box's value selection be
referenced in a cell fomula?



Reply
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
Formula with text and reference to a date cell [email protected] Excel Discussion (Misc queries) 1 January 11th 05 08:15 AM
inserting data from a row to a cell, when the row number is specified by a formula in a cell [email protected] New Users to Excel 2 January 6th 05 07:18 AM
How do I do conditional format based on a cell with a formula? Justin Excel Worksheet Functions 9 December 17th 04 02:05 PM
Look Up and Cell Reference - Formula Help Needed Janine Excel Worksheet Functions 1 December 14th 04 04:01 PM
Using a formula in a Hyperlink Cell reference sslabbe Excel Discussion (Misc queries) 4 December 10th 04 12:30 AM


All times are GMT +1. The time now is 10:11 AM.

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

About Us

"It's about Microsoft Excel"