| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto updating cell values
Hey everyone, Quick question. Can anyone help me with writing this macro? I have spreadsheet, and in cell A2 is a value "100". In cell A3 is a list bo with YES and NO replies. If someone selects No from the box, I need th value of cell A2 left alone. But if someone selects YES from the list I need the value to automatically update to 99 (A2.value - 1). An help provided will be greatly appreciated!! Thoma -- dok11 ----------------------------------------------------------------------- dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058 View this thread: http://www.excelforum.com/showthread.php?threadid=26107 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell auto-updating | Excel Worksheet Functions | |||
| Updating an Auto-Filter depending on cell value | Excel Worksheet Functions | |||
| Updating Cell Values | Excel Discussion (Misc queries) | |||
| Cell formula not updating, auto calc on, over 100 sheets | Excel Discussion (Misc queries) | |||
| Cell showing the time auto updating | Excel Discussion (Misc queries) | |||
![dok112[_26_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
