Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-03-2020, 10:05 PM
DeanMcK DeanMcK is offline VBA to reference the selection of a dropdown box Windows 10 VBA to reference the selection of a dropdown box Office 2016
Novice
VBA to reference the selection of a dropdown box
 
Join Date: May 2020
Posts: 3
DeanMcK is on a distinguished road
Default VBA to reference the selection of a dropdown box

Hi All,

New to VBA in Word and I want to know how I can reference the selection made from a drop down list. eg:

Dropdown list contains AAA, BBB, CCC and DDD

If CCC is selected how do I refernece this choice?

Any help appreciated.



Cheers

Dean
Reply With Quote
  #2  
Old 05-03-2020, 10:19 PM
macropod's Avatar
macropod macropod is offline VBA to reference the selection of a dropdown box Windows 7 64bit VBA to reference the selection of a dropdown box 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?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-03-2020, 10:26 PM
DeanMcK DeanMcK is offline VBA to reference the selection of a dropdown box Windows 10 VBA to reference the selection of a dropdown box Office 2016
Novice
VBA to reference the selection of a dropdown box
 
Join Date: May 2020
Posts: 3
DeanMcK is on a distinguished road
Default

I created a drop down list Content Control from Developer. attached an example
Attached Files
File Type: docx The agreement is between CCC.docx (18.3 KB, 6 views)
Reply With Quote
  #4  
Old 05-03-2020, 10:31 PM
macropod's Avatar
macropod macropod is offline VBA to reference the selection of a dropdown box Windows 7 64bit VBA to reference the selection of a dropdown box 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

See, for example:
https://www.msofficeforums.com/word-...html#post46903
and, for different elements from a selected item to be output to different content controls, see:
https://www.msofficeforums.com/word-...tml#post120392
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-03-2020, 10:37 PM
DeanMcK DeanMcK is offline VBA to reference the selection of a dropdown box Windows 10 VBA to reference the selection of a dropdown box Office 2016
Novice
VBA to reference the selection of a dropdown box
 
Join Date: May 2020
Posts: 3
DeanMcK is on a distinguished road
Default

Thanks Paul,

Will have a look - I'm used to VBA in Excel but have never used it in Word.

Cheers

Dean
Reply With Quote
Reply

Tags
vba form



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to reference the selection of a dropdown box Change color according with dropdown selection spk Word VBA 43 07-31-2022 03:51 PM
VBA to reference the selection of a dropdown box Multiple Selection Dropdown list ajanson Word VBA 36 07-15-2019 08:16 PM
VBA to reference the selection of a dropdown box Dropdown Selection Error Bigmojo5 Word 1 06-29-2018 06:43 PM
Selection of a dropdown creates another dropdown wih the list krishnamurthy.ka2810 Word VBA 1 04-26-2018 11:44 PM
VBA to reference the selection of a dropdown box Dropdown selection value coconutt Word VBA 5 09-13-2012 05:23 PM

Other Forums: Access Forums

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