VBA code to detect change in cells filled by combo box

[Jollyfrog]

Hi i need to be able to detect when values from a specific set of cells change. Current im using:

Please Login or Register  to view this content.

just for testing, to detect when any cell on the sheet is changed, however this doesn't detect changes from cell values which are changes as the result of a combo box being altered!..

is there a way to do this?

thanks

Jonathan

[snb]

Please Login or Register  to view this content.

[royUK]

What type of ComboBox?

[Jollyfrog]

I'm using an activex combo box!

[Jollyfrog]

The combo box itself fuctions correctly, it grabs a validation list and then inputs this to a desired cell, my problem is that excel does not detect the new cell value as a change and therefore does not execute any code ties to the change of a cell value.. bit anoying really :-(

was wondering if people had experianced this in the past and knew of ways to get round this or to use an entirely different method of detecting cell changes

[snb]

If you use the code I gave you'll see that every change in the combobox and cell(4,4) respectively will trigger the worksheet_change event.

[Jollyfrog]

Ah cunning... totally missed the point first time i read that..

this seems to work, thanks!

[dearsurabhi]

If you use the code I gave you'll see that every change in the combobox and cell(4,4) respectively will trigger the worksheet_change event.

Hi,

I am working on a similar thing, can I please get a copy of the code please

[arlu1201]

The code is in post 2.

[dearsurabhi]

great! what if instead of a combobox I am using a drop down list? I want the macro to run if there is any change in the drop down value.

[arlu1201]

dearsurabhi,

Its better you post this question in a separate thread.

[snb]

It's better that you try to reason yourself instead of copying.

[dearsurabhi]

Thanks for the brilliant advice i was under the impression that this forum could be useful for people who maybe do not have a very indepth knowledge of VBA coding. just FYI - I would not be just copying and pasting anything that would be recommended