Welcome to MacForumz.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Combo Boxes created in MS Excel 2002 for WINDOWS

 
   Macintosh computer (Home) -> Excel RSS
Next:  Lose "Folder List" view after each En..  
Author Message
Kip Larsen

External


Since: Sep 08, 2004
Posts: 1



(Msg. 1) Posted: Wed Sep 08, 2004 3:10 pm
Post subject: Combo Boxes created in MS Excel 2002 for WINDOWS
Archived from groups: microsoft>public>mac>office>excel (more info?)

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.

 >> Stay informed about: Combo Boxes created in MS Excel 2002 for WINDOWS 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Wed Sep 08, 2004 5:17 pm
Post subject: Re: Combo Boxes created in MS Excel 2002 for WINDOWS [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <187901c495e8$4d8464d0$3a01280a@phx.gbl>,
"Kip Larsen" <anonymous DeleteThis @discussions.microsoft.com> wrote:

 > 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.<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Combo Boxes created in MS Excel 2002 for WINDOWS 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]