Home » Blogs » mairep's blog

Requiring input into Excel fields

Submitted by mairep on 10 February, 2012 - 02:23

I need to know the VBA code to make sure a field is not allowed to be NULL. If data is not inputted the field should return an error message of "Input Required" on that field.

»
Nick's picture

if Range("A1").value = ""

Submitted by Nick on 10 February, 2012 - 09:00.

if Range("A1").value = "" then
msgbox "Input Required"
endif

»