Hi,

I am creating a user form, quite successfully so far, but need the
first text box to not allow the user to leave it blank.

The data writes to a table and if it is left blank it will overwrite it
the next time data is posted as it searches for the first blank cell in
column A and writes across the row from it. I guess one option is for
the program to search for a blank ROW rather than a blank cell in
column A.

Any help is appreciated!

Thanks
Kristen


--
Kristen
------------------------------------------------------------------------
Kristen's Profile: http://www.excelforum.com/member.php...o&userid=33199
View this thread: http://www.excelforum.com/showthread...hreadid=530182

Hi Kristen

Somthing like this, prompt the user to put in a value.

if textbox1 = "" then
msgbox "Enter a value"
TextBox1.SetFocus
endif

Regards Yngve