Printable View
does anyone know how to fix the position of the dropdown when excel is displayed on the second monitor?
when excel is displayed on my second screen, with user form in center of excel application, the dropdown is always displayed at the left edge of the first monitor,
any suggestions?
Hi West
Sorry I didn't understand your query regarding 1st screen and 2nd screen. Can you elaborate on that? or a snaphot?
like this, see the dropdown is displayed on the other screen
oops turned out to be bit big, i will try to resize
much better size now, but hard to read, the drop down is over the excel ide properties window, but will display over whatever is on that screen, works correctly if excel is on the other screen
I tried hard look for the dropdown but couldn't locate it but then I managed to see what you meant :)
When you say screens do you mean windows?
One last request... can I see your workbook?
lol nothing in the workbook, just some code for forum testing i never save it, this is a standard problem with any workbook i useQuote:
One last request... can I see your workbook?
screens ....... monitorsQuote:
When you say screens do you mean windows?
under the userform's properties check what is the value of StartUpPosition
I guess it is "3 - WindowsDefault"
If it is then change it to "CenterScreen"
Try now...
the default seems to be centerowner (1), which is where the userform displays, but the problem is just the dropdown from the combobox
if i set it to centerscreen result is the same
if i set to windows default then works correctly, but userform is on other screen
When you say that it is on a different screen do you mean on a different computer?
no same computer 2 monitorsQuote:
When you say that it is on a different screen do you mean on a different computer?
I also use 2 monitors but I've never seen that problem and cannot replicate it.
It's weird!
What happens if both Excel and VBA code windows are on the same monitor?
if excel application on left monitor (primary) combobox works correctly
if excel application on right monitor, combo dropdown is always on left monitor (at position 0 left), regardless of what window (or desktop) is displaying on left monitor
excel application, full screen or normal, no difference, it has been happenig since i started using 2 monitors
excel version 2000
I have no way to replicate the problem. It works fine on my PC.
Try to swap primary monitor to see what happens.
no matter what position excel application, i can drag the userform anywhere in either monitor, as long as it is in the primary monitor the drop down is in the correct position, but the drop down list will never appear on the other monitor, i tried moving the secondary to the right side of the primary, but the effect is still the same, the dropdown is at the right edge of the primary
I have no idea. At work, I use Excel 2003 with 2 monitors. I've never had that problem.
I guess perhaps the problem of display driver.
ATI RADEON XPRESSQuote:
I guess perhaps the problem of display driver.
I guess nobody every got this question answered. I"m having same problem.Quote:
Originally Posted by westconn1
The userform startup position is fine. But when I call me.comboboxname.dropdown method (which I like to call when userform initializes, because who wants their users to have to click the dropdown arrow if you can make it dropdown for them), the userform itself remains displayed perfectly (center of screen - and ALL I have going here is one laptop, so nothing to do with monitors), but the 'dropdown' (with combobox list contents and all) appears at upper left hand corner of monitor.
I guess the position is kind of nice - but very bizarre and unexpected. I doubt this is a "display problem".
PS, for the love of God, will people please stop using "dim" as a verb. DIM is a vba keyword, the verb, if you want to try to use it in a grammer context, is DECLARE. Declare variables using the Dim keyword. Not "dim variables".
I figured it out, the Initialize event of the combobox is simply too soon for Excel. the program does not recognize the position yet, so .dropdown method of combobox results in default upper top left position - regardless of the position of userform.
I solved by coding this in the Sub that I created to display the combobox in the first place, rather than calling the combobox's .dropdown method within the form's initialize event.. Excel userforms REALLY NEED an 'open' event, and a few more events frankly, if anyone from MS reads this in the next decade.
actually the verb would be dimension, which dim is an abbreviation ofQuote:
the verb, if you want to try to use it in a grammer context, is DECLARE
i have never been able to resolve the original problem, as it happens with many other programs too, including outlook express and others i can not think of at the present, i have just accepted it as a downside to multiple monitors
having been prompted here, i will be testing on windows 10 sometime soon, to see if microsoft has resolved the issue at all