@ symbol

  • Thread starter Thread starter dave
  • Start date Start date
D

dave

i have a VBA form and i need to make sure the user enteres
an @ symbol in a text box

any help will be great

thanks
 
in the exit event

Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
if instr(Textbox1.Text,"@") = 0 then
msgbox "Please enter an @ symbol"
Cancel = True
End if
End Sub

You might want to put a similar check in the code that will drop the
userform.
 
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

vba macro that allows insertion of symbols at cursor 0
Excel Count If Formula Question 1
Active XText box vbcr shows symbol instead of an actual carraige return 2
Macro to cause a password to display ooooo's or other symbols 2
Display Math Symbols in UserForm 1
Whan a letter is entered it changes to a symbol that is the value ofa different cell 12
Converting Consumer Reports rating symbols to numbers 6
Assign a value to a variable by next selected cell? 3

Back
Top