View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Input Box Location

I am not technically acquainted with the two screen setup or how each screen
is normally selected withing the system. It just seemed to follow that if
the code was in the workbook that is opened in a given instance of Excel that
the dialog boxes and controls that are called from the code in that workbook
would appear in the same screen. Apparently not/

"AwesomeSean" wrote:

Yes.
I have the excel app. opened on screen 2. the alt+f11 usually opens vba on
screen 1 which is where I write the code. If I move excel to screen 1 then
close-re open, the box is where i want it. If i move to screen 2, close-re
open on screen 2, the pop up box stays on screen 1.

I am new to programming and just wanted to see if there was code to make the
input box always stay where the app is opened, even if I had 4 moniters.

Thank you for the quick response.

"JLGWhiz" wrote:

Is the workbook that contains the code opened in the same instance of the
application on screen 2? If not, it will probably go to the default screen.


"AwesomeSean" wrote in message
...
I have created a input box that works like it should, but always goes to
screen 1 on my 2 screen setup. If i launch excel into screen 2 the input
box
always pops up on screen 1. How can I make the input box follow the
application? here is the code I used:


Sub Enter_Week_Number()


Dim Response As Variant

Show_Box = True


While Show_Box = True


Response = InputBox("Please Enter Current Week Number.", _
"Number Entry", , 7000, 7000)



If Response = "" Then

Show_Box = True
Else
If IsNumeric(Response) = True Then
Worksheets("INSTRUCTIONS").Range("H5").Value = Response
Show_Box = False
Else
MsgBox "Please Enter Numbers Only"
End If
End If
Wend

End Sub

Thank you in advance...