Message Box Execution

M

Myrna Rodriguez

Hi~

Please help VB debuggers...

I have a textbox inside a frame.
In addition, I validated the textbox to prompt a message
box "enter text" if textbox is empty when OK Button is triggered.
I did enter text in the textbox and the message box still displays after
executing code in OK Button.

This is code I wrote for textbox:
Private Sub txtoffice_Exit(ByVal Cancel As MSForms.ReturnBoolean)
'display msg if textbox office is empty
If txtoffice.Text = "" Then
MsgBox "Enter Office Location"
Cancel = True
End If
End Sub

Thanks in advance for helping & have a happy day!!


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
 
B

Bob Phillips

Try adding this in

Private Sub Frame1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
txtoffice_Exit Cancel
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

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

Top