Set srng = Application.InputBox(prompt:= _ "Select Period", Type:=8)
How to set input box Title and position on screen via xpos and ypos parameters?
Set srng = Application.InputBox(prompt:= _ "Select Period", Type:=8)
How to set input box Title and position on screen via xpos and ypos parameters?
Last edited by vdongen; 10-08-2010 at 05:20 AM.
the inputbox method has a Left and Top argument
A quick test would suggest the position is in relation to the application and not the screen.Left Optional Variant. Specifies an x position for the dialog box in relation to the upper-left corner of the screen, in points.
Top Optional Variant. Specifies a y position for the dialog box in relation to the upper-left corner of the screen, in points.
Could you give a sample of the code?
seriously
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks