How can i move an input box

[WRECK]

Hi,

I am using Excel on Windows NT.

I have wrote a macro, and use a button to start it. When i hit the button input boxes pop up asking for the required data to put in the spreadsheet. However the input box is right on top of where the data is going in the spreadsheet. I would like to move it over a bit so i can see the data as it is entered. How can i do this. I move it by dragging it but it keeps on going back to the original position.

 

[Egress1]

Howdy,

InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

From the HELP file for VBA

 

[WRECK]

Hello, thanks for the help, but i am still having trouble. What are the square brackets for?

Right now my code for the input box looks like this

Northing = CDbl(Val(InputBox("Enter the Northing of your starting point", "Northing")))

Where do i have to put the xpos and ypos to make it work?

Thanks

 

[Egress1]

InputBox(prompt[, title] [, default] [, xpos] [, ypos] [, helpfile, context])

These are all arguments not all of them are required [] are not required.

Prompt = The message you want in the InputBox body.
Title = Name or Text On the Title Bar of the box
Default = This would be the default value that is assigned if the user just clicks OK without inputing anything.

Xpos
Ypos This is where you place your coordinates to place the box within your active window.

InputBox("What Is Your Name?", "Question Box", "John Doe",7500,5000,)

These can all be either constants or variables. Read the HELP file for more info and better example.

 

[Ivan F Moala]

Just to Add to Ken's Advice.......

Just highlight the Key Word eg "Inputbox" and Press F1

The Help file can be a good source.....THEN if you need to know more post back and I'm sure someone can help out.