PC Spreadsheet not running on MAC

[Rob Zitta]

I have an Excel 97 spreadsheet written on a windows based PC with a
command
button that opens a visual basic form which includes several combo
boxes.
The spreadsheet works fine on the PC but not on the Mac, which is
running
OSX using Excel 2001.

Originally the command button that opens the form, would not work on
the
MAC. I had placed the command button on the spreadsheet using the
Visual
Basic Toolbar. I found that if I used the forms toolbar to place the
command
button on the spreadsheet, that it would then work when opened on the
MAC.

The problem I now have, is after the form is opened and I click on any
of the
combo boxes, I get the following error message.

run time error 32809
Application-Defined or Object-Defined Error

I have several similar files that are under development, and used by
both PC
and MAC users. Any idea what is happening?

Thanks

 

[JE McGimpsey]

I have an Excel 97 spreadsheet written on a windows based PC
with a command button that opens a visual basic form which
includes several combo boxes. The spreadsheet works fine on the
PC but not on the Mac, which is running OSX using Excel 2001.

Originally the command button that opens the form, would not
work on the MAC. I had placed the command button on the
spreadsheet using the Visual Basic Toolbar. I found that if I
used the forms toolbar to place the command button on the
spreadsheet, that it would then work when opened on the MAC.

The problem I now have, is after the form is opened and I click
on any of the combo boxes, I get the following error message.

run time error 32809 Application-Defined or Object-Defined
Error

I have several similar files that are under development, and
used by both PC and MAC users. Any idea what is happening?

It's impossible to answer this without seeing what code is causing the
problem...