Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2024, 12:38 AM
ganeshadu ganeshadu is offline VAB Macro to Change colour for Activex Check Boxes Windows 10 VAB Macro to Change colour for Activex Check Boxes Office 2019
Novice
VAB Macro to Change colour for Activex Check Boxes
 
Join Date: Feb 2024
Posts: 3
ganeshadu is on a distinguished road
Default 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.
Attached Files
File Type: docm Sample.docm (51.6 KB, 5 views)

Last edited by ganeshadu; 02-18-2024 at 06:33 PM.
Reply With Quote
  #2  
Old 02-18-2024, 06:26 PM
Guessed's Avatar
Guessed Guessed is offline VAB Macro to Change colour for Activex Check Boxes Windows 10 VAB Macro to Change colour for Activex Check Boxes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #3  
Old 02-18-2024, 06:34 PM
ganeshadu ganeshadu is offline VAB Macro to Change colour for Activex Check Boxes Windows 10 VAB Macro to Change colour for Activex Check Boxes Office 2019
Novice
VAB Macro to Change colour for Activex Check Boxes
 
Join Date: Feb 2024
Posts: 3
ganeshadu is on a distinguished road
Default

Sorry for the confusion. MAC is the document name. Using windows only. Corrected the original post.
Reply With Quote
  #4  
Old 02-18-2024, 07:22 PM
Guessed's Avatar
Guessed Guessed is offline VAB Macro to Change colour for Activex Check Boxes Windows 10 VAB Macro to Change colour for Activex Check Boxes Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,969
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

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
Reply With Quote
  #5  
Old 02-19-2024, 04:58 PM
ganeshadu ganeshadu is offline VAB Macro to Change colour for Activex Check Boxes Windows 10 VAB Macro to Change colour for Activex Check Boxes Office 2019
Novice
VAB Macro to Change colour for Activex Check Boxes
 
Join Date: Feb 2024
Posts: 3
ganeshadu is on a distinguished road
Default

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.
Reply With Quote
Reply



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
VAB Macro to Change colour for Activex Check Boxes 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
VAB Macro to Change colour for Activex Check Boxes How do I Convert All Legacy Check Boxes to ActiveX? GreenPolyps Word 1 12-20-2011 05:11 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft