Thread
:
name validation
View Single Post
#
2
Posted to microsoft.public.excel.programming
jhyatt
external usenet poster
Posts: 61
name validation
try this
Sub entername()
If b1 = "" Then
b1 = InputBox("enter your name", "yourname here")
Else
MsgBox "name in place, continue(or something like that"
End If
Worksheets("Sheet1").Range("b1").Activate
ActiveCell = b1
End Sub
Reply With Quote
jhyatt
View Public Profile
Find all posts by jhyatt