Linked Dynamic Text Box to Column next to Active Cell

[brandonjkgrant]

Hi everyone,

Hope to receive feedback on what I'm trying to accomplish. I'm making an Excel sheet in which project managers have to input a bunch of varying data/information. The data input is all in Column A. The data can be anything from long text, dates, addresses, dollar amounts, and custom text. Column B is meant for user instructions on what to enter in Column A.

For example:
A1 = blank (user input) and B1 = "Input the date of the approved project plans"
A2 = blank (user input) and B2 = "Enter the total project estimate"
A3 = blank (user input) and B3 = "Project manager first and last name"

I know I can easily display instructions/comments using the Notes function, but I would like to dynamically display the different instructions from Column B in a floating text box as the user selects the data entry cells in Column A. Also, Column B would be hidden to make the final spreadsheet look clean and simple.

So if the user selects cell A1 to begin inputting data, the text box would display the instructions in B1 (in this case: "Input the date of the approved project plans").

I've tried the following and a bunch of other codes just to see if I can display the selected/active cell values in the text box, but had no luck. Thought I could start off with the active cell and then build up to somehow make it reference the next column over but I can't even get this to work.

Please Login or Register  to view this content.

Sorry to be a bother if this or something similar has already been brought up. Any help would be greatly appreciated! Thanks!

[SjonR]

This adds a comment when selecting the cell an removes it when you exit it.

Please Login or Register  to view this content.

[brandonjkgrant]

Thank you SjonR! I really like this and will definitely try to use it for future Excel projects. For this project, I would really like the comments to display in a single text box.

Update: I've tried updating the code from my original post but still no luck. I will continue to work on it when I have the time and hopefully post a solution once I find it!

[SjonR]

ok, thanks for the feedback.

Try this with a textbox:

Please Login or Register  to view this content.

[brandonjkgrant]

Thank you so much SjonR! I was finally able to get it to work. Also, I tinkered around with a different, much more simple option to display the instructions in cell rather than a textbox:

Please Login or Register  to view this content.

Thank you again!