View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Rowsource Invalid property value

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