Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-20-2013, 07:57 AM
Anja Anja is offline If statement and drop down Windows 8 If statement and drop down Office 2013
Novice
If statement and drop down
 
Join Date: Oct 2013
Posts: 6
Anja is on a distinguished road
Default If statement and drop down

Hi,

I have a drop down list with A, B, C and D possibilities.
If I choose an "A" in a drop down list, I want in the text later on "You choose A" is written, if I choose B in a drop down list I want "You choose B" to be written and so on.



So basically I have to connect drop down list with the if statement and I have no idea how to do it.

Thanks for the help

Anja
Reply With Quote
  #2  
Old 11-20-2013, 12:13 PM
macropod's Avatar
macropod macropod is offline If statement and drop down Windows 7 32bit If statement and drop down Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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

What kind of dropdown? Are you using ActiveX controls, formfields, content controls or a userform?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-21-2013, 01:42 AM
Anja Anja is offline If statement and drop down Windows 8 If statement and drop down Office 2013
Novice
If statement and drop down
 
Join Date: Oct 2013
Posts: 6
Anja is on a distinguished road
Default

I didn't even know that there are so many possibilities. I am using content controls. Sorry for not being clear.
Reply With Quote
  #4  
Old 11-21-2013, 03:51 AM
Anja Anja is offline If statement and drop down Windows 8 If statement and drop down Office 2013
Novice
If statement and drop down
 
Join Date: Oct 2013
Posts: 6
Anja is on a distinguished road
Default

{ IF { REF Dropdown1 } = "A" "You choose A” “" }
{ IF { REF Dropdown1 } = "B" "You choose B” “" }
{ IF { REF Dropdown1 } = "C" "You choose C” “" }

I tried this but nothing happens...

Thanks for the help

Anja
Reply With Quote
  #5  
Old 11-21-2013, 07:18 AM
gmaxey gmaxey is offline If statement and drop down Windows 7 32bit If statement and drop down Office 2010 (Version 14.0)
Expert
 
Join Date: May 2010
Location: Brasstown, NC
Posts: 1,428
gmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the roughgmaxey is a jewel in the rough
Default

Your field would have to be nested:

{ If { Dropdown1 } = "A" "You chose A""{ IF { Dropdown1 } = "B" "You chose B""{ IF { Dropdown1 } = "C" "You chose C""{ IF { Dropdown1 } = "D" "You chose D""" }" }" }" }

I would suggest linking your dropdown CC with another CC. This may offer some help:

http://gregmaxey.com/word_tip_pages/linked_content_control_dropdown_list.html
__________________
Greg Maxey
Please visit my web site at http://www.gregmaxey.com/
Reply With Quote
  #6  
Old 11-21-2013, 11:32 PM
macropod's Avatar
macropod macropod is offline If statement and drop down Windows 7 32bit If statement and drop down Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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 Anja,

Since you're using content controls, the field code approach you posted & Greg responded to won't work unless you (a) bookmark the relevant content control as 'Dropdown1' and (b) used a ContentControlOnExit macro to update fields in the document.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
If statement and drop down IF Statement to custom Drop-down Field Sammie0Sue Word VBA 2 11-04-2013 02:11 AM
Help, auto select drop down by another drop down value? skrallemand Word VBA 3 09-11-2013 11:55 AM
If statement and drop down DRop down list within text of If statement sbarron76 Mail Merge 2 05-03-2013 05:00 AM
If statement and drop down if statement piper7971 PowerPoint 1 08-19-2010 07:10 AM
If statement and drop down Help with IF statement! CPelkey Word 1 04-12-2010 09:06 AM

Other Forums: Access Forums

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