Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ranges

**Pavl360** · 02-22-2021, 06:28 AM

I am attempting the creation of a workbook on WinExcel'16 that will be used abroad by a friend on MacExcel'11.
(and aware that High Sierra does not officially suport Excel2011).
Just realised that my lovely ComboBoxes, now working well ....are not Mac compatible (ActiveX) !

So investigated UserForms and did some reading - but am seeing conflicting results.
At first it seemed that I could/should be using UserForms wirh FormControls in place of ActiveX ... but then found this MS page https://support.microsoft.com/en-us/...0-ffb9ab94e7c2
It 'seems' that even the controls on a UserForm are still ActiveX ... or have I got that wrong ?
And that "Form Controls" are different ... and thought I could see the difference in the toolbox ... only to now believe all toolbox controls are ActiveX.

I need multi column comboboxes that fill one visible cell (eg A5) but also fill one hidden cell (eg B5) but do so from viewing multiple columns within the conbo to enable the choice to be made.
Single column list will not work for me in this situation.
This is transcription of historical documents and comparison to existing data via some comboboxes and manual text fill in other cells within each record row (all done abroad). Later I will use this sheet to append MS Access tables)

As I do not have a functioning Mac with Excel 2011 I have no way of testing at this end ....
So it boils down to a multipart question ....

Can I use UserForms at all?
Which versions of ComboBoxes can be/cannot be used?
Anything else I should specifically avoid/or do in relation to multi column combos going to Mac?

Or should I try LibreOffice !

**rorya** · 02-22-2021, 06:33 AM

ActiveX in Excel refers specifically to controls embedded in worksheets. Controls on userforms are fine (though you will find that Lisboxes do not support the Rowsource property on a Mac).

Form controls on worksheets on a Mac are fine too.

**Pavl360** · 02-22-2021, 06:48 AM

Thank you "rorya".

I can see that ListBox and ComboBox both have RowSource properties ... but I should avoid ListBox.

Does that mean I can still use ComboBox and its RowSource (multi column named range on hidden sheet)?

Hope not to use other controls as I will be trying to open the form with Workbook open and keep it pinned on the sheet in use.

**rorya** · 02-22-2021, 07:13 AM

No, Rowsource won't work with Comboboxes either. It's best avoided anyway - you're better off populating them using an array assigned to the List property.

**Pavl360** · 02-22-2021, 08:04 AM

Thanks again "rorya".
I will do some reading on arrays and the List property.
Paul

**rorya** · 02-22-2021, 08:06 AM

For a simple range, all you really need is something like:

Please Login or Register  to view this content.

**Pavl360** · 02-23-2021, 02:28 AM

Thanks again "rorya".
Had to do some other things so have not tested this yet .. but have been reading and will have a go today.
Help much appreciated.

EDIT:
Now have a functioning UserForm 'Show' on Workbook open and 'Show False' to keep it open.
Correctly fills target Activecell(s).

Now trying to get the ComboBox on UserForm to be enabled/disabled depending on current ActiveCell.

EDIT2:
Now have enabled/disabled working (was trying too hard to reference the UserForm ... now realise I just use its own name !)

So topic solved for me.
Help very much appreciated.
Over and out.

**rorya** · 02-23-2021, 04:48 AM

Originally Posted by Pavl360

was trying too hard to reference the UserForm ... now realise I just use its own name !)

For code in the userform itself, use Me rather than the form name.

For code outside the form, you should really be using a variable and not the default instance of the form. (this is quite a long read, but well worth the time if you spend more than a trivial amount of time developing with userforms in Office)

Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ranges

LinkBack

Thread Tools

Rate This Thread

Display

Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ranges

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Re: Windows Excel 2016 going to Mac Excel 2011 (High Sierra) - ComboBoxes & multicolumn Ra

Thread Information

Users Browsing this Thread

Similar Threads

VBA to autosize comment box in MS Excel 2011 NOT WORKING in MS Excel 2016

Macro built in Excel 2011 crashes workbook in Excel 2016

[SOLVED] Format Excel 2010 - Windows 7 vs Excel 2016 - Windows 10

Pivot table portability between Excel Windows version 2007/2013 and Mac version 2011/2016

Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010

Code works in Windows excel 2003 and 2010 but crashes in Mac excel 2011

Macros working fine on Windows (Excel 2010), but not on Mac (Excel 2011)

Bookmarks

Bookmarks

Posting Permissions