Check for empty cells (prompt alert) for only new rows added

LearnExcel_Newbie

New Member
Joined
Dec 19, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi Excel gurus,
I am totally new to VBA and would like to get your advice on the following:

Background: An Excel tracker with the following sample fields is shared amongst multiple users to monitor hiring. Data is to be keyed in on an ongoing basis, adding of a few rows at the bottom when there are candidates/ new hires.

Output: To prompt a message alert box to user, only to the row he/she is keying in, with specific to columns say A, B, C when the cells are empty. E.g: User is now at row 100, but she left cell A100 blank. How can i have an alert prompt that A100 is blank?
(In this case, because B100 and C100 have data, so message alert box will only prompt for A100)


Please also include this condition: There are also cells on top which were left blank previously by other users, but Excel will only prompt for the new row being added, in this case Row 100, and specific to col.A, B, C when they are blank.

Your help is really appreciated, i have been trying to look for VBA codes to run but I do not know how, thank you so much for your help!!

Col. ACol. BCol. CCol. DCol. ECol. F
Row 1YearEntityRequest No.HR RMClusterName...
Row 22021ABC123JaneWestJoe O Reilly
Row 32021OCemptyemptyemptyJoy
...
Row 100
(Current user is on row 100)
emptyABC421JaniceNorthJanet
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top