Hi guys,

I found this thread which explained how to use the control source property for a single worksheet.
http://www.excelforum.com/excel-prog...-userform.html

I was wondering though if there is a way to make it work for activesheet.

To give you an idea....I have a workbook with employee details. Each employee has their own worksheet but the format and layout is exactly the same. I have a userform that I can use to search for an employee that will then populate a number of textboxes with the relevent data. For example the employees name will always be in cell B2. So what I am trying to achieve is that when I search for an employee their worksheet becomes the active one and then populates the userform. This userform uses multipage and therefore has alot of textboxes so I am trying to avoid having to type "me.textbox1.value = range("A1").Value" countless times (this does work but is long winded).

Any help would be appreciated.

Cheers,

Aaron