LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default set cell values based on selection from list

I have a list of four options in a cell. I want to control a set of
destination cell values based on the user selection of the options from
the list. As an example: option 1 sets the destination cell values to
some numbers, where as option 2 may set the values of very same
destination cells to some other numbers.
When user selects an option from this list I want to do the following:
1) Initially reset the destination cells to zeroes
2) If user sets some values in those destination cells, I want to
remember the user set destination cell values, as applicable to
selected option and display it next time.
I am sure this has been discussed and solved problem. I am new to this.
Can someone give the right examples?

Thanks
Rao

 
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
Calculating values based on selection from a drop-down list in Exc Razzamatazz Excel Worksheet Functions 3 July 12th 08 05:11 PM
List box change values based on selection Cam Excel Discussion (Misc queries) 0 March 17th 08 01:38 PM
Excel - Sum of Values based on adjacent list selection Beki Goodwin New Users to Excel 1 April 24th 07 11:58 PM
limit cell list selection based on the selection of another list lorraine Excel Worksheet Functions 2 December 14th 04 08:17 PM
Selection based on values in a cell Stewart[_2_] Excel Programming 1 September 3rd 03 12:40 PM


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