O
owlnevada
I've been attempting to add a toggle button to a custom ribbon menu group
called "Old Summary Fixes" on a "Summary Edits" tab. Not sure how to proceed
after reading up on the subject. I just want to put the text in either a yes
or no status as below. Here's what I have so far;
Sub TogglEncumb_click(Optional control As IRibbonControl)
Case No
Range("B36").Select
ActiveCell.FormulaR1C1 = "ENCUMBRANCE(S) : YES ( ) NO ( X )"
Case Yes
Range("B36").Select
ActiveCell.FormulaR1C1 = "ENCUMBRANCE(S) : YES ( X ) NO ( )"
End Sub
Is the the most elegant way to proceed using CASE or is there a better way?
Any help with links to a close example or with the .xlam modifications and
the above code would be very helpful.
Thanks in Advance.
called "Old Summary Fixes" on a "Summary Edits" tab. Not sure how to proceed
after reading up on the subject. I just want to put the text in either a yes
or no status as below. Here's what I have so far;
Sub TogglEncumb_click(Optional control As IRibbonControl)
Case No
Range("B36").Select
ActiveCell.FormulaR1C1 = "ENCUMBRANCE(S) : YES ( ) NO ( X )"
Case Yes
Range("B36").Select
ActiveCell.FormulaR1C1 = "ENCUMBRANCE(S) : YES ( X ) NO ( )"
End Sub
Is the the most elegant way to proceed using CASE or is there a better way?
Any help with links to a close example or with the .xlam modifications and
the above code would be very helpful.
Thanks in Advance.