Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #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
 

Tags
vba, vba code, word 10



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 04:20 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