#1
|
|||
|
|||
VAB Macro to Change colour for Activex Check Boxes
I have created one Word form with mutiple Activex check box. Need VBA Macro to change the background colour of the Activex check box whichever selected in document. Cureently created macro for each box, however original form has more than 100 and it is taking time to create macro for each one separately. please assist. Attached the sample word document. MS office version is office365 Enterprise.
Last edited by ganeshadu; 02-18-2024 at 06:33 PM. |
#2
|
||||
|
||||
I'm not using a Mac anymore but was under the impression that ActiveX only worked on Windows. Are you saying you can get this to work on a Mac - but want to figure out how to make the macro automated for multiple instances?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
Sorry for the confusion. MAC is the document name. Using windows only. Corrected the original post.
|
#4
|
||||
|
||||
I think you should be using Checkbox Content Controls and then the OnExit macro can do all the automation work. There are several example macros on how to do this with Content Controls. Maybe start with this thread
https://www.msofficeforums.com/word-...ox-marked.html
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#5
|
|||
|
|||
Thanks. Works fine with Content control check box. However need help with Activex Check box since I have some other functionality like select multiple check box based on one check bo, showing msg box instruction.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro to insert different sets of text at bookmark depending on sequence of selected check boxes | chipper09 | Word VBA | 0 | 06-21-2018 01:49 PM |
Macro (or something) to run Spell Check within rich text content boxes in lock document | NMBELL | Word | 8 | 12-21-2015 04:09 PM |
VBA/Macro to change one colour in chart to another | lsmcal1984 | Excel Programming | 1 | 11-12-2013 07:41 AM |
Word2010 check boxes and plain text content control boxes in same table | fcsungard | Word | 5 | 06-01-2012 01:16 AM |
How do I Convert All Legacy Check Boxes to ActiveX? | GreenPolyps | Word | 1 | 12-20-2011 05:11 PM |