Connecting a text box on sheet one to multiple different descriptions on another sheet

[HelpINeedSomebodysHelp]

Hi there. I am at an intermediate level with excel and a beginner with VBA. This is also my first time posting to a forum, ever.

I have been having some trouble with completing a specific task for a project at work. I am attempting to link multiple cells I have in sheet 1 to multiple cells with text in sheet two. I would like to have a text box in sheet 1 display the information in sheet 2. can you please help me? I would like for the user who sees the sheet to be able to click on one of the cells with a data set in it and for a message box in sheet 1 to display the correlating text information relating to that data from sheet two.

I have searched for tips on this task for almost a week now and I am still in the dark. any help that can be provided would be very much appreciated.

Thank you in advance.

 

[Rick Rothstein]

Sorry, I am used to using the terms interchangeably. I will try to keep in mind to only say text box.

The reason for the confusion "My Aswer Is This" is having is because VBA has a TextBox object (what you are asking for) and a MessageBox object (which is used to display text to the user) which is evoked through the MsgBox keyword command. So, to a programmer, these are not interchangeable objects.

Image links:

I don't know if the above pictures are displaying in this forum on your computer, but they are not displaying on anyone else's... this forum cannot reach into your computer or your network and display a file from it, so all we see is text for their file location on your computer system.

So just to be clear you are saying that I will have to write a VBA code that looks like the following?

Code:
If Sheets(1).Range("A1").value="Paul" Then TextBox1.value=Sheets(2).Range("B14").value

am i correct?

Not necessarily, but we cannot know without have specific detailed descriptions of the cells involved and how each of them are related to one another. Let me leave you with the following generic advice that I post from time to time...

Please Note
-------------------
One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data, its layout and the overall objective for it).

 

[HelpINeedSomebodysHelp]

Hi Rick,

I understand, and I am not trying to dd extra confusion here I am just a first-time poster trying my best to explain. I cant get either MrExcelhtml Or Excel Jeanie htmel to work for me for some reason.

I have posted a dropbox link that should take you to an open folder with both images inside. This should help with the communication brake down. I appreciate the patient help and advice.

https://www.dropbox.com/s/i4e70xm0ydj3ksh/sheet 1.PNG?dl=0

https://www.dropbox.com/s/l5t378u1a14d0p9/sheet 2.PNG?dl=0