Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2016, 01:54 PM
masseve masseve is offline help! Windows 7 64bit help! Office 2010 64bit
Novice
help!
 
Join Date: Aug 2016
Posts: 1
masseve is on a distinguished road
Default help!

I really need someone's help with microsoft word

This is my problem
I would like to try and avoid embedding an excel table and would ideally like it to be in VB.

I have a table with three coloums

In coloum 1 I have a drop box with 3 conditions: 1, 2 and 3
In coloum 2 I have a drop box with 3 conditions:1, 2 and 3


In coloum 3 I just have a blank cell

I need to set up word so that if
1,1 is selected "Very Low" will show in the third coloum with a light green background fill
1,2 is selected "Low" will show with a dark green background fill
1,3 is selected "Low" will show with a dark green background fill
2,1 is selected "Medium" will show with a yellow background fill
2,2 is selected "Medium" will show with a yellow background fill
2,3 is selected "High" will show with a orange background fill
3,1 is selected "High" will show with a orange background fill
3,2 is selected "Very High" will show with a red background fill
3,3 is selected "Very High" will show with a red background fill
Thanks
Reply With Quote
  #2  
Old 08-18-2016, 06:18 PM
macropod's Avatar
macropod macropod is offline help! Windows 7 64bit help! Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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

You can do this using dropdown formfields and formula fields in a document with forms protection applied, with no programming at all, or using dropdown content controls and a ContentControlOnExit macro. Since we don't know what kinds of dropdowns you're using, it's impossible to give specific advice, though there are examples you can find via a search on this board of Word using both approaches.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Other Forums: Access Forums

All times are GMT -7. The time now is 06:31 AM.


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