Warn the User of empty cell and indicate the location based on v
Closed
shalom1506
Zohaib R
- Posts
- 5
- Registration date
- Thursday March 21, 2013
- Status
- Member
- Last seen
- April 29, 2013
Zohaib R
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Related:
- Warn the User of empty cell and indicate the location based on v
- Finding certain words in a cell and return a value based off the word found. ✓ - Forum - Excel
- Excel warning message based on cell value ✓ - Forum - Excel
- How to display warning/alert messages if cells are blank in excel vba ✓ - Forum - Excel
- Check if cells are blank or zero help please - Forum - Excel
- Hi i am a regular user of facebook - Forum - Facebook
2 replies
Zohaib R
Apr 19, 2013 at 02:56 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 19, 2013 at 02:56 AM
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.
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
Apr 30, 2013 at 12:13 AM
- Posts
- 2368
- Registration date
- Sunday September 23, 2012
- Status
- Member
- Last seen
- December 13, 2018
Apr 30, 2013 at 12:13 AM
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.
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.
Apr 29, 2013 at 01:54 PM
Thanks once again for the reply..