Row deactivate event

tiredofit

Well-known Member
Joined
Apr 11, 2013
Messages
1,185
Is there a rows deactivate event?

When my users insert a row, I want to prevent them from moving to another row until the cell in the column A of the newly inserted contains a value.

Thanks
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
No, there isn't.
 

tiredofit

Well-known Member
Joined
Apr 11, 2013
Messages
1,185
Can you suggest a workaround?

Best I can think of is the Worksheet_Change kicks in and checks for blanks in column A.
 
Last edited:

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
34,966
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS
That would be one way. Best way will depend entirely on the circumstances.
 

Watch MrExcel Video

Forum statistics

Threads
1,099,044
Messages
5,466,213
Members
406,473
Latest member
Dunno123

This Week's Hot Topics

Top