msgBox problem

**bernie1961** · 05-20-2008, 08:21 AM

I am trying to have a message box show when a user fails to fill in a required text box in a user form, however the box does not pop up and I am getting no error messages as to an incorrect code. Here is what I'm using:

Please Login or Register  to view this content.

Thanks for any feedback!
Bernadette

**mudraker** · 05-20-2008, 08:32 AM

It would help if you told us what line of code you are getting the error on

Instead of the following command (which I am assuming is causing your problem)

Please Login or Register  to view this content.

You are probally wanting

Please Login or Register  to view this content.

What is the purpose of this command

Please Login or Register  to view this content.

TextBox2.Value is already the same as TextBox2.Text

**davesexcel** · 05-20-2008, 08:37 AM

Originally Posted by bernie1961

I am trying to have a message box show when a user fails to fill in a required text box in a user form, however the box does not pop up and I am getting no error messages as to an incorrect code. Here is what I'm using:

Please Login or Register  to view this content.

Thanks for any feedback!
Bernadette

Hi Bernadette,
The msgbox works if you use the exit
Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)

**bernie1961** · 05-20-2008, 08:53 AM

Thanks Dave and Mudraker....

Dave - That certainly did fix the problem!! Thanks so much!

Mudraker - SetFocus did make more sense to use as well as deleting the "TextBox2.Value = TextBox2.Text" line of code. (I actually was not getting an error message when I ran my code, so I had nothing to tell me where my error may be....) Thank you for your help!

Bernadette

msgBox problem

LinkBack

Thread Tools

Rate This Thread

Display

msgBox problem

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions