PDA

View Full Version : custom ribbon how to access checkbox



glda19
01-17-2019, 01:53 PM
Hi

How can i get the status of a checkbox on the ribbon.?
Can access the checkbox or other controls by the id ?
A great help is to give the lines of code to do it

Rick Rothstein
01-17-2019, 03:08 PM
How can i get the status of a checkbox on the ribbon.?

There is probably a direct access via the Application object or a property of the sheet or range.

Which checkbox did you want to get the status of?

Rick Rothstein
01-17-2019, 03:14 PM
*** DUPLICATE POSTING ***

https://www.mrexcel.com/forum/excel-questions/1084045-custom-ribbon-how-access-checkbox.html

glda19
01-17-2019, 03:35 PM
a checkbox on a custom tab on ribbon