Problem with macro execution

[abhijit_ghawate]

Hi,

I have developed an add-in for excel which adds some macros to excel that
are used later. I have also add some comboboxes to the worksheet through th
Addin code. On 'selected index change' event of the combo boxes i execute one
of the added macros. My problem is that when i enter some text in a cell and
click on the combo box with the intention of changing the selected index
(which causes the macro to fire) at times this works but sometimes the visual
basic editor for debugging the macro opens. As i see there is nothing wrong
with the macro code, but a part of the text or the complete text i had
enetered in the cell has been appended to the end of the macro code after
"End sub" and i have to delete it before closing the macro debugger to make
the macro wrok there after. If i dont delete the text it keeps showing the VB
editor every time.

Now this dosent happen everytime, only sometimes and it is really
irritating. I thought that maybe typing fast and then trying to change the
combobox selected index quickly caused something to malfunction, but this
sounds really silly to be a reason. Can anybody else figure out the exact
problem ???

Thanks
Abhijit