How to Start RowSource from Activecell

[PaulC]

I want to start the RowSource from the activecell (not the top of the list) on sheet Search Matches. I have tried the following but it does not work. How should I correct this?

N = Activecell.Row
    
MultiSearchForm.cmbMthFrom.RowSource = "Search Matches!DA" & N & ":DA93"

Paul

[Kenneth Hobson]

What userform event did you try the code? Try putting it in the Initialize event.

[PaulC]

Hi Kenneth

Thanks for reply - I was setting this rowsource from a sub before I opened the form.

However, I have just discovered my error - I should have put apostrophies around the sheet name i.e. 'Search Matches'. The following code now works:

N = Activecell.Row
    
MultiSearchForm.cmbMthFrom.RowSource = "'Search Matches'!DA" & N & ":DA93"

Paul