Userform working on Windows but not on Mac because of the RowSource

Hi everybody.

I am trying to make a userform to work both on windows pc and macbook (excel2011). On pc it does work perfectly, but on mac the add button won't work because it should get data from rowsource which I have discovered it doesn't work on mac.


We have a huge list (about a 1000 rows) of reagents. Same antibody can come from different companies or have different size, so we need the userform to search trough the list (Sheet Reagenti) and display results in a listbox, and when selected pressing the add (aggiugi all'ordine) button should add the row to the sheet named Modulo.

As I said it does work perfectly on pc but on mac I can't either search nor add the item selected in the listbox. I watched hundred of tutorials (maybe too many) but didn't come up with a definitive solution

I attach the file hoping you might help.

Thank you

hi

can you try this

Please Login or Register  to view this content.

replace the whole subroutine