Disallowing a blank text box

  • Thread starter Thread starter Kristen
  • Start date Start date
K

Kristen

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple SUM's in a column 15
Eliminate blanks while copy row and transpose 11
hiding blank rows 3
Excel Concatenate with line breaks but ignore blank cells 3
Create if partial match then copy and paste data from one cell to another 1
Deleting near-duplicate records that differ only by blanks 3
Eliminate blank row at top of Text Box entries 3
select a certain range of data 3

Back
Top