WorkBook_SheetChange for non-Active worksheet
 

Hi All,
I have a question to which I hope the answer isn't painfully obvious to
anyone who is not an amatuer as myself.

I'm using the SheetChange property for my workbook as discussed in other
threads here and I'm trying to use it on a non-active worksheet.

I have a combo box with "Yes" or "No" as the available selections that is
linked to a cell on a seperate "tables" sheet. I am currently using the
SheetChange sub to monitor the changes to this linked cell and run a few
basic IF statements when they are indeed changed. The code works perfectly
when the "tables" sheet is active, but it will not run if the cell is changed
through the combo box on the "main" sheet.
Is there a way to have the WorksheetChange run even when a worksheet is not
active?

Thanks in advance to anyone who might offer a little advice!
--
cmungs

WorkBook_SheetChange for non-Active worksheet
 

Nobody has any ideas or suggestions for me?
--
cmungs


"cmungs" wrote:

Hi All,
I have a question to which I hope the answer isn't painfully obvious to
anyone who is not an amatuer as myself.

I'm using the SheetChange property for my workbook as discussed in other
threads here and I'm trying to use it on a non-active worksheet.

I have a combo box with "Yes" or "No" as the available selections that is
linked to a cell on a seperate "tables" sheet. I am currently using the
SheetChange sub to monitor the changes to this linked cell and run a few
basic IF statements when they are indeed changed. The code works perfectly
when the "tables" sheet is active, but it will not run if the cell is changed
through the combo box on the "main" sheet.
Is there a way to have the WorksheetChange run even when a worksheet is not
active?

Thanks in advance to anyone who might offer a little advice!
--
cmungs

WorkBook_SheetChange for non-Active worksheet
 

The worksheet_Change event will fire if you make a change (typing!) to a cell.

But it won't fire if that change is the result of a formula being reevaluated.

Maybe you should be looking at the worksheet_calculate event.

cmungs wrote:

Hi All,
I have a question to which I hope the answer isn't painfully obvious to
anyone who is not an amatuer as myself.

I'm using the SheetChange property for my workbook as discussed in other
threads here and I'm trying to use it on a non-active worksheet.

I have a combo box with "Yes" or "No" as the available selections that is
linked to a cell on a seperate "tables" sheet. I am currently using the
SheetChange sub to monitor the changes to this linked cell and run a few
basic IF statements when they are indeed changed. The code works perfectly
when the "tables" sheet is active, but it will not run if the cell is changed
through the combo box on the "main" sheet.
Is there a way to have the WorksheetChange run even when a worksheet is not
active?

Thanks in advance to anyone who might offer a little advice!
--
cmungs

--

Dave Peterson

WorkBook_SheetChange for non-Active worksheet
 

Nevermind, I thought up a workaround.

Thanks anyways!
--
cmungs


"cmungs" wrote:

Nobody has any ideas or suggestions for me?
--
cmungs


"cmungs" wrote:

Hi All,
I have a question to which I hope the answer isn't painfully obvious to
anyone who is not an amatuer as myself.

I'm using the SheetChange property for my workbook as discussed in other
threads here and I'm trying to use it on a non-active worksheet.

I have a combo box with "Yes" or "No" as the available selections that is
linked to a cell on a seperate "tables" sheet. I am currently using the
SheetChange sub to monitor the changes to this linked cell and run a few
basic IF statements when they are indeed changed. The code works perfectly
when the "tables" sheet is active, but it will not run if the cell is changed
through the combo box on the "main" sheet.
Is there a way to have the WorksheetChange run even when a worksheet is not
active?

Thanks in advance to anyone who might offer a little advice!
--
cmungs