| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Evalulate previous cell
Hi all,
How can I Eval cell value before allowing the user to move to the next cell. I.E. In A1:A6 the user enters a 5-6 Digit reference code (Mixure of Text&Number), if one of my reserved codes is used (I.E. A1234 or A5678 or B9999) then a warning pop-up and not allow the user to move to the next cell on the right. Either some solution as a formula or VBA will be fine. Thanks Laddie. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 3-Color Scale Vlookup for Current Month/Previous/Pre-Previous | Excel Discussion (Misc queries) | |||
| How can I copy a value from a cell and paste it into another cell while adding it to the previous value in that cell | Excel Worksheet Functions | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Threaded Mode
