Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Location on Screen. Can you code it to popup lower on the screen ?
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.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Location on Screen. Can you code it to popup lower on the screen ?
Never mind.
Found the X/Y positioning. :-) "Corey" wrote in message ... 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
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Location on Screen. Can you code it to popup lower on the screen ?
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" 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.... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inputbox Location on Screen. Can you code it to popup lower on the screen ?
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 ... 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" 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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to Eliminate Circular Rerference Popup Screen? | Excel Discussion (Misc queries) | |||
Update Values popup screen | Excel Discussion (Misc queries) | |||
on my screen lower left, it says calculate - to the right of "read | Excel Discussion (Misc queries) | |||
InputBox Screen Position | Excel Programming | |||
Getting around Initials popup screen | Excel Programming |