Value in a inputbox

[Guest]

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

 

[Guest]

A message box is probably a better option. The code would be similar to this...

dim intReturnValue as integer

intReturnValue = msgbox("Is the name " & myVariable & " Correct?", vbYesNo,
"Confirm Name")

if intreturnvalue = vbyes then
...
else

 

[Tom Ogilvy]

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

 

[Guest]

Thanks again tom its working

regards
alvin


"Tom Ogilvy" skrev: