How to get a listbox to move when scrolling down spreadsheet

[kdunnSBLI]

I added a calendar control to my spreadsheet which moves down whenever I
scroll down the spreadsheet which is fine, and now I want my listboxes to
behave the same way, but they don't. I didn't change or add any of the
Calendar control properties to get it to work this way and I'm wondering how
I can get my combo boxes and listboxes to move as well. The Format Control
property for the listboxes/combo boxes is set to "Move but don't size with
cells", so I'm not sure what to do at this point. I'm using Excel 2002.
Any help or ideas on this would be greatly appreciated. Thanks

Kevin

 

[Dave Peterson]

You have one more response at your other thread.

I added a calendar control to my spreadsheet which moves down whenever I
scroll down the spreadsheet which is fine, and now I want my listboxes to
behave the same way, but they don't. I didn't change or add any of the
Calendar control properties to get it to work this way and I'm wondering how
I can get my combo boxes and listboxes to move as well. The Format Control
property for the listboxes/combo boxes is set to "Move but don't size with
cells", so I'm not sure what to do at this point. I'm using Excel 2002.
Any help or ideas on this would be greatly appreciated. Thanks

Kevin