Can an input box do this
hi
vb101.
but which cell to activate?????
Sub addname()
Dim n As String
Range("B1").Activate
n = InputBox("what is your name?")
ActiveCell.Value = n
End Sub
regards
FSt1
"Munchkin" wrote:
Can a macro button activate a cell, then have an an input box pop up that
asks a user to enter their name, and upon doing so & clicking OK place the
name in the activaed cell?
I'm self taught at Visual Basics & can't figure how to do this. Am I
misunderstanding input boxes - or can an input box do this, and if so, how?
|