Thread: [Solved] How to populate a userform combobox from an excel worksheet
View Single Post
 
Old 09-15-2018, 08:03 PM
gmayor's Avatar
gmayor gmayor is offline Windows 10 Office 2016
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
If you are using a named range rather than a worksheet you need to tell the macro.

You have RangeIsWorksheet set as True, when it should be False and if the named range doesn't include a header row you need to also set RangeIncludesHeaderRow to False.

This was incorrectly shown on the web site and has been fixed.
__________________
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