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 !
Bookmarks