View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MichaelDavid MichaelDavid is offline
external usenet poster
 
Posts: 100
Default Unable to specify position of InputBox Method Dialog Box on the sc

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