+ Reply to Thread
Results 1 to 8 of 8

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

  1. #1
    Registered User
    Join Date
    01-23-2020
    Location
    Britain
    MS-Off Ver
    2010 and 2016
    Posts
    21

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

    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 !

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,818

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

    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.
    Rory
    I drink, and I know things

  3. #3
    Registered User
    Join Date
    01-23-2020
    Location
    Britain
    MS-Off Ver
    2010 and 2016
    Posts
    21

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

    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.

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,818

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

    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.

  5. #5
    Registered User
    Join Date
    01-23-2020
    Location
    Britain
    MS-Off Ver
    2010 and 2016
    Posts
    21

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

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

  6. #6
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,818

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

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

    Please Login or Register  to view this content.

  7. #7
    Registered User
    Join Date
    01-23-2020
    Location
    Britain
    MS-Off Ver
    2010 and 2016
    Posts
    21

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

    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.
    Last edited by Pavl360; 02-23-2021 at 03:50 AM.

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,818

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

    Quote Originally Posted by Pavl360 View Post
    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)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to autosize comment box in MS Excel 2011 NOT WORKING in MS Excel 2016
    By Black Panther in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2018, 12:36 PM
  2. Macro built in Excel 2011 crashes workbook in Excel 2016
    By NCRB_10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2018, 12:31 AM
  3. [SOLVED] Format Excel 2010 - Windows 7 vs Excel 2016 - Windows 10
    By phan sang in forum Office 365
    Replies: 11
    Last Post: 06-23-2017, 12:53 AM
  4. Replies: 0
    Last Post: 01-09-2016, 02:02 PM
  5. Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010
    By lhlevasseur in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-17-2012, 07:08 PM
  6. Code works in Windows excel 2003 and 2010 but crashes in Mac excel 2011
    By kiweed in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-19-2012, 08:46 PM
  7. Macros working fine on Windows (Excel 2010), but not on Mac (Excel 2011)
    By six6to8eight in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-29-2012, 11:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1