Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Position screen at end of macro | Excel Discussion (Misc queries) | |||
Can I fix the position of an object on the screen? | Excel Discussion (Misc queries) | |||
screen position indication? | Excel Discussion (Misc queries) | |||
Position of Cell on Screen | Excel Programming | |||
Position of Message Box on screen | Excel Programming |