How do I link a Ribbon check box with a macro?

**dschmitt** · 07-05-2010, 02:35 AM

I have a macro that I execute with a button in the Ribbon.

This macro gives the user the option to select between 2 analysis modes via an input window (Do a country specific analysis or not. If yes, what is the name of the country)

What I would like to do is move this option to a Ribbon check box. In other words I want the user to check or not check a check box in the Ribbon depending on what type of analysis the user wants to do.

Subsequently the user executes the macro by pressing the Ribbon button.

I imagine that the code that links the Ribbon check box with the macro looks something like the code below. If somebody could tell me exactly how it is done that would be great.

Please Login or Register  to view this content.

**Bob Phillips** · 07-05-2010, 03:29 AM

You would need to use a callback tied to the checkbox in the XML, and have code to action that callback,like so

Please Login or Register  to view this content.

**dschmitt** · 07-05-2010, 04:44 AM

Bob, thanks for your help. But I still have some conceptual problems.

I know how to link a sub to a button:
Button activates Sub(control As IRibbonControl) which activates Sub()

However with a checkBox I don't know how to do it.
Is there a way to call the Sub(control As IRibbonControl, pressed As Boolean) with a Sub()?
In other words can a Sub() check the status of the checkBox?
There must be a way to do that, because with the checkBox one cannot start a Sub.

I hope my question is comprehendable.

**Andy Pope** · 07-05-2010, 05:03 AM

If your checkboxes are just setting a flag rather than executing your macro then take Bob's example and in it store the pressed state of the checkbox.

In you button routine check the variables and process accordingly

For ribbon with a button and 2 checkboxes both using the same onAction callback.

Please Login or Register  to view this content.

Note that the checkboxes will allow for selection of both.

**Bob Phillips** · 07-05-2010, 06:03 AM

Originally Posted by dschmitt

Bob, thanks for your help. But I still have some conceptual problems.

I know how to link a sub to a button:
Button activates Sub(control As IRibbonControl) which activates Sub()

However with a checkBox I don't know how to do it.
Is there a way to call the Sub(control As IRibbonControl, pressed As Boolean) with a Sub()?
In other words can a Sub() check the status of the checkBox?
There must be a way to do that, because with the checkBox one cannot start a Sub.

I hope my question is comprehendable.

A checkbox has an OnAction proiperty in the XML just as the button does, so you assign it there.

Quite honestly, if you just have an action A or B depending upon the checkbox, I would se a togglebutton.

**dschmitt** · 07-05-2010, 06:08 AM

thanks Andy, good thinking. I actually have 2 checkBoxes on my mind.

In regards to the sub call order I suspect that it has to be as below. Is that true?

Please Login or Register  to view this content.

I thought that the below may be possible but it is not working. Too bad, that would have made things easier. Can you confirm that this strategy is not possible?

Please Login or Register  to view this content.

**dschmitt** · 07-05-2010, 06:14 AM

Bob, Thanks for the hint. As you say, that would work if I would just have one toggle. I am planning for at least 2 toggles with any possible combination. I think in that case only checkboxes will work.

**Bob Phillips** · 07-05-2010, 06:23 AM

As Andy said, you have to capture the state of all the checkboxes in the callback procedure, and the variables should nbe at least module in scpe so that you can use them across procedures

Please Login or Register  to view this content.

**Andy Pope** · 07-05-2010, 06:24 AM

Sorry your logic is confusing me.

Sub 2 appears to be the callback from a control. Either you execute code when the control is clicked or you call the routine from another controls click.

**dschmitt** · 07-05-2010, 06:52 AM

Bob, your code looks easy understandable. This is what I need. Thanks.

Andy, you are probably confused because this logic is not possible. I tried and it didn't work. Only somebody who doesn't fully understand how IRibbonControl Subs and Subs work can come up with such a logic. A Sub cannot call a IRibbonControl Sub. Only the opposite is possible.

I will implement this tomorrow and conclude the thread then.

**Bob Phillips** · 07-05-2010, 06:52 AM

Here is an example of what I mean

**dschmitt** · 07-05-2010, 08:55 PM

Dear Bob and Andy, thank you very much for your help. I understand the concept now and got my checkboxes to work.
Bob, your example xlsm file is great. The concept cannot be better illustrated.

**Bob Phillips** · 07-08-2010, 06:00 AM

Originally Posted by dschmitt

Dear Bob and Andy, thank you very much for your help. I understand the concept now and got my checkboxes to work.
Bob, your example xlsm file is great. The concept cannot be better illustrated.

Thanks for those words, I am glad we helped. Better still, you have a bettter understanding.

**BuckoAk** · 08-10-2012, 04:23 AM

Bob , Andy,

I have something similar to the code being discussed, is it possible to reset (un-check) the checkbox(s) after the macro has completed?

**Cutter** · 08-10-2012, 08:12 AM

Hello BuckoAk, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

How do I link a Ribbon check box with a macro?

LinkBack

Thread Tools

Rate This Thread

Display

How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Re: How do I link a Ribbon check box with a macro?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions