Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-23-2021, 09:00 AM
roseheller roseheller is offline Creating a Macro in VBA where a Dropdown Box Populates Text Bookmarks below Windows 10 Creating a Macro in VBA where a Dropdown Box Populates Text Bookmarks below Office 2019
Novice
Creating a Macro in VBA where a Dropdown Box Populates Text Bookmarks below
 
Join Date: Feb 2021
Posts: 3
roseheller is on a distinguished road
Default

Well then, in order of the solutions you gave me:

1. "For a demonstration, see: https://www.msofficeforums.com/word/16379-form-auto-fill-based-different-field-value.html#post46429"

--> When I downloaded the document, I see the Dept drowpdown: HR/Finance... and I also see that there is "Code" and "Location" just below. However, when I click on HR or Finance, nothing happens beyond my selecting those words. Nothing else pops up.
--> I have tried using IF and REF (with the appropriate Form Field CTRL + FN + F9) but they don't seem to work on my version of Word because nothing happens. It just becomes invisible text once I disappear the Form Fields with ALT + FN + F9.

2. "An alternative would be to use Content Controls, plus VBA. For a demonstration, see: https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists.html#post46903"



--> When I select Smiths Wholesales/Roundhouse Nurseries, nothing happens immediately. However, I did notice just now, when I was clicking on the page to copy the text, that text appears below, but only if I click on the empty "Client Details" form.... or if I click TAB (now that I've looked at solution number 3 in greater detail)
--> This seems like the best option for me to use. I'll need to explain it to the company I'm volunteering for, but this might just be what I'll use.

3. "and, for different elements from a selected item to be output to different content controls, see: "https://www.msofficeforums.com/word-vba/16498-multiple-entries-dropdown-lists-5.html#post120392"

--> Ah... okay, I realize what the problem was. I used the "TAB" click whilst it was still in the form version and also when it was protected but only at the location of the "IF" and "REF" statement... I tried it whilst "Protection is enabled" and it worked.

Please disregard my statement for the 1st solution... this has all been user error on my end. Sorry, I'm really a VBA amateur so this is one heck of a learning curve on my end. Thank you for your patience.

Since I need to create large tables, paragraphs, and indents for each dropdown choice (see screenshot for example) which engineers would need to be able to edit/add information to... what do you recommend?
Attached Images
File Type: png Screenshot (36).png (9.7 KB, 24 views)
Reply With Quote
  #2  
Old 02-23-2021, 03:10 PM
macropod's Avatar
macropod macropod is offline Creating a Macro in VBA where a Dropdown Box Populates Text Bookmarks below Windows 10 Creating a Macro in VBA where a Dropdown Box Populates Text Bookmarks below Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,373
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

You really need to pay attention to the instructions in the links I provided. Both threads say quite clearly that you need to exit the dropdowns for the updates to occur.

As for
Quote:
Originally Posted by roseheller View Post
Since I need to create large tables, paragraphs, and indents for each dropdown choice (see screenshot for example) which engineers would need to be able to edit/add information to... what do you recommend?
you might start with any of:
https://www.msofficeforums.com/word-...html#post87989
https://www.msofficeforums.com/word-...html#post38461
https://www.msofficeforums.com/word-...tml#post145675
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Link CC dropdown to dependent dropdown AND text box trailrunnertcm Word VBA 4 02-11-2021 08:04 AM
Selecting Drop-Down Auto-Populates formatted paragraphs of text jsarchibald Word VBA 2 01-06-2021 03:47 AM
Macro to hide/unhide text to call variable bookmarks Dr. Z Word VBA 2 05-27-2017 08:20 PM
Building blocks show correctly in dropdown, but wrong building block populates in doc wordgirl123 Word 0 10-03-2013 08:30 AM
Macro to populate a text form field based on dropdown selection koloa Word 0 10-20-2011 11:52 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:09 AM.


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