Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-18-2012, 05:31 PM
pmregan pmregan is offline Conditional format for form drop-down list? Windows 7 32bit Conditional format for form drop-down list? Office 2010 32bit
Novice
Conditional format for form drop-down list?
 
Join Date: Aug 2011
Posts: 1
pmregan is on a distinguished road
Question Conditional format for form drop-down list?

I wasn't sure if this question should go into "UserForms" or "VBA". Please help me repost if I goofed...



I would like to add a drop-down list called "Results" to a form. The list would have three options: "PASS," "FAIL," or "NA/Not Tested." I would like to format the text of the selected option so that "PASS" appears in green, "FAIL" appears in red, and "NA/Not Tested" remains unchanged.

Can anyone help me accomplish this? I can create the drop-down, and populate the list, but I can't figure out how to wrap any code around it.
Reply With Quote
  #2  
Old 09-19-2012, 07:09 PM
macropod's Avatar
macropod macropod is offline Conditional format for form drop-down list? Windows 7 64bit Conditional format for form drop-down list? 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

To do this the formfield needs an 'on exit' macro. See attached.
Attached Files
File Type: doc Pass-Fail.doc (47.0 KB, 115 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
drop-down, form, formatting



Similar Threads
Thread Thread Starter Forum Replies Last Post
Drop down list, Can it be done??? garethreid Outlook 0 08-09-2012 06:08 AM
Drop Down Form Help jwm1346 Word 3 07-31-2012 07:49 PM
Conditional format for form drop-down list? Drop Down List using SYMBOLS sm5948 Word 2 09-28-2011 05:05 AM
Conditional format for form drop-down list? Conditional data validation (list drop-down) click4akshay Excel 2 04-28-2011 01:51 PM
25 item max in drop down form sonicvalley Word 0 07-26-2010 11:12 PM

Other Forums: Access Forums

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