Excel SS on Split Screen

Hi ,

I have a Spreadsheet that's coded using VBA macros etc. It runs on a machine with multiple - video capability... so you can drag a window from one monitor across to another,.

I recently changed the spreadsheet to include a combo-box control. This has caused a problem as follows...

Let's say the spreadsheet is shown on monitor 3(on the right). When I click on the combo box, the drop down portion of the box shows up on monitor 2 (in the center). As long as you remember to look for the list on the center monitor, the selection process still works, etc. But this is a spreadsheet my boss uses a lot, and he doesn't quite like the way it works.

Have any of you guys experienced this>?... Have any ideas?

Thanks, as always...

Tom

Tell us more about the way you are useing dual monitor. It may have some effect... I'm far from expert at this stuff though.