Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Closed Thread
 
Thread Tools Display Modes
  #1  
Old 04-10-2013, 03:32 AM
macropod's Avatar
macropod macropod is offline Change color according with dropdown selection Windows 7 64bit Change color according with dropdown selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
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

Hi spk,



In your original post, you included a link for working with formfields. Even the 'problematic' line you referred to mentions them. Given that, and your own references to bookmarks, I concluded you were working with formfields. The dropdowns you're having issues with, though, are content controls. Content controls are entirely different from formfields and don't have a bookmark property.

For demonstrations of dropdown formfield and dropdown content control implementation, see the attached.

Note 1: There are two versions for formfields - one requiring macros (the .docm file), the other not requiring them (the .docx file). The content control version also requires a macro. The macros are already present in the files concerned. Press Alt-F11 to see the VBA code. For the formfield versions, unprotect the document then press Alt-F9 to see the field coding.

Note 2: Formfields and content controls should not be used in the same document; they are not designed to work together.

For PC macro installation & usage instructions, see: Installing Macros
For Mac macro installation & usage instructions, see: Word:mac - Install a Macro
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
  #2  
Old 04-10-2013, 01:50 PM
spk spk is offline Change color according with dropdown selection Windows 7 64bit Change color according with dropdown selection Office 2010 32bit
Novice
Change color according with dropdown selection
 
Join Date: Apr 2013
Posts: 6
spk is on a distinguished road
Default

Wow, it works perfectly!
I didn't know about content controls, but at the end I managed to create different ones based on your model.
Thank you so much
  #3  
Old 06-16-2014, 05:14 PM
ejungk99 ejungk99 is offline Change color according with dropdown selection Windows 7 64bit Change color according with dropdown selection Office 2010 64bit
Novice
 
Join Date: Jun 2014
Posts: 20
ejungk99 is on a distinguished road
Default

Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection. Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?
  #4  
Old 06-16-2014, 05:19 PM
macropod's Avatar
macropod macropod is offline Change color according with dropdown selection Windows 7 32bit Change color according with dropdown selection Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,518
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

Quote:
Originally Posted by ejungk99 View Post
Hi Paul, was looking at your "content control conditional formatting" file and it doesn't seem to color the cell after the selection.
The macro only colours the cell containing the content control - because that's all it was written to do - and is only activated once the content control is exited.
Quote:
Also after selecting one of the dropdowns I keep getting an error message in VBA "ambiguous name detected". I'm sure this is some error on my end but do you have any suggestions?
That suggests you have two or more macros with the same name, in which case you're using more than just the conditional format document as provided.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Closed Thread

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
Change color according with dropdown selection Dropdown selection value coconutt Word VBA 5 09-13-2012 05:23 PM
Change color according with dropdown selection Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM
Change color according with dropdown selection 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

Other Forums: Access Forums

All times are GMT -7. The time now is 08:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft