rowsources

[Joost Verstraeten]

I have tested this userform

Private Sub UserForm_Activate()
With lstSoortUitgaven
.RowSource = "Uitgaven"
.ListIndex = 0
End With


It doesn´t works BUT in the help files I read
that this property is not supported by microsoft office for Mac !

Is there another solution?

TIA

 

[JE McGimpsey]

I have tested this userform

Private Sub UserForm_Activate()
With lstSoortUitgaven
.RowSource = "Uitgaven"
.ListIndex = 0
End With


It doesn´t works BUT in the help files I read
that this property is not supported by microsoft office for Mac !

Is there another solution?

See this workaround from the MS Knowledge Base:

MacXL: Run-Time Error When You Set RowSource Property
http://support.microsoft.com/default.aspx?scid=kb;en-us;175795

 

[Joost Verstraeten]

See this workaround from the MS Knowledge Base:

MacXL: Run-Time Error When You Set RowSource Property
http://support.microsoft.com/default.aspx?scid=kb;en-us;175795

Thx a lot