Help a newbie in a ComboBox fix.....

[rosemary]

Hi,

I'm experiencing some difficulty with the ComboBox macro. It works
correctly when I put it into the document (saving the document poses no
problems). After I close the program and then reopen it, I have to go
into each and every combobox and run it again! How can I avoid having
to do this each time?

Thanks,
Rosemary

 

[bhofsetz]

Rosemary,
Post your code, or an example of the code you are using for the
combo boxes and we will be able to help you better.

 

[rosemary]

Private Sub ComboBox1_Change()
ComboBox1.List = Array("1", "2", "3", "4", "5+")
End Sub



Thanks!

 

[bhofsetz]

Put your fill code in a combobox get focus event handler rather than a
combobox change event handler and that should do the trick

Private Sub ComboBox1_GotFocus()
ComboBox1.List = Array("1", "2", "3", "4", "5+")
End Sub

HTH

 

[rosemary]

Thank you so much! That did the trick. (Thanks for being patient wit
a complete newbie, too.)

Rosemar

 

[bhofsetz]

You are welcome Rosemary, glad it helped. We all have to star
somewhere.

Brendo