.ControlSource

You're giving it an Excel range but it's expecting a string that contains the
address of the range. Just stick .Address on the end.

"Ctech" wrote:

>
> I have this bit of code in a macro
>
> With C5B_UserForm.ComboBox1
> .RowSource = mSource
> .ControlSource = Worksheets("Template").Range("X4")
> End With
>
> However Im getting an '3802 error on the ControlSource bit, anyone know
> why?
>
>
> --
> Ctech
>
>
> ------------------------------------------------------------------------
> Ctech's Profile: http://www.excelforum.com/member.php...o&userid=27745
> View this thread: http://www.excelforum.com/showthread...hreadid=526689
>
>