XLOOKUP Built by VBA InputBox

[alsports]

Cross-posted at https://www.mrexcel.com/board/thread...utbox.1206644/

I am trying to make a macro that will create an XLOOKUP for me. This is my first post so if I do something wrong let me know. This is my code and it's not working. Can anyone see why?

Please Login or Register  to view this content.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so.

Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

I have added it to your post because it's your first thread.

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

Please explain what "not working" means.

• Does the code run?
• Does it run but do nothing?
• Does it produce error messages? If so, what do the messages say?
• Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
• Does it hang?

[6StringJazzer]

Try this.

Please Login or Register  to view this content.

You may also want to consider using Type 8 in your second and third InputBoxes so the user can highlight a range directly in the sheet instead of typing in a range. You have no error checking so this will crash and burn if the user does not type a valid range.