InputBox Screen Position

[James Montgomery]

Hi,

Can position X & Y screeen positions be added to the InputBox code below the
way it's written.

userExciseTaxNo = InputBox("Enter sales tax number. Example Format:" &
Chr(13) & _
"Enter .06125 for 6.125% " & Chr(13) & Chr(13) & _
"Press enter Or Click 'OK'", "Enter Tax Amonut",
startExciseTaxNo)

Thanks

 

[Frank Kabel]

Hi
have a look i the VBA help at 'Inputbox'. there're the parameters xpos
and ypos to do just this

 

[James Montgomery]

Hi Frank,
I have added the parameter as explained in VBA help but it seems the "
startExciseTaxNo)
" at the end becomes a problem
James

 

[Tom Ogilvy]

Sub Tester1()
Dim msg As String
msg = "Enter sales tax number. Example Format:" _
& Chr(13) & "Enter .06125 for 6.125% " _
& Chr(13) & Chr(13) & "Press enter Or Click 'OK'"

serExciseTaxNo = InputBox(Prompt:=msg, Title:= _
"Enter Tax Amonut", Default:=startExciseTaxNo, _
xPos:=1000, yPos:=1000)
End Sub

 

[James Montgomery]

Thanks Tom
I like the way you also did the msg part of it
James