View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Hmmm. Private Sub ComboBox6_DropButtonClick(). Should i have my code here ?

Corey,
You can check if the combo has been populated.
If ComboBox6.ListCount0 then exit sub

NickHK

"Corey" wrote in message
...
Private Sub ComboBox6_DropButtonClick()

I have just realised that EACH time i Click on the DropDownButtonClick
Button,
I get a Duplicate populated LIST if Clicked on more than ONCE.

TO ONLY ever populate the LIST ONCE, where should i be placing the code ?
It is on Userform5.
The code is dependant upon other values chosen on the Userform, so it
therefore cannot be placed in the Userform.Initialize or Activate event.

Any Idea's, or am i stuck with it here ?

Corey....