move input box

A

agjohnson

New Member
Joined
Feb 25, 2002
Messages
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?
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Sort by date Sort by votes
Take a look at the InputBox entry in VBA help, you can specify the starting position of the box on the screen.
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Set Focus Not Working
Replies
3
Views
89
Denny57
D
H
  • Question Question
Multiple user input value reference
Replies
6
Views
100
Hapakaya
H
M
  • Solved
Sheet code for input box and comment when cell contains certain value
Replies
7
Views
228
Peter_SSs
Peter_SSs
G
  • Solved
Combine input box (multiple criteria)
Replies
4
Views
77
gomes123
G
D
  • Solved
Date Issues with User Forms
Replies
4
Views
135
dmt32
D

Forum statistics

Threads
1,223,317
Messages
6,171,419
Members
452,402
Latest member
siduslevis

Share this page

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