Change Event on Sheet Objects

  • Thread starter Thread starter Don Guillett
  • Start date Start date
D

Don Guillett

Don't think so... Since it is a WORKSHEET change event it should only fire
when a cell in the worksheet is changed.
 
Simple question:

Does the Change event fire on a sheet object (such as a combobox or
checkbox) when the file is saved?

Thanks,

Ross
 
Any idea why the change event sub routines for every object on my sheet (and
only the Change events) are executing when I do a file save as
programmatically with VBA?

Thanks.
 
When I changed all of my "Change" events to "LostFocus" events (because that
would still work for my purposes), I no longer had this problem anymore.

Kinda stupid if you ask me.

Ross
 
Because you have them linked to cells and Excel does a thorough recalc of
the sheet in my opinion.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sheet event wait for another event? 6
Simple Copy Paste within Worksheet Change Event 2
Change event does not fire 3
Include Dropdowns and Checkboxes in Worksheet Change event 1
Run two macros for two different sheets 11
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Worksheet Change event not firing but Worksheet activate event does 1
Excel2000: Avoiding loop in Worksheet_Change event 3

Back
Top