vFound to search in column A only

[WCJanssen]

Hi there

I'm using the following code to search a sheet and copy any matching data to a listbox on a userform:

Please Login or Register  to view this content.

However, i'd like it to search column A only. Can this be done? And if so, how? Thanks in advance.

[rylo]

Hi

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

[WCJanssen]

Hi

change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

rylo

hi,

thanks for your response; after making the replacement I keep getting the error "argument not optional", though. Any ideas?

[rylo]

Hi

Did you change just that part of the code, or did you replace the entire find statement with the snip I provided? What does your full code look like now?

rylo

[WCJanssen]

Hi,

It now looks like this:

Please Login or Register  to view this content.

[Phil_V]

You need to fix your closing code tag, it should be [/code].

Your MsgBox lines shouldn't have the brackets around the arguments.
What line is highlighted in the VB editor when you get the error message?

[rylo]

Hi

How about adding an example file that shows some sample data and all relevant code / forms etc.


Also the findnext line will need to have the range changed.

rylo

[WCJanssen]

Hi,

thanks for your help so far; here's the example file.

Wilco

[rylo]

Hi

OK, how about

Please Login or Register  to view this content.

rylo

[WCJanssen]

Hi,

That returns the error "named argument not found".

Wilco

[rylo]

HI

I opened your sample file, replaced your code with the code I gave, then adjusted your code for Query_Change as shown below (there doesn't seem to be a sub called filterdeceased in your example file), and it ran through.

Please Login or Register  to view this content.

Can you update your example file to show what you have, explain the steps you take to make things work, and nominate exactly where the error occurs.

rylo