move input box

agjohnson · Feb 26th, 2002, 08:23 AM

I have created an input box however when the macro is engaged the input box covers the information that is being entered. How can I move the input box over?

Mudface · Feb 26th, 2002, 08:28 AM

Take a look at the InputBox entry in VBA help, you can specify the starting position of the box on the screen.

NateO · Feb 26th, 2002, 09:13 AM

Like this:

f = InputBox(prompt:="Enter Stuff", Title:="Yallo!", xpos:=1, ypos:=1)

define your x & y positions (this is the upper right of the screen).

Cheers, Nate

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

Feb 26th, 2002, 08:23 AM	#1
agjohnson New Member Join Date: Feb 2002 Posts: 4	I have created an input box however when the macro is engaged the input box covers the information that is being entered. How can I move the input box over?

Feb 26th, 2002, 08:28 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Take a look at the InputBox entry in VBA help, you can specify the starting position of the box on the screen.

Feb 26th, 2002, 09:13 AM	#3
NateO Legend Join Date: Feb 2002 Location: Minneapolis, Mn, USA Posts: 9,704	Like this: f = InputBox(prompt:="Enter Stuff", Title:="Yallo!", xpos:=1, ypos:=1) define your x & y positions (this is the upper right of the screen). Cheers, Nate