I am using Microsoft Excel 2003 wherein i have a cell which has a comment. The comment has text as well as URL. Is it possible to create a hyperlink (URL) in comment box where user can click and it automatically opens the URL ?
James, If it were me, I would keep this as simple as possible. I'd just have a brightly colored box somewhere out of the way with these guidelines and the link.
If you're interested though, here are steps you can follow to insert the VBA to create a pop-up rectangle text box next to the currently selected cell with whatever text you want it to say:
Now whenever you click in a cell in the range you entered into the code, the rectangle you created should appear to the right of that cell. Play with the
No, you can't create a hyperlink in a comment. You can only insert the URL text.
Hyperlinks is a property of a Range or Worksheet (which comments aren't). There's also a Hyperlink property for a Shape, but that wouldn't apply here (though there might be some really tricky way you could have an image cover the commment and provide the hyperlink).
I don't think Excel supports hyperlinks in comments. VBA will likely not help you there.
Could you not put URLs on a column next to your cells instead?
If you're strongly determined to have some sort of tooltip link, you could probably program a tooltip behavior from scratch in VBA (create little yellow form, place it next to cell, hide it when user clicks on another cell, etc..) but that would work separately from the real comments, and probably a few things wouldn't integrate very well, and probably not a very good idea anyway.