Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
@ symbol
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
@ symbol
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. -- Regards, Tom Ogilvy "dave" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Type a symbol useing shortcut keys rather the insert a symbol | Excel Discussion (Misc queries) | |||
Euro symbol displays as dollar symbol in Excel | Excel Worksheet Functions | |||
SYMBOL ¦please help how do i do this symbol without copy/pasting i | Excel Worksheet Functions | |||
what shortcut key do I use for the + symbol over the - symbol | Excel Discussion (Misc queries) | |||
I need a symbol but "symbol" in the Insert menu is grayed-out. | Excel Discussion (Misc queries) |