Thread: Userform listbox reading from external excel
View Single Post
 
Old 12-27-2022, 05:21 AM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,144
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
There were a number of issues. The userform code changes are self explanatory. The processing takes place in the ShowMyForm macro.
Tools > References had an unwanted and missing reference to a document.
strText was defined as an Integer, instead of a string.
__________________
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