How to change size and location of Msgbox and Inputbox

bozack

New Member
Joined
Apr 9, 2002
Messages
9
I have a file that has a few Input Boxes and Msgboxes, is there any way that I can adjust the size or move the location of these boxes, since where thay are currently popping up they are blocking some critical data on the worksheet. I can move the critical info on the worksheet, but there a good amount of critical data and currently the boxes are popping up at the center of my worksheet and it would be a lot nicer if I could get the boxes to appear off to a corner of the screen.
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
Hello,
It is pretty easy to change the position of the inputboxes, when you write the code:
s=inputbox("Prompt","title","Default",0,0)
The two 0 represents the Xposition and Yposition on yourt screen. (0,0) meaning the top left corner.
Concerning the Msgbox, I don't know how to change their position, sorry.
Bye
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,541
Latest member
iparraguirre89

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top