Warn the User of empty cell and indicate the location based on v Closed

Question

Hello,  
I am new to VBA. I have a problem which I believe is very simple, but I am failing foolishly. I have to generate a MsgBox warning the user to enter data in blank cells. I also have to mention the destination of the blank cell by indicating the parameters in the preceding column. For Example, In column A I have entered the name of the companies - Ferrari, Audi and Lamborghini, while in Column B I have mentioned their respective cars. In column C,D,E I have mentioned their sales figure for the months. If the user fails to enter the sales figure for one entry, I need to warn him when he checks the data validity. The message if the user leaves a cell empty should be: 

Please Enter the number of units of Lamborghini Aventador and Lamborghini Veneno sold. 

Actually in my excel file I have over a thousand rows for verification. Please help me out with this. 

Thanks in anticipation. Shalom Vineeth. 


Configuration: Windows 7 / Chrome 26.0.1410.64

Zohaib R · Answer

Hi Shalom Vineeth,

I have prepared a sample sheet. You can click on the "Validate" button on the sheet; an input box will prompt you to enter the range. Enter the range of data such as "A1:E7" and click "OK". This will highlight all the empty cells and a pop up will tell the address of each empty cell. You can download the sample file from here:

http://speedy.sh/33gqu/ValidateEmptyCells.xlsm

You can make the necessary changes in the code and the sheet to suite your needs.

Zohaib R · Answer

Hi shalom1506,

As per forum rules on en.kioskea.net I will not be able to take this conversation to personal email address. I have checked the file and it opens correctly. This file was created using Microsoft Excel 2010 for Windows. Try using a different computer and see if you can download the file.

Warn the User of empty cell and indicate the location based on v

2 responses

Similar discussions

Subscribe To Our Newsletter!