View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
James Montgomery James Montgomery is offline
external usenet poster
 
Posts: 17
Default InputBox Screen Position

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


"Tom Ogilvy" wrote in message
...
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

--
Regards,
Tom Ogilvy


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

"Frank Kabel" wrote in message
...
Hi
have a look i the VBA help at 'Inputbox'. there're the parameters xpos
and ypos to do just this

--
Regards
Frank Kabel
Frankfurt, Germany

"James Montgomery" schrieb im Newsbeitrag
...
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