Thread: load list data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JR Form JR Form is offline
external usenet poster
 
Posts: 1
Default load list data

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,