| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent user input, if adjacent cell text is identical
My worksheet has cells that contain text - Such as 'INF', 'STO', and
'BAC' etc... Some of these cells are merged into as many as 9 cells (vertically). I am trying to prevent the same text being input into the adjacent single or merged cell (which is offset to the right by ONE cell). So, if a merged cell comprises of ("D5:D10") and contains the text 'STO', I want to prevent the user from entering 'STO' in ("E5:E10") etc... The cells can contain other text, but i want to prevent only 'INF', 'STO', and 'BAC' from being input. All other text is OK. The cells are currently populated by a Userform ComboBox1. Can anybody please help? Thanks Mik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to prevent text overflow into adjacent blank cells | Excel Discussion (Misc queries) | |||
| Find duplicate, but only if an adjacent cell is identical | Excel Worksheet Functions | |||
| Have user input converted to uppercase in same cell as input? | New Users to Excel | |||
| Delete cell contents with input to adjacent cell | Excel Discussion (Misc queries) | |||
| Loop through for condition and input in adjacent cell | Excel Programming | |||
Threaded Mode
