Thread: Userform

I had this userform working perfectly on my home computer using excel 2007. Now that i am at work and my company uses 2003 i cannot figure out what is going on and how to fix it. First off the comboboxes will only show their info if i click the clear button and then if i click the clear button more than once it will repeat in the comboboxes. Can someone help please. Im sure it has something to do with the initialize command but i cannot figure out what it is.

Hi dollarbill

Try to add this behind your userform and see if this is what you expect.

Private Sub UserForm_Activate()
    Call UserForm1_Initialize
End Sub

Originally Posted by MarvinP

Hi dollarbill

Try to add this behind your userform and see if this is what you expect.

Private Sub UserForm_Activate()
    Call UserForm1_Initialize
End Sub

That solved the problem of the comboboxes not initially having any information in them but the info is still repeating itself if the clear button is clicked? Any ideas?