[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Inputbox Location on Screen. Can you code it to popup lower on the screen ?

Corey

12/13/2006 10:05:00 PM

I have an inputbox for entering info when the code is run.
However, the user needs to enter a value that is displayed on the worksheet
the inputbox is run from.
But the inputbox positions itself exactly over the values that are displayed
on the worksheet, and therefore prevent the user being able to view the
values.
Is there a code to position the inputbox, still in the centre but down lower
on the sreen ?

Corey....


3 Answers

Corey

12/13/2006 10:30:00 PM

0

Never mind.
Found the X/Y positioning.

:-)

"Corey" <me@work.still> wrote in message
news:e4IU9KwHHHA.3780@TK2MSFTNGP02.phx.gbl...
>I have an inputbox for entering info when the code is run.
> However, the user needs to enter a value that is displayed on the
> worksheet the inputbox is run from.
> But the inputbox positions itself exactly over the values that are
> displayed on the worksheet, and therefore prevent the user being able to
> view the values.
> Is there a code to position the inputbox, still in the centre but down
> lower on the sreen ?
>
> Corey....
>


Gord Dibben

12/13/2006 10:43:00 PM

0

Corey

Help on Inputbox shows you can adjust the xpos and ypos

InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

The pos numbers are Twips......1440 twips per inch

Try this.......

Sub hoohah()
mybox = InputBox("Move it down a bit", , , 5000, 5000)
End Sub

Experiment with the position numbers to get it where you want.

0,0 is top left corner


Gord Dibben MS Excel MVP


On Thu, 14 Dec 2006 09:05:17 +1100, "Corey" <me@work.still> wrote:

>I have an inputbox for entering info when the code is run.
>However, the user needs to enter a value that is displayed on the worksheet
>the inputbox is run from.
>But the inputbox positions itself exactly over the values that are displayed
>on the worksheet, and therefore prevent the user being able to view the
>values.
>Is there a code to position the inputbox, still in the centre but down lower
>on the sreen ?
>
>Corey....
>

Corey

12/13/2006 11:34:00 PM

0

What about for a Message Box???
AND a
Yes/No box ???
There does not seem to be a x/y Pos.


Corey....



"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:v701o29l74fqvgjmurukr0gdg1g85977ar@4ax.com...
> Corey
>
> Help on Inputbox shows you can adjust the xpos and ypos
>
> InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile,
> context])
>
> The pos numbers are Twips......1440 twips per inch
>
> Try this.......
>
> Sub hoohah()
> mybox = InputBox("Move it down a bit", , , 5000, 5000)
> End Sub
>
> Experiment with the position numbers to get it where you want.
>
> 0,0 is top left corner
>
>
> Gord Dibben MS Excel MVP
>
>
> On Thu, 14 Dec 2006 09:05:17 +1100, "Corey" <me@work.still> wrote:
>
>>I have an inputbox for entering info when the code is run.
>>However, the user needs to enter a value that is displayed on the
>>worksheet
>>the inputbox is run from.
>>But the inputbox positions itself exactly over the values that are
>>displayed
>>on the worksheet, and therefore prevent the user being able to view the
>>values.
>>Is there a code to position the inputbox, still in the centre but down
>>lower
>>on the sreen ?
>>
>>Corey....
>>
>