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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Corey - 13 Dec 2006 22:05 GMT

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....

Reply to this Message

Corey - 13 Dec 2006 22:29 GMT

Never mind.
Found the X/Y positioning.

:-)

>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
[quoted text clipped - 6 lines]
>
> Corey....

Reply to this Message

Gord Dibben - 13 Dec 2006 22:42 GMT

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

>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
[quoted text clipped - 6 lines]
>
>Corey....

Reply to this Message

Corey - 13 Dec 2006 23:33 GMT

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

Corey....

> Corey
>
[quoted text clipped - 30 lines]
>>
>>Corey....

Reply to this Message