Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default InputBox Screen Position

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default InputBox Screen Position

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default InputBox Screen Position

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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default InputBox Screen Position

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   Report Post  
Posted to microsoft.public.excel.programming
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









Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Position screen at end of macro Kevryl Excel Discussion (Misc queries) 3 June 3rd 10 06:54 AM
Can I fix the position of an object on the screen? Bob Arnett Excel Discussion (Misc queries) 0 October 27th 09 05:46 PM
screen position indication? nastech Excel Discussion (Misc queries) 1 August 17th 06 07:55 PM
Position of Cell on Screen pjhageman[_2_] Excel Programming 1 January 10th 04 07:36 PM
Position of Message Box on screen Hotbird Excel Programming 0 August 21st 03 06:46 PM


All times are GMT +1. The time now is 05:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"