Hi,
I am extremely new to this. I have reasonable excel skills. I need to create a text box which appears when you hover over a cell.
I would like this text box to contain text contents from another cell on a different worksheet.
Is this possible with VBA?
Thanks.
Hi -
Welcome to the forum.
Why not use the excel comment instead?
event
Not sure if "hovering" is possible to implement, but if clicking (selecting) the cell is fine, it's possible. This uses data validation input message.
If put behind a worksheet's code, selecting a cell in Column D will display value of cell H3 as data validation input message.
Please Login or Register to view this content.
多么想要告诉你 我好喜欢你
Hi,
Thanks for such quick responses.
Can comments in excel be set to display the contents of a cell? I wasn't sure if it could be done?
I am trying to show the numbers of low/medium/high change as a number but when you click or hover on cell it returns further detail of change name which I have calculated on another worksheet?
Wow, thanks Millz.
This works, but I now need to see if I can get it to select a specific cell (B7) and this will display value of cell in a different worksheet 'JanChangeNames!B2' as data validation input message?
Can this be done or does the cell have to be in the same sheet?
Thank you,
Nic.
You can try:
Please Login or Register to view this content.
I am getting a runtime error (9). Subscript out of range.
It highlights:
.InputMessage = Sheets("JanChangeNames").Range("B2").Value
I have attched the spreadsheet to see if that helps, sorry I am really struggling with this, really new to VBA and find it so confusing.
It is basically cell B7 in the sheet called Change Calendar that I want to have the input message and sheet called Jan Change Names cell B2 to be the details it returns.
View of Change Spreadsheet 14 v2.xlsm
Ok so there were 2 problems. Sheet name was wrong, it should be 'Jan Change Names'. There were no spaces in the code because that's what you shown to me in post #5
The next problem is, the cell B2 in Jan Change Names was result of a longgg concatenation. And in your formula it has many spaces included as well (in the concatenation). Data validation input message has a maximum length limit of 254 characters. If your cell B2 ends up being longer than 254 characters, this will give you an error.
We can, however, avoid the error by first trimming the cell value (this removes redundant spaces), and then take the first 254 characters only.
You can also change it to this if you want it to be displayed as the first 251 characters and followed by "..." if it is longer than 254 charactersPlease Login or Register to view this content.
Please Login or Register to view this content.
You are amazing!
Thank you so much this has really helped me.
Loving the Excel Forum.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks