Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-25-2024, 07:49 AM
aguecil aguecil is offline Looking to change shape color by clicking Windows 10 Looking to change shape color by clicking Office 2021
Novice
Looking to change shape color by clicking
 
Join Date: Jun 2024
Posts: 5
aguecil is on a distinguished road
Default Looking to change shape color by clicking


I am creating a fillable form and want to be able to click on a circle to change it from green to yellow to red and back again. How would I do this?
Reply With Quote
  #2  
Old 06-25-2024, 04:35 PM
Guessed's Avatar
Guessed Guessed is offline Looking to change shape color by clicking Windows 10 Looking to change shape color by clicking Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,158
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 will recommend doing this without macros because this method should be easy enough to implement.

Start by creating an inline circle and colouring it. Now select it and save it as a building block. I chose to put it in as an Autotext and assigned a category of 'Traffic Light'. Give it a name along the lines of the colour you chose. Now change the colour of the circle and save it as another Autotext/Traffic Light. Change it again and do the same so that you now have three Autotext/Traffic Light building blocks.
Next step is to add a Building Block Gallery Content Control to your form. You can change its properties so that it shows the members of the Autotext/Traffic Light.

The tricky part will be deciding WHERE to save the building blocks. If this only has to work on your machine, the default template of Normal or Building Blocks will be fine. However if you are intending this to work on other people's machines, the form should be saved as a template (dotx or dotm file) and you will need to save the building blocks into that template itself.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 06-26-2024, 02:32 AM
Italophile Italophile is offline Looking to change shape color by clicking Windows 11 Looking to change shape color by clicking Office 2021
Expert
 
Join Date: Mar 2022
Posts: 538
Italophile is just really niceItalophile is just really niceItalophile is just really niceItalophile is just really nice
Default

Create your fillable form using content controls rather than the legacy ActiveX controls. That way you can use the Building Block Gallery Content Control as Andrew suggests.

Do not mix content controls and legacy ActiveX controls.
Reply With Quote
  #4  
Old 06-26-2024, 08:03 AM
Charles Kenyon Charles Kenyon is offline Looking to change shape color by clicking Windows 11 Looking to change shape color by clicking Office 2021
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I agree with the suggestions made. Here are some references.
If you want to go the macro route, see Add Interactive Toggle or Sequenced Object to Document by Greg Maxey
Reply With Quote
  #5  
Old 06-26-2024, 12:18 PM
aguecil aguecil is offline Looking to change shape color by clicking Windows 10 Looking to change shape color by clicking Office 2021
Novice
Looking to change shape color by clicking
 
Join Date: Jun 2024
Posts: 5
aguecil is on a distinguished road
Default Resolved

Thank you for your help, this worked wonderfully!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking to change shape color by clicking Word 16/19 change font and outside border color (same color) eg is red change to pink jec1 Word VBA 2 12-04-2019 11:32 PM
Color change of a shape after a click, and in a random mode Splintkill PowerPoint 2 08-26-2019 07:41 AM
How to change size / shape of a shape in a stencil tomgoodell Visio 1 06-30-2016 04:40 AM
Looking to change shape color by clicking Change accent theme color used as shape fill (not RGBs) preetidb PowerPoint 4 12-30-2013 03:22 PM
color change for same shape ajkiran PowerPoint 1 11-10-2012 07:41 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:54 PM.


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