Showing Roll-Over/Hover Text As Display Text

IF you are happy with the code, only one line of code needs to be added for that. See the line after Rem. DoubleClick Userform1 and then the Change links button and replace that Sub with this or just add that one line.

Please Login or Register  to view this content.

Glad you figured it out. I purposely let you have time to do so.

Beauty is in the eye of the beholder. If it suits your needs, you are good to go. It did some things that I would not want. e.g. It closed the file. It did not update all the cells in a selected range. Why someone would want that with the same short name, I don't know. e.g. Ken

I would have thought that your original request to add a base part of the url to be more useful though even that might have several duplicate short names.
e.g.
http://www.excelforum.com/excel-programming/ as excelforum
http://www.vbaexpress.com/forum/forumdisplay.php?f=17 as vbaexpress
http://www.mrexcel.com/forum/forumdisplay.php?f=10 as mrexcel
etc.

Yeah the line you provided does exactly what I asked for, it's great.

But what do you mean when you say that the add-in closed the file or didn't update some of the cells inside a range?

You mean you found some bugs in there or something?

If it meets your need, then there are no bugs. If you find an issue that you need dealt with, you can always ask for help.

Well actually there's one thing that's kinda annoying, maybe this is also what you meant by "it closes the file"....

If you look into the add-in's components there's a part named "KeepFormOnTop" which is something I needed in the first time around that this add-in got developed.

I needed it because I wanted it to stay open and on top of all and any Excel workbooks/worksheets that would subsequently be opened this way I could re-apply the same display texts over and over without having to close and open the add-in for each new worksheet/workbook.

Issue is it seems that when you open the add-in from a specific worksheet/workbook it will only work on that specific worksheet/workbook unless otherwise re-opened on another worksheet/workbook where editing new display texts is wanted.

So in short, basically if you are using the add-in on a current worksheet/workbook and you then open up another new workbook/worksheet where you want to apply the already same inputted display texts, you have to re-open the add-in on that newly opened worksheet/workbook.

Do you know if there's a way to have the add-in stay on top like it was intended to be, but also be automatically applicable/working for all and any workbook/worksheet regardless of the original workbook/worksheet it was opened on at first?

This was something I was meaning to open another thread for but you brought it up earlier than expected on here, so I take it, why not ask and get rid of this issue now right?

Thanks again,
Eric

I got an error each time that I opened Excel so I commented out two lines. I did not want the userform showing when I opened Excel anyway.

Please Login or Register  to view this content.

Hi Kenneth,

Yes I actually get the same error as well but a simple way I solved this was by adding a shortcut to the add-in on my Quick Access Toolbar (so that I can easily bring up it by simply clicking it whenever needed) and then went in my add-ins menu and simple unchecked it from the current active add-ins.

Now it doesn't show the error at all, and I can simply bring up the add-in by clicking this Quick Access Toolbar shortcut I have setup.

Regarding my previous post, any idea as to how we can fix this issue where the add-in only works with the worksheet/workbook it was opened on originally unless it is re-popped up on a new worksheet/workbook?

Making it work by default on all sheets without having to re-pop it on for each new worksheet/workbook would save a lot of time and really is the best option.

Please let me know.

Thanks again,
Eric

I don't know what you mean. Just close it with the X, not the Stop button unless you reply No when you press it rather than Yes to close it.

Hi Kenneth,

I'll try to be as detailed as possible this way you can exactly see what I'm trying to say....

First open up some random Excel workbooks (I'd recommend opening 3 workbooks this way you can see exactly what I mean) and then on any of the selected workbooks open up the add-in.

Then just click on the blank box (the one where you're supposed to paste in the display texts).

Alright, with that done now go to any other of the 2 opened workbooks, what you'll see is that the add-in User Box actually stays on top, however as soon as you click on it it brings you back to the same first workbook where the add-in was originally opened.

The problem with this is that for the majority of the time I'd want to use the same display texts I used on a previous spreadsheet, however with this slight "bug" if you want to call it this way, I have to re-pop the box on each different workbook I want to use the add-in on, this becomes quite annoying and time-draining with the number of sheets I'd have to do this with.

So do you think there's any way to have the add-in function like it is right now, staying on top, but also work with any workbook regardless of which workbook it was first opened on?

If anything wasn't clear please let me know, I'll try to add more details if you think this is something we can fix.

Thanks again,
Eric

I don't see why you would want it to run like that. I would not have a need to run something like that every time that I open Excel.

Are you wanting all links in all workbooks and all worksheets and all selections changed? What I would do is to use it in my personal workbook. If you want to modify several worksheets in all open workbooks with selections in each then the macro could be modified to do that. I would change the Close button to just close the userform, not the addin workbook.

So, if used often enough, I would put it in my personal workbook. If not used often, I would just add a personal workbook macro to open that workbook. This could be assigned to your key combination and be seamless.

Actually it was pretty easy solving this issue where the add-in would pop-up every time Excel is opened, as I wouldn't want it to open up each time either.

What I did is I simply disabled it in my add-ins and put a shortcut to it on my QAT, which I can simply click whenever I need to use the add-in, so that's no issue.

What I was saying in my previous post is the add-in is meant to stay on top of workbooks/worksheets due to the "KeepFormOnTop" module which I actually need to speed-up tasks and not have to re-open the add-in for each workbooks/worksheets I want to use it on.

But what happens is it seems the add-in actually stays on top of workbooks/worksheets, even on newly opened ones, but as I detailed it in my previous post, only works on the original workbook/worksheet it was opened on which would mean it must be re-opened on each new individual workbook/worksheet for it to work on it.

So do you know of any way where we could have the add-in working on any workbook/worksheet regardless of where/when it was opened?

Try out what I detailed in my previous post and you'll see what I mean (and like I said, I simply added a shortcut to the add-in, then disabled it so it wouldn't automatically open with Excel each time, now I can simply open it whenever needed from my QAT).

Also you said in one of your previous posts that sometimes the add-in doesn't edit all links, I have seen this happen a number of times, not sure what causes this, could this be fixed too?

Thanks a lot Kenneth, let me know if you need more details or have any questions, I hope we can solve these little issues and get them over with.

Thanks again,
Eric

Bump -- Any ideas if these are things that could be arranged?

Thanks,
Eric

Did you want it to work on the selection of each workbook or just the selection in the activeworkbook?

Hi Kenneth,

Any updates on this?

Thanks,
Eric

This still has an issue. If you select A1:A3 and put Z1, Z2, and Z3 with return codes after each in the Textbox, it does A1 right but puts Z3 into A2 and skips A3.

Please Login or Register  to view this content.

Hi Kenneth,

Thanks a lot for this new code.

Just wondering, what do you mean by "this still has issues"? And what's a return code?

I tested out the code from my side and seems to be working great, haven't encountered any issue.....but I'd like to know what you're talking about this way I don't bump into any issues while I'm working with the add-in and start wasting a lot of time trying to fix any mistakes I might've made using it etc.

Let me know, thanks.
Eric

The way that it should work as I see it is that you might select say cells A1, A2, and A3 all with hyperlinks. Type into the textbox say:
Ken1
Ken2
Ken3

When you replace, with the button2, you will see that Ken1 was put into A1, and Ken3 into A2. A3 was not changed.

I will think on this more.

I actually just tried that, and also tried with many more hyperlinks of my own and I see it working well, not sure if this is from your end maybe?

Also I edited the ScreenTip code to look like that (so as to match with the new code you provided)...

Please Login or Register  to view this content.

Would that be correct?

Anyways let me know if you think there actually is a fix to this issue you're saying doesn't edit the links.

Thanks again,
Eric

Good. I was using Excel 2010 in xppro. I just copied one link to 3 cells to test. If it works for you then you are set.

Alright great well thanks a lot for all the helpful input Kenneth, it's definitely appreciated