Microsoft Office Forums - View Single Post - [Solved] If id cell range is empty then should not allow to fill any other cell

Thread: [Solved] If id cell range is empty then should not allow to fill any other cell

View Single Post

Old

04-10-2015, 06:11 PM

ubns

ubns is offline

ubns uses Windows 7 32bit

Windows 7 32bit ubns uses Office 2010 32bit

ubns uses Office 2010 32bit

Office 2010 32bit

Competent Performer

The original poster

Join Date: Apr 2012

Posts: 177

ubns is on a distinguished road

Default

If id cell range is empty then should not allow to fill any other cell

Hi,

I have ID cell Range from a5:a1000, and I want if the user starts filling in any other adjacent cells in that row where id cell range is empty then it should not allow them and message box should pop up that fill in the id cell with cell number.

Is it possible?

Reply With Quote