listbox counts 6 when theres 7

[cfinch100]

hi
anyone any ideas please my listbox1 only displays 6 entries although counts 7 instances found , does this for any amount it always comes up 1 short
tried entering a2 in code and allsorts ,just lost me
cheers colin
hi click search /add
enter 2 in 1st box
click search
cheers colin

[rcm]

could you send the listbox ?

[cfinch100]

ita attached to first thread
cheers colin

[cfinch100]

ita attached to first thread
cheers colin

[Norie]

Colin

When I try it says there are 6 but only displays 5 in the listbox, but when I look at the worksheet the filter list has 6 rows.

[Norie]

I made some very small changes in cmdSearch_Click, I've commented them in the code.

Please Login or Register  to view this content.

[cfinch100]

hi norie
not sure what happened then i replied and sent but went missing ,never mind as usual sheer genius many thanks for that got one question if i enter an ainscough ref no it some how gets transferred into purchase or colloumn as well through the userform any thoughts many thanks yet again
cheers colin