Hi,
I'm putting some List Boxes onto an Excel 97 Worksheet (not a Forms control, but a VB control since I can't seem to get much programmatic control over the Forms List Box). On the Worksheet Open event, I first clear and then fill these List Boxes. For some reason, the list boxes keep changing in size! Specifically, when I open the Workbook they keep losing Height--one List Box will suddenly be shorter than the other, or else more than one will shrink in size.
I've tried simply setting the Height property back to the original amount after filling the List Boxes, but then I'm left with a scrollbar that's set to the smaller height and which is sometimes too small to use.
Any idea what is causing this, and how I can fix it? Thanks!
I'm putting some List Boxes onto an Excel 97 Worksheet (not a Forms control, but a VB control since I can't seem to get much programmatic control over the Forms List Box). On the Worksheet Open event, I first clear and then fill these List Boxes. For some reason, the list boxes keep changing in size! Specifically, when I open the Workbook they keep losing Height--one List Box will suddenly be shorter than the other, or else more than one will shrink in size.
I've tried simply setting the Height property back to the original amount after filling the List Boxes, but then I'm left with a scrollbar that's set to the smaller height and which is sometimes too small to use.
Any idea what is causing this, and how I can fix it? Thanks!
