Excel Userform Rowsource replacement with compatibility for PC/MAC

[Rigormorpheus1]

I am trying to modify a workbook that works fine on PC to work on Mac, unfortunately it does use a rowsource call which does not work on mac. I have tried all the alternative solutions I have found here and on other sites and none of them work. Most will just return an Error 13 invalid property.

Here is the code I'm using that works for the pc to load the userform:

Please Login or Register  to view this content.

"SavedEncounters" is a workbook named range.

This should bring up a box that shows the cell information on a seperate worksheet that I can click on a row of data and hit load to populate another worksheet.

If I comment out the "LstEncounters.Rowsource" line the box shows but of course is empty. I have attached an example file, to launch the code causing the error on the "Encounter Builder" sheet click on View/Load button.

Any insight or ideas would be a great help. I have tried to use the list command but it is not working either.

[AlphaFrog]

I don't find a named range called SavedEncounters, but if you had one, this might work.

Please Login or Register  to view this content.

[Rigormorpheus1]

WOW! That worked like a dream on the actual workbook. I tried so many other "List" type options but none of them worked and where much more complicated than this. You have just saved me so much hassle having to reprogram the entire thing. I can not thank you enough! Cheers!

[AlphaFrog]

You're welcome. Thanks for the feedback.