View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Alvin Hansen[_2_] Alvin Hansen[_2_] is offline
external usenet poster
 
Posts: 209
Default Value in a inputbox

Thanks again tom its working

regards
alvin


"Tom Ogilvy" skrev:

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