View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default New to Visual Basic

You add a button to the worksheet and call it CommandButton1. Then you click
it.

--
__________________________________
HTH

Bob

"Need help with sumif" wrote
in message ...
I wrote this simple task can anyone tell me how do I run this

Private Sub CommandButton1_Click()
Dim sName As String
sName = InputBox("Enter your name", "Title")
Cells.Value("A1") = sName
End Sub