Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
redb
 
Posts: n/a
Default change info in 1 cell, prompts you for another

I would like to have a promt or some type of notice that when a user changes
the information in cell B15 that it might be necessary to change the
information in B25.

Ideally, I would want a popup box/notice that says "You've changed the
information within, would you like to change XX as well?"

Realistically, I would settle for a simple change in cell colour or
something similar to indicate that more changes may be needed.

Does anyone have any ideas? Thanks!
  #2   Report Post  
NlCO
 
Posts: n/a
Default


Hi, it's very simple, you should select the cell that you want to have
the pop up, then go to Data Validation Imput Message.

Put there the message you want and that's all.

Saludos NlCO


--
NlCO
------------------------------------------------------------------------
NlCO's Profile: http://www.excelforum.com/member.php...o&userid=26123
View this thread: http://www.excelforum.com/showthread...hreadid=401077

  #3   Report Post  
paul
 
Posts: n/a
Default

take a look at datavalidation.You can have a prompt that appears a soon as
the cell is selected
--
paul
remove nospam for email addy!



"redb" wrote:

I would like to have a promt or some type of notice that when a user changes
the information in cell B15 that it might be necessary to change the
information in B25.

Ideally, I would want a popup box/notice that says "You've changed the
information within, would you like to change XX as well?"

Realistically, I would settle for a simple change in cell colour or
something similar to indicate that more changes may be needed.

Does anyone have any ideas? Thanks!

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
cell color index comparison MINAL ZUNKE New Users to Excel 1 June 30th 05 07:11 AM
Cell Change Color - Need Help alani New Users to Excel 3 June 29th 05 03:50 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Cell references change when entering new data [email protected] New Users to Excel 2 May 6th 05 07:48 PM
Change cell color dependin on date ... T. Denford Excel Worksheet Functions 4 April 13th 05 01:59 AM


All times are GMT +1. The time now is 04:46 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"