Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-17-2015, 10:23 AM
Gerardo G Gerardo G is offline Help with Dropdown Lists Windows 7 64bit Help with Dropdown Lists Office 2010 64bit
Novice
Help with Dropdown Lists
 
Join Date: Jun 2015
Posts: 1
Gerardo G is on a distinguished road
Default

Quote:
Originally Posted by spk View Post
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
Attached Files
File Type: docm Status_Report_EES_20150615_New_Template 22.docm (297.0 KB, 9 views)

Last edited by macropod; 06-18-2015 at 11:02 PM. Reason: Split from: http://www.msofficeforums.com/word-vba/16505-change-color-according-dropdown-selection.html
Reply With Quote
  #2  
Old 06-18-2015, 11:10 PM
macropod's Avatar
macropod macropod is offline Help with Dropdown Lists Windows 7 64bit Help with Dropdown Lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It would be helpful if you actually had the content control checkboxes in your document, preferably in the paragraphs to which they relate.

The same applies to the content control dropdown list for which you want to vary the formatting (plus a clear description of what those variations are.

As for your 'field to calculate operations', you might say where, exactly that is to go and what specific inputs are used for this. Likewise, you should include the 'status icon/figure' for the conditional colouring.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with Dropdown Lists 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

Other Forums: Access Forums

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