Rowsource Invalid property value
Private Sub UserForm_Initialize()
ComboBoxForms.ColumnCount = 2
ComboBoxForms.RowSource = "'$$TEMP$$'!L1:M7"
End Sub
worked for me. (added single quotes to contain the sheet name)
--
Regards,
Tom Ogilvy
"FClifton" wrote:
I am trying to set a Combobox Rowsource property. I want to include the name
of a worksheet $$TEMP$$. When I use the code:
ComboboxForms.RowSource = "$$TEMP$$!L1:M7"
I get the error: Could not set the RowSource property. Invalid property value.
How can I do this properly?
|