“variable not defined” WITH FILTERED COMBOBOX/ LISTBOX COMBINATION

Greeting All,
I’m having some trouble with the below code. I’m trying to filter a my listbox with a combobox but continue to receive a “variable not defined” error. Any assistance is greatly appreciated. File also attached and as always thank you everyone!!!
v/

Please Login or Register  to view this content.

Initial problem cause - you refer in your code to sheet2 - you have renamed its code name in properties to SH2
Also some of your cell referencing does not align with your form controls (i.e. textboxes etc.)
if you are filtering your listbox using a combobox you will need a means of keeping note of actual row position if you are then going to edit retrieved data.

Torachan,

you are absolutely correct. it's sloppy coding from long hours of mixing and matching code, desperately trying to get it to work. I've cleaned it up a bit, but now when I select a item from the dropdown combobox, my entire listbox disappears rather than produce a result. can I trouble you for some further assistance. thank you again.

Please Login or Register  to view this content.

Remove this line:

Originally Posted by RoroBear

Dim Sheet2 As Range

Phuocam,

So close! removing "Dim Sheet2 As Range" worked, but there is one small problem. it's not producing complete results. for example, there are 4 people in team DELTA, but when I select DELTA only 3 results show up. thank you for the speedy reply by the way.

roro

Change:

For i = 5 To Application.WorksheetFunction.CountA(Sheet2.Range("E:E"))

to:

For i = 2 To Application.WorksheetFunction.CountA(Sheet2.Range("E:E"))

Phuocam,

it worked brilliantly! idk what i'd do without this forum. thank you everyone!

v