Excel Forum

Compile error having copied your "Display all...userform

Barry Pegram

Gloucestershire UK

Member

Members

Forum Posts: 14

Member Since:
March 21, 2022

Offline

March 21, 2022 - 8:23 pm

Display All Matches from Search in Userform ListBox

AUGUST 20, 2020 BY PHILIP TREACY

Hi. Recently discovered the above program. I am very much a beginer at VBA so have probably made some simple copying error when I tried to reproduce the example to suit my (budding) gardening almanac spreadsheets.

Anyway I have an error that I don't understand - something silly no doubt...:

Error msg is "Method or data member not found" this occurs whin I try to enter data into the form. The error highlight occurs in the first Case statement as: ".Clear"

I have (hopefully) attached the test file I am using.

Any help will be much appreciated.

Thanks in anticipation

Beepee

See Answer

Velouria

London or thereabouts

Moderator

Members

Trusted Members

Moderators

Forum Posts: 689

Member Since:
November 1, 2018

Offline

March 22, 2022 - 7:07 am

Your Results control is a textbox, but should be a Listbox.

Answers Post

Barry Pegram

Gloucestershire UK

Member

Members

Forum Posts: 14

Member Since:
March 21, 2022

Offline

March 23, 2022 - 1:22 am

Thought it would be something straightforward. Many thanks this problem is now resolved - not getting the right results displayed but I'll try to resove myself... but I may be back.

Cheers!

Barry Pegram

Gloucestershire UK

Member

Members

Forum Posts: 14

Member Since:
March 21, 2022

Offline

March 23, 2022 - 3:37 am

Hello again -- said I may be back. I think my mum told me about biting off more than I can chew!!!!!

Sorted the ListBox issue thanks. Now it works in a limited way. It only list the first field (IDRef) the remaining fields, in the list box, remain empty. I really thought I had copied Philip T's. code carefully but I presume not. However I cannot see where I have gone wrong.

Again thanks in anticipation to whoever comes to my rescue.

regards

Beepee