| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Cursor Active in Cell via VB Script
I have a VB script that runs to validate the string length of a cell and if
the lenght exceeds the standard I open a message box to indicate the error. When the user presses OK I want the cursor to be active in the cell with the error. I am using the following: Target.Cells.Activate But this only makes the cell active it does not open the cell for edit. If the user moves to the next cell I don't capture the problem because they didn't make a change in the cell. Is there a Target.Cells.Edit or something that will open the cell with the cursor in it? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| run macro although blinking cursor is active in an active cell | Excel Programming | |||
| How do I make it so that the active cell follows the cursor keys? | Excel Discussion (Misc queries) | |||
| How do I move cursor in an active cell without using delete/backsp | Excel Discussion (Misc queries) | |||
| Writing Macro - How to get the cursor/Active Cell back to top of W | Excel Programming | |||
| script detecting the change of active cell | Excel Programming | |||
Threaded Mode
