Avatar of gdunn59

asked on 

In Excel if a particular cell is empty how can I keep users from entering data in 2 other fields

I have an excel worksheet with 13 columns.  I wanted to know how via VBA I could keep the user from entering data in 2 cells, if another specific cell is empty.

Empty Column/Cell:  InvElecHistoryID

2 Columns/Cell [DateSent] and [Comments] that data can't be entered into unless the Empty Column above has data.

Open in new window


Microsoft ExcelVBAVisual Basic Classic

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon