| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need code to run when user changes value in cell
Use a worksheet_change macro with a select case statement within.
-- Don Guillett SalesAid Software "Grd" wrote in message ... Hi everyone, I need to change the color of a cell based on the value the user types in the cell. In this cell B2. If they type ON then it should be blue, BC red, AL yellow, NS green and PEI pink. I can't use conditional formatting from the menu because its only got three conditions I could be using many more. Also I don't know how code can run automatically when a person changes the value of a cell in a sheet. Could anyone help Thanks Suzanne |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA Code to have User input data for cell | Excel Discussion (Misc queries) | |||
| making NT user/login user appear in a cell | Excel Worksheet Functions | |||
| How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
| How do I format a cell, so the user must use a user calendar? | Excel Discussion (Misc queries) | |||
Threaded Mode
