Userform as childwindow in statusbar not redrawn when Excelwindow is resized
of course: - very helpful - sory for my german understatement
tendency.
I agree the CBT method is very stable in combination with a runing
VBE.
..I tested in both 2003 & 2007 and it worked fine in both.
Yes, I was referring to your comment #2 on Jan.13th. I started a new
workbook from scratch with your posting/code on Jan.14th but
immediatly had the resize problem. Annoying. Maybe I'll leave this
little problem alone for a while before I start to analyze the CBT
messages to see how I can implement there a way to ensure the I see
the UF after the resize.
... I'm not entirely happy about the positioning method
I agree with your comment about the positioning of the UF. It behaves
a bit strange. For the initial position it is -Application.left * 2 +
the offset to to the right. Afterwards when you switch the parent with
your code the factor must be *1 and not *2. Maybe setwindowsPos is
easier and better to predict. I didn't dig into that one yet.
Overall I'm happy to see that it is possible with this special UF
setup to simulate a commandbar at the bottom of the main Excel 2007
window, despite MS efforts to make us all use the ribbon interface
instead of the commandbars. The next challenge I'm interested in is to
"dock" such a userform on the left or the right side of the main Excel
window.
...if it exists and exposes a handle you can get its coordinates.
Yes correct, and therefore it shouldn't be too difficult to make it
visible after the resize.
|