combo box can do more than change?

[theintern]

I have some code for a combo box in a user form. however, i'd like it to run
each time the user selects a value from from the box, even if it is the same
value. right now it only runs if the user changes the value. i tried
putting it to trigger on Exit, instead of Change, but that said the
"Procedure declaration does not match description of event or precedure
having the same name."

Help please

thanks
scott

Private Sub MonthBox_Change()
If Not (MonthBox.Value = "Select month") Then
YearBox_Change
End If
End Sub

'YearBox_Change is a sub right below MonthBox which has some code in it, but
nothing that should be causing this. I tried changing YearBox and MonthBox
to Exit and both give me that error

 

[Jan De Messemaeker]

Hi,

Is _Click an option?

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[theintern]

A few of the others work as well (AfterUpdate, Click) but i'm thinking it's
just something hardcoded into windows, so no worries. what i have will be
good enough.

 

[theintern]

yeah, i think click is my best option. it still doesn't re-run if i select
the year currently selected (i.e. i have to click on a different year, view
it's stats, then go back and click the year i want) but it's not that big of
a deal.

Thanks!
scott