Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings! I tried to position the InputBox Method Dialog Box on the screen
by varying the values of Left and Top in its parameter list. No matter what values I select for Left and Top, the Input Box Method's Dialog Box displays in the middle of the screen about a third of the way down. (I tried values ranging from 0 to 5000, and also negative numbers and real numbers as well.) Otherwise the InputBox Method works perfectly. The code is as follows: PricesFoundMsg = MessageDateM2 & vbCrLf & _ MessageDateM1 & vbCrLf & _ MessageSameDate & vbCrLf & _ MessageDateP1 & vbCrLf & _ MessageDateP2 & vbCrLf & vbCrLf & _ "Enter desired price" SelectPrice = Application.InputBox(Prompt:=PricesFoundMsg, Title:="Select Price", Default:=DefaultPrice, Left:=1, Top:=1, Type:=1) The corresponding Input Box Function which uses XPos and YPos instead of Left and Top works perfectly. One is able to position the dialog box anywhere on the screen by varying XPos and YPos. But due to the way a cancel is handled by the Input Box Function, I have to use the Input Box Method. All suggestions and workarounds will be greatly appreciated. Thanks! -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.InputBox screen position doesn't work. | Excel Programming | |||
InputBox method with range | Excel Programming | |||
position of inputbox | Excel Programming | |||
InputBox Screen Position | Excel Programming | |||
Error 424 with inputbox method after OK | Excel Programming |