Run macro when cell is changed(also as a result of listboxchange-change event doesnt work)

**drrazor** · 11-09-2014, 03:14 PM

Hello,
I want to run macro whenever cell is changed, the trick is that event change is only running when I change cell manually, but when I do this using while choosing different item from ActiveX Listbox to which it is assigned, it doesn't run.

What can I do?

Thanks in advance for help!

**protonLeah** · 11-09-2014, 03:27 PM

Right click the listbox, select "view code" and put the code in the listbox_change event handler.

**drrazor** · 11-09-2014, 04:13 PM

just found it, but thanks anyway, kudos

Run macro when cell is changed(also as a result of listboxchange-change event doesnt work)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Run macro when cell is changed(also as a result of listboxchange-change event doesnt work)

Re: Run macro when cell is changed(also as a result of listboxchange-change event doesnt w

Re: Run macro when cell is changed(also as a result of listboxchange-change event doesnt w

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Click event fires but doesnt work under initialze procedure

[SOLVED] Total doesnt change when number in calc are changed..

[SOLVED] Change event to Add or update comment with input box when cell in a range is changed

Event macro to run when cell value is changed

[SOLVED] Worksheet Change Event-when a cell with a certain range of cells) are changed?

Bookmarks

Bookmarks

Posting Permissions