Error in Workbook Open subroutine

Hi all,

in my Workbook open I have the following code:

Please Login or Register  to view this content.

when it gets to snapshot.list = trend I get a runtime error '424' Object required error.

can anyone advise please?
I want to initialise my comboboxes when the workbook is opened.

thanks in advance,
Matt

Hey matpj...

if the Snapshotbox is a combo box then to add the list you need to do this.

Please Login or Register  to view this content.

so for the trend you could do this.

Please Login or Register  to view this content.

So total code could look like this:

Please Login or Register  to view this content.

does this fix the problem??

hi
thanks for the response
when I run it I get a compile error saying
"For Each control variable must be Variant or Object"

trend is defined as a variant which I have assigned an array.
is this the problem?

try declaring the trend as a string