How to change size and location of Msgbox and Inputbox

bozack · Apr 10th, 2002, 04:22 AM

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.

Community Development · Apr 10th, 2002, 05:28 AM

How do I change the font size in a drop-down input box?

paludgnp · Apr 10th, 2002, 05:31 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 04:22 AM	#1
bozack New Member Join Date: Apr 2002 Posts: 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.

Apr 10th, 2002, 05:28 AM	#2
Community Development New Member Join Date: Apr 2002 Posts: 1	How do I change the font size in a drop-down input box?

Apr 10th, 2002, 05:31 AM	#3
paludgnp New Member Join Date: Feb 2002 Location: Belgium Posts: 24	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