#1
|
|||
|
|||
Change color according with dropdown selection
Hello,
I'm doing a document with dropdown menus, and I'd like to insert a color code for easy reading. These dropdows are in a table, so ideally, the the color would apply to the cell background. The document doesn't need to be protected. For instance, I've a dropdown named "Material" in a cell of a tab, with two entries: "mat1" and "mat2". I would like to color the cell background in light blue when "mat1" is selected, and in light green when "mat2" is selected. I found this: http://www.wordbanter.com/showthread.php?t=67444 But I don't manage to use it, I get an error run-time '5941' the requested member of the collection does not exist. The problematic line is: Select Case ActiveDocument.FormFields("ColorPicker").Result I replaced "ColorPicker" by the name of my dropdown, I put my dropdown in a bookmark with the same name... If it works, we would save time and probably avoid mistakes! |
Tags |
color, dropdown, reaction |
|
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 |