loubeelou

New Member
Joined
Nov 23, 2009
Messages
32
As an A Level ICT Student, I have been told to push my spreadsheet to as high a standard as I can. I've been asked to find out how to create an Error Message that will show up if a cell is empty when a button is pressed, as we have created an input form type set up. Simple solutions would be appreciated :)
 

Some videos you may like

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Hello and welcome to MrExcel.

Press ALT + F11 to open the Visual Basic Editor, select Module from the Insert menu and paste in

Rich (BB code):
Sub Check()
If Range("A1").Value = "" Then MsgBox "A1 is empty", vbExclamation, "Error check"
End Sub

Change A1 to the cell you want to check. Press ALT + Q to return to your sheet, add a button from the Forms toolbar and when prompted assign it to the Check macro.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,212
Messages
5,623,420
Members
415,974
Latest member
ZorroOP

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
Top