Change color according with dropdown selection

ejungk99 · #1 06-16-2014, 05:14 PM

Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection. Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?

macropod · #2 06-16-2014, 05:19 PM

Quote:

Originally Posted by ejungk99

Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection.

The macro only colours the cell containing the content control - because that's all it was written to do - and is only activated once the content control is exited.

Quote:

Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?

That suggests you have two or more macros with the same name, in which case you're using more than just the conditional format document as provided.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
block selection in dropdown list	Intruder	Excel	2	01-10-2013 10:20 AM
Dropdown selection value	coconutt	Word VBA	5	09-13-2012 05:23 PM
Change cell color when selection is made from a drop down list	fedcco	Excel	12	08-28-2012 10:43 PM
Autofill a form which is contingent on a dropdown selection.	biffle0764	Word	2	05-09-2012 12:54 PM
Change cell color everytime a value is selected in dropdown list	angelica_gloria	Excel	4	01-27-2012 06:47 PM