Search for specific cell based off Row/Column and input data into that cell

Attached is the workbook

• In the left text box, I'd like for my user to be able to input a number that's already in Column A
  • If the number does not exist, an error box to pop up
• In the middle combo box, it's a list of all the columns available
• In the right text box, I'd like this text to be entered into whatever cell that the first 2 pieces of information intersect at.

I've already built the user form that allows my users to implement data into the worksheet, but I would like this information to be a way for them to easily change out information without having to search through the entire database manually.

Any help is greatly appreciated!!! Thank you!Sample Workbook - Search Field XY Value.xlsm

I've been playing with the code and I'm completely lost. When I input information into all 3 boxes (horizontally), the text in the 3rd box disappears and nothing is inputted into the spreadsheet.

Can anybody help explain as to why?

Thanks!

That worked exactly how I wanted it to!


...in your workbook, but it's not working when I transfer the code into my workbook and attempt to do the same. I've attached my workbook for review.

Thank you so much in advance.

RT Sample.xlsm

bump - anybody else know what may not be working in this code? Thank you!