Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-22-2022, 07:38 AM
gmayor's Avatar
gmayor gmayor is offline Userform listbox reading from external excel Windows 10 Userform listbox reading from external excel Office 2019
Expert
 
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default


I think the attached will explain how the various bits go together. Put the two files from the zip in the same folder then create a new document from the template.
Attached Files
File Type: zip ListBox example.zip (40.3 KB, 5 views)
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 12-22-2022, 09:04 AM
austria130 austria130 is offline Userform listbox reading from external excel Windows 11 Userform listbox reading from external excel Office 2019
Novice
Userform listbox reading from external excel
 
Join Date: Dec 2022
Posts: 8
austria130 is on a distinguished road
Default

Quote:
Originally Posted by gmayor View Post
I think the attached will explain how the various bits go together. Put the two files from the zip in the same folder then create a new document from the template.
Thank you. Unfortunately im kinda lost on using templates and vba...after all i am very confused.

Therefore i am uploading a test-document in here as a docx file.


Notice: this document will be uploaded to a server where several users can download the word and should be able to see the processes in there. Is that even possible as the excel will not be on their machine? (however, this is not a big issue)

What i want to achieve is that where i have my "BOOKMARK1" in the document the user can open a dropdown list and choose multiple processes which are in a column of an external Excel. As i found out, word does not offer multiple selection via the simple dropdown therefore i need to implement a userform into that word document?

All the code lines make no sense for me as a beginner as they are not comented one by one :S

Maybe there is another simpler solution to this?
Attached Files
File Type: docx Testbatch1.docx (12.6 KB, 4 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform listbox reading from external excel Yet another Multi-Select Listbox in Userform question Javir Word VBA 4 09-24-2019 01:01 AM
Dynamic Userform multiselect listbox populate trevorc Excel Programming 1 12-03-2018 02:49 PM
How do I code ListBox and DatePicker in UserForm? - Word 2013 ickelly Word VBA 4 08-05-2015 04:07 PM
This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel Programming 14 08-18-2014 08:14 PM
Userform listbox reading from external excel This is a Userform LIstbox queston: A variable does not set to the value of a listbox CatMan Excel 1 08-08-2014 09:41 AM

Other Forums: Access Forums

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