Compile error: Invalid qualifier with inputbox

I am filtering duplicate data in a table based on a column that the user can select. I would like an inputbox to open, then ask the user which column to filter. If there is only 1 column selected, run the code, otherwise cancel (it would be ideal if a msgbox opened and told them they selected more than 1 column, then open the inputbox again).

Below is my code, but I am getting a Complile error: invalid qualifier error before the code even starts. The error is on the ElseIf line.

Any help? Thanks in advance!

Please Login or Register  to view this content.

I do not get a compile time error, I get a run time error. Not sure why the difference.

But, I think it will work if you replace the problem line with this:

ElseIf FilterRange.Columns.Count > 1 Then

When I added the Dim for FilterRange, I then got the compile time error.

Below shows one way to test for valid selection and loop back.

Please Login or Register  to view this content.

Thank you! I can't believe I missed that!