Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-19-2018, 05:42 PM
Jentis Jentis is offline Activate (show) a Drop-down form field when another drop-down form field is selected from Windows 10 Activate (show) a Drop-down form field when another drop-down form field is selected from Office 2010 32bit
Novice
Activate (show) a Drop-down form field when another drop-down form field is selected from
 
Join Date: Nov 2017
Location: Adelaide, Australia
Posts: 1
Jentis is on a distinguished road
Default Activate (show) a Drop-down form field when another drop-down form field is selected from


Hi. I am using a Word template with various macro's, and legacy fields, and its working well. One of the options in the form if for a user to make a choice from a fairly extensive drop-list of 'services'. The trouble I have is that a user may wish to only choose 1 service, or they could choose up to 10 services from the list. I don't want to have 10 drop-down boxes visible on the form as it looks messy. I'd rather have 1 visible, and then when a user selects a service from the 1st drop-list, then add a 2nd drop-down list (with the same data). If they select from the 2nd list, then add a 3rd list etc. until we get to 10 lists max.
Can anyone assist me with some VBA code to achieve this? I can then add the macro to the form field's properties to run on exit. Thanks in advance
Reply With Quote
  #2  
Old 04-19-2018, 09:42 PM
macropod's Avatar
macropod macropod is offline Activate (show) a Drop-down form field when another drop-down form field is selected from Windows 7 64bit Activate (show) a Drop-down form field when another drop-down form field is selected from Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

How would Word know whether the user needed another dropdown to appear?

You may be interested in: https://www.msofficeforums.com/word-...html#post38312. The technique employed there could be used to conditionally replicate your dropdown in additional table rows.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
vba, vba code, word 10

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Activate (show) a Drop-down form field when another drop-down form field is selected from Macro to autofill a form field ONLY if the form field is blank upon entry Pindar Word VBA 2 01-12-2017 05:03 PM
form control Field - Drop down auto text mrtinfl Word 5 11-19-2014 06:57 AM
Activate (show) a Drop-down form field when another drop-down form field is selected from Form Field Drop Down List James Ayers Word 3 07-14-2013 07:53 PM
Word Form/ActiveX drop down menu/value in a different field AMackenzieFFCU Word VBA 1 01-14-2013 07:48 AM
Activate (show) a Drop-down form field when another drop-down form field is selected from Form Field - Drop down selection causing auto text chesspupil Word VBA 7 05-09-2010 05:43 AM

Other Forums: Access Forums

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