Hello,
I just made my first VBA and it's working good, though I have a couple of issues and i would really appreciate your help -
The first item on my userform is a combo box and the rest of the items will be activated depending on the option from that combo box that the user picked the code is:
Code:
The problem is when I launch the userform and I select the drop down, it does not give me the options but when i click the "Clear" button which is supposed to clear the values of the boxes if the user decided not to push through with what he entered it now gives me both values.Please Login or Register to view this content.
The code for the clear button is
Now, the funny thing is, when I click the Clear button it doubles my combo box options by adding the same list again. It repeats the same process everytime I click the Clear button.Please Login or Register to view this content.
I would really appreciate any thoughts on this.
thank you much!
Bookmarks