Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.ControlSource
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Controlsource Puzzlement | Excel Programming | |||
Controlsource errors | Excel Programming | |||
Format & ControlSource | Excel Programming | |||
ControlSource | Excel Programming | |||
Controlsource | Excel Programming |