Excel 2003 Code crashes Excel when moved....

[Richard U]

I am sending the value of a combo box to a function.

When I use the Change Event, it works fine.

When I use the Click Event it performs the procedure, then crashes Excel completely after executing the End Sub line.

The code is identical in both:


THIS WORKS

Sub cmb1_Change()
Call Get_Da_Value(txt1.value, txt2.value..... cmb1.value)
end sub

This Crashes Excel entirely

Sub cmb1_click()
Call Get_Da_Value(txt1.value, txt2.value..... cmb1.value)
end sub

Any idea why this is happening?

 

[AlphaFrog]

Cannot tell without seeing all the code and what line causes the error.