I have put a modeless userform without caption as a childwindow into
the statusbar window of the main Exel window. So far so good. It moves
with the main excel window and stays fully functional inside the
statusbar.
My problem: When the main excel window is being resized in its width
then the statusbar window seems to be redrawn but not the userform
childwindow, and therefore the userform isn't visible anymore. I've
tried to use the resize event of the userform and as well the resize
event of the Excel application to make the userform being redrawn, but
both events seem to be called before the statusbar is being redrawn,
means it didn't solve the problem of my userform to disappear when the
excel window width is being changed.
Does anyone have experience working with the windows api in Excel/VBA
and how to work with setparent, setwindowpos, setwindowlong,
drawmenubar, and how to use them in order to solve my problem with the
excel statusbar?