Help with Dropdown Lists

Gerardo G · #1 06-17-2015, 10:23 AM

Quote:

Originally Posted by spk

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!

Hi guys, I´m creating a template for a Weekly status report, so I need to:

-Use check box for each name ( meeting attendance) and if box checked automatically trigger text format to green (representing attendees) and if not checked format set to yellow.

-Use content control drop down list and edit each field with different formatting when selected.

-Insert a field to calculate operations (representing % of project status) and then maybe trigger 3 different status icon/figure depending on % of project completed. red ligh (0 -30), yellow (31 - 80) and green (81 - 100)

Please I would appreciate a lot your help. thanks

This is the doc, I'm trying to edit with the conditions I posted as quick reply, again I'd appreciate your help for this, I've tried without succes.

Thanks

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Multiple entries in dropdown lists	paul_pearson	Word VBA	151	10-18-2023 04:23 PM
Excel DropDown Lists disappear	janehoss	Excel	0	12-09-2014 01:05 PM
Dropdown Lists in Excel 2010	janehoss	Excel	0	12-01-2014 07:16 AM
dropdown lists and date picker added to word doc.	greg__reynolds	Word	3	05-19-2014 12:19 AM
Word Forms : Dropdown lists	wferaera45	Word	0	04-06-2006 03:02 AM