I'm trying to change some codes in a module I created in VBA. And the result
when I use F5 to run the module is ok. But when I try to call it by click a
button, some of the result lines are disappeared. I've tried to debug the
module step-by-step but the result is always the same.

Is there anyone encountered such weird situation? Could you guys tell me why
this could happen?

Thanks a lot!

If you click a button from the control toolbox toolbar (placed on a worksheet)
and you're using xl97, then try changing the .takefocusonclick property of that
button to false. (A bug in xl97 that was fixed in xl2k.)

If your code works on the activesheet, make sure you activate the correct sheet
first (or remove the reliance on the activesheet and work directly on the sheet
you need).

If your code is behind a worksheet, remove the .selects and .activates and work
directly on the other sheet.

If none of this makes any sense, you may want to post the problem portion of
your code, the version of excel you're using and where the code is located (in a
general module or behind a worksheet named ???).



Mattew wrote:

I'm trying to change some codes in a module I created in VBA. And the result
when I use F5 to run the module is ok. But when I try to call it by click a
button, some of the result lines are disappeared. I've tried to debug the
module step-by-step but the result is always the same.

Is there anyone encountered such weird situation? Could you guys tell me why
this could happen?

Thanks a lot!

--

Dave Peterson