How to Start RowSource from Activecell

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?

Please Login or Register  to view this content.

Paul

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

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:

Please Login or Register  to view this content.

Paul