Thread: How to populate a dropdown list with a spcific column in a specific worksheet
View Single Post
 
Old 03-17-2022, 05:24 AM
ericliu24 ericliu24 is offline Windows 10 Office 2019
Novice
  
Join Date: Mar 2022
Location: China
Posts: 21
ericliu24 is on a distinguished road
Default
Many thanks!

Private Sub FillDropdown()
strWorkbook = ThisDocument.Path & "\test2.xlsx"
Arr = xlFillArray(strWorkbook, strSheet)


a type mismatch error pops out.

As I would like to be able to define the column , where shall I input the column in the code? For example, If I would like to populate the data of column B of worksheet "general", what should I do?
Reply With Quote