python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - listproperty

VBA UserForm Issue - Could not set the list property. Invalid property array index

The below code works as long as there are more than one instance of the search criteria. However, if there is only one row that is listed as the what in the find function I receive the error "Co...
test-img

TDorman

excel

vba

userform

listproperty

Votes: 0

Answers: 1

Latest Answer

When your range contains one cell, the .value will give you a value instead of an array. As the .list expects an array you could fill an array with one element or use addItem (see below) If Worksheets...
test-img

EvR

Posts

Questions

Blogs

Jobs