I wanted to load my dropdown list from Access table which refresh every time
i click on the spreadsheets becasue I have the code in activate. Are there
any event that I can put my function that only load once.

your information is great appreciated,

Souris,
you could test to find out if there is anything loaded in the dropdown.
Put your code in the control's activate stub.

If dropsown1.count0 then
Exit sub
Else
'do your loading code here
End if

"Souris" wrote:

I wanted to load my dropdown list from Access table which refresh every time
i click on the spreadsheets becasue I have the code in activate. Are there
any event that I can put my function that only load once.

your information is great appreciated,