asked on

Realtime Change instead of button to fire Macro

EE Pros,

I have a great little macro that Andrew Mann has developed for me and it needs one little change......instead of updating the total via a button, how do I have the macro recognize a check box, or an uncheck box and automatically update the total?

That's it!

Thank you in advance.

B.
Copy-of-Compling-the-Value-List-.xlsm

andrew_man

Just a kidding!

Do you think you will find out a solution here?

Saqib Husain

right-click on the sheet tab name and select view code

add these two lines before the last end if

Cancel = True
sumup

andrew_man

I dun agree this solution. The client wants real time update!

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

andrew_man

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bright01

ASKER

Great work guys! I've tested it with my production WB and it works great! I have one scaling problem that I'll author another question on.

Thanks again, excellent work.................

B.

Saqib Husain

Why the split? He just repeated my solution.

Bright01

ASKER

Ssaqibh,

Sorry about that; I simply used his executable and didn't compare line by line. Next time I'll be more careful.

I'm authoring another two questions on this Macro. Hope you will pick it up.

B.

Bright01

ASKER

Ssaqibh,

Here is a post that I think Sean may have been tied up or it got abandoned. Given your knowledge on the original post, you may be able to address this in a matter of seconds.

Posted on 2013-11-30 at 07:19:32ID: 39686817

Thanks,

B.