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?

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?

You'll need to do it this way:

ComboboxForms.RowSource = "'$$TEMP$$'!L1:M7"

Notice the sheet name is enclosed in single quotes..



"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?

One mo

ComboboxForms.RowSource _
= worksheets("$$TEMP$$").range("L1:M7").address(exte rnal:=true)



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?

--

Dave Peterson