load list data

[Souris]

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,

 

[JR Form]

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.count>0 then
Exit sub
Else
'do your loading code here
End if