View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Value in a inputbox

Sub AAA()
Dim sName As String
sName = "Smith"
sName = InputBox(Prompt:="Is this Name correct" & _
vbNewLine & "Please correct if wrong", _
Title:="Name Check", _
Default:=sName)
MsgBox sName
End Sub

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!
If i have a value like name in a variable
can't i get this value into a inputbox, like "is this name correct?"
and if isn't correct i can write a new name in the inputbix?

regards alvin