Rowsource Workaround Required

[Graham Jones]

I have a spreadsheet that I would like to use on both Excel in Windows and
Excel on a Mac. It makes use of a userform with a listbox on it. The listbox
is populated with data on the spreadsheet using the following macro :

frmMain.lstLines.RowSource = "a1:b84"

However VBA in Mac Excel does not support rowsource. So does anyone know of
a workaround to rowsource that will populate a listbox on the Mac version of
Excel?

Thanks in advance

Graham Jones

 

[JE McGimpsey]

I have a spreadsheet that I would like to use on both Excel in Windows and
Excel on a Mac. It makes use of a userform with a listbox on it. The listbox
is populated with data on the spreadsheet using the following macro :

frmMain.lstLines.RowSource = "a1:b84"

However VBA in Mac Excel does not support rowsource. So does anyone know of
a workaround to rowsource that will populate a listbox on the Mac version of
Excel?

Found a reference to this

http://support.microsoft.com/default.aspx?scid=kb;en-us;175795

by looking in the archives:

http://groups.google.com/advanced_group_search?as_ugroup=*mac.office*

 

[Graham Jones]

Well found sir, I really appreciate it, that is just what I need.

Best regards

Graham Jones