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

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
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,214,376
Messages
6,119,179
Members
448,871
Latest member
hengshankouniuniu

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