VBA - Import text from cell value and display in text box on cell mouse click

Hi Guys,

Please could you help with this problem im having,

On cell click on sheet 1 I want the cell contents of a cell in sheet 2 to be imported into a text box and displayed on sheet 1 in a specific location.

E.g.
1) User clicks A1 on sheet 1
2) In empty field next to cell A1 the cell data from sheet 2 cell B1 is imported into a text box and displayed in sheet 1

Any help will be much appreciated

I am using the following code to assign macros to the cell:

Please Login or Register  to view this content.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here