Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-31-2018, 02:04 PM
Cold in Skagway Cold in Skagway is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 64bit
Novice
 
Join Date: Mar 2018
Posts: 3
Cold in Skagway is on a distinguished road
Default

Well I still don't understand how to get this to work.


I guess I am a "lead me by the hand" type of person.
Not thick or stupid, I just don't understand the "why" or "how" part I guess, or even the basics of it all.

Let me ask you this question.
If I did succeed it getting this to work, I would have to save it as a ".doxm" correct?
Would the person(s) wanting to use this form also have to have the macro installed and have to run it every time they fill in the info, or would it be automatic?

Please understand, the less clicks and fiddling around to get the form filled out and printed with the info the better.

Thanks again for the help.
Beth
Reply With Quote
  #2  
Old 04-01-2018, 03:54 AM
macropod's Avatar
macropod macropod is offline Multiple entries in dropdown lists Windows 7 64bit Multiple entries in dropdown lists Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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

Quote:
Originally Posted by Cold in Skagway View Post
If I did succeed it getting this to work, I would have to save it as a ".doxm" correct?
Would the person(s) wanting to use this form also have to have the macro installed and have to run it every time they fill in the info, or would it be automatic?

Please understand, the less clicks and fiddling around to get the form filled out and printed with the info the better.
If you were to save the document as a dotm template, double-clicking on that would allow the user to create a docx file that has full access to the code that drives the process. Alternatively, if the users are unlikely to have access to the template, you could distribute a docm document such as the one attached to post #2.

Whether the macro runs automatically in the case of a docm document largely depends on the user's macro security settings. With the template approach, that's not an issue.

As for "the less clicks and fiddling around to get the form filled out", all the user need do is select the appropriate entry from the dropdown and the output will be generated/updated as soon as the dropdown is exited. It could hardly be any simpler than that.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-11-2018, 10:45 AM
GregClaessens GregClaessens is offline Multiple entries in dropdown lists Windows 10 Multiple entries in dropdown lists Office 2016
Novice
 
Join Date: Apr 2018
Posts: 2
GregClaessens is on a distinguished road
Default Multiple values in different areas upon a single drop down selection.

Hi, my first post. Thanks to all for the effort.

I am making a template to analyze the legal position of potential clients facing residential evictions. I found this forum and thread because I wanted to be able to embed in my analysis document a drop down list from which to choose the type of eviction at hand. I want that selection to then generate for me the legal notes I have related to that type of eviction. The solutions posted here totally work and I am very happy with it. But now I am wondering if I could do more.

What I would like is to still have a single drop down to select eviction type, but I would like multiple output boxes with multiple values attached to the eviction selection. Specifically I want to be able to select the [eviction type] and see in one part of the document the {legal notes and elements} for that eviction type and then in another box the {notice requirements} for that eviction type.

I am pretty sure that this type of functionality could be created but I wonder if this solution is not the right way to achieve it. I have seen some documents that draw from spreadsheets. Maybe a spreadsheet would be the better way to define the various values that come with the eviction type selection.

If this method is ideal how would I go about defining the additional values? If there is a better way i'd appreciate any input. One of the hardest parts about being a novice with these tools is not knowing how to ask the right questions.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Multiple entries in dropdown lists Delete Multiple Entries dudeabides Office 1 07-04-2011 02:49 AM
Multiple task lists and multiple calendars kballing Outlook 0 01-18-2011 10:23 AM
Creating Multiple Contact Lists meltee78 Outlook 1 01-03-2011 09:45 PM
multiple calendar entries across a group halfhearted Outlook 0 10-11-2009 12:13 PM
Word Forms : Dropdown lists wferaera45 Word 0 04-06-2006 03:02 AM

Other Forums: Access Forums

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