Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Toggle Text button between two options code needed
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toggle button - procedure works but elegance needed (xl2007) | Excel Programming | |||
Toggle Button Format Options | Excel Programming | |||
Command button to toggle worksheet event code on / off? | Excel Discussion (Misc queries) | |||
VBA Code to Create a Toggle Button | Excel Programming | |||
toggle button & event code | Excel Programming |