Hey guys.
I did some searching on this problem and it has been reported by some people before but I cant find a solution to the problem.
The problem is that if the screen resolution is changed while Excel is open then my combo boxes grow larger or smaller (seems almost random) when I click on them.
If I close Excel and re-open the file in the new resolution then everything works like normal.
Has anyone ever found a solution for this problem?
I've not seen a solution
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Maybe you get the same result 'refreshing the screen (F5).
Otherwise:
If you design a userform or ActiveX-control you can store the activeresolution somewhere.
Later on you can compare that stored resolution with the actual resolution.
The actual resolution you can get using:
Now you can calculate a correctionfactor with which you can zoom in a userform, or adapt width and height of an ActiveX-control.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks