View Single Post
 
Old 04-19-2018, 05:42 PM
Jentis Jentis is offline Windows 10 Office 2010 32bit
Novice
 
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