Validating entry in user form

[Debo333]

Hello,

I am trying to force entry into a user form after a comman button OKclick which performs a series of functions.

If a textbox is empty I want a msgbox to pop up telling the user to please enter "name" for example. When using If txtname.value = "" then msgbox"please enter a name" after the message box ok button is clicked the macro continues. Ideally the sub should end or "pause" and a pH value entered, forcing the user to click the commandbuttonOk again. Please let me know if you can help! Thank you for your time.

 

[Macropheliac]

Try this:

If txtname.Text = "" Then
        MsgBox "please enter a name"
        Exit Sub
End If

 

[Debo333]

Awesome, I knew I had the right idea but am new to VB so I consistently struggle with the text.


Thanks Much!

 

[micromagnet]

Hello,

Does anyone know the code to prevent the user from advancing to the next entry without making an entry? (setfocus? maybe) I have the same situation as Debo333 and the msg comes up fine telling user to enter a name, but you can tab to the next entry. I would like a code that prevents user from moving forward until an entry has been made. Thanks.

 

[Norie]

micromagnet

Why don't you create a new thread?

 

[micromagnet]

Thanks Norie for the input. I thought it might be easier to add to this thread, plus I don't know how to reference a past thread. Anyway, I was able to figure out the code. For those needing:

Cancel = True