Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 03-09-2019, 12:12 AM
aussiew aussiew is offline Assigning Macro to Drop Down list Content Control Mac OS X Assigning Macro to Drop Down list Content Control Office 2016
Novice
Assigning Macro to Drop Down list Content Control
 
Join Date: Mar 2019
Posts: 3
aussiew is on a distinguished road
Default Assigning Macro to Drop Down list Content Control

Hi,



I have the following:

A document I sent to a customer when they select one of the 3 products. The 3 products are nicely listed in a 3 column table. I have a 3 column table depicting the 3 products with grey font color. If the customer selected product 1, I am formatting the table to change the font color to black for the selected product in this case column 1.

I am trying to do the following:

I inserted a Drop Down list Content Control object in the document and added 4 Items in drop down list. Prod1, Prod2, Prod3 and "Select Product".

I also created a macro that will select a column from a table in the same document and change the font color of the selected product. the macro works fine but I cannot find a way to assign this macro to the Drop Down List. I do not wish to use the legacy drop down list because I tried this and the document needs to be protected, which introduces other issues.

I would appreciate some guidance or anyone pointing me out to a similar thread.

cheers

aussiew

Last edited by aussiew; 03-09-2019 at 06:20 AM. Reason: assigning macro to Drop Down list Content Control
Reply With Quote
 

Tags
conditional formatting, drop down list content



Similar Threads
Thread Thread Starter Forum Replies Last Post
Assigning Macro to Drop Down list Content Control Conditional Formatting - Duplicates - Apply to specified range music_al Excel Programming 1 01-25-2017 05:34 AM
Assigning Macro to Drop Down list Content Control Can I apply conditional formatting to text in a drop down menu? Keokira Word 1 04-07-2016 08:22 AM
Assigning Macro to Drop Down list Content Control The Logic Behind Apply Formatting of Surrounding Text in Reveal Formatting Pane Instructor Mark Word 4 04-06-2016 01:32 PM
Can't reset form fields (Word 2013) and conditional formatting rogelinepaula Word VBA 24 01-07-2016 03:54 PM
Conditional Formatting: How to dynamically apply to an expanding table? tinfanide Excel 0 10-18-2013 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09: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