Combo Boxes created in MS Excel 2002 for WINDOWS

[Kip Larsen]

I am creating an Excel workbook that needs to function the
same on a MAC as it does on a Windows machine. Here is the
problem:

I am using MS OFFICE 2002 on a Windows operating system
running Microsoft Windows XP.

The workbook contains several "Combo Boxes" all of which
function as they are meant to when I create them. However,
when the workbooks are opened on a Macintosh the Combo
Boxes do not function at all. When the user moves the
cursor over the Combo Box the cursor becomes a "hand" tool.
I have asked the user to check and see if the "Control
Toolbox" indicates the workbook is in "design mode" and as
it turns out the same thing happens when "design mode" is
active or not active. The only difference is when actually
IN design mode the user can select and move the Combo Box.

Does anyone have any clue as to why this might be
happening. The Combo Boxes funtion correctly on MS Windows
versions of Excel but do not function on Macintosh versions
of Excel. Macs are running OS X nad have tried MS OFFICE
2004 and the previous incarnation of MS Office on the MAC.

Any clues would be appreciated.

 

[JE McGimpsey]

Does anyone have any clue as to why this might be
happening. The Combo Boxes funtion correctly on MS Windows
versions of Excel but do not function on Macintosh versions
of Excel. Macs are running OS X nad have tried MS OFFICE
2004 and the previous incarnation of MS Office on the MAC.

You're using Comboboxes from the Controls Toolbox. Those controls are
ActiveX controls, which only work on Windows.

To work cross-platform, change the controls to Forms toolbar comboboxes.