How to get a pop-up tip when the user hovers the mouse over a command and option button

I am doing a voluntary project for work to make the scheduling go electronic on Excel. I have several forms, where the user would be able to enter certain information about each shift and it would populate it into a comment in the appropriate cell. Anyways, I would like the user to get helpful tips in the form of a text box when he/she hovers the mouse over a command button, option button, check box, etc. on all the forms I have. I know this is where I need to start:

Please Login or Register  to view this content.

I would like the text box that appears to look something like this:

---

Trade
Allows you to add mandatory comments/information when a change
is being made to a shift due to a trade request by an employee. It
maybe a trade between two or three people.

---

I would like the font to be Arial and font size to be 8. I am completely new to Excel VBA. Someone was helping me out from Yahoo Answers. He did pretty much everything and I followed his pattern of codes to make changes and add additional things. He is now busy with his own work and won't be able to help. So, I hope someone here can help me out. Thanks!

Originally Posted by Winon

@ JosephP,

Yes you are correct, but I found that if it is a long string, it stretches across the sheet in one horizontal line, "miles" long.

What if you create a label and use the caption as a tool tip

the code would then be:

Please Login or Register  to view this content.

Hopefully this is a good workaround. I have also attached a workbook.

JosephP,

I used tried using that feature, but like Winon says below, it appears in one single line and I cannot format it in anyway.

Originally Posted by jleonard5106

What if you create a label and use the caption as a tool tip

the code would then be:

Please Login or Register  to view this content.

Hopefully this is a good workaround. I have also attached a workbook.

Thanks jleonard5106. This doesn't seem to work for me. I changed CmdTrade in your code to optTrade, which is the option button that want to hover over and get the tip, but it doesn't work. Anyways, I was hoping for an effect similar to what happens in Microsoft Word when you hover over the buttons in the ribbon. I don't know how they do it, but maybe I can make create my tip into an image and get it to pop-up. What do you think?

Originally Posted by JosephP

you might add a small help button alongside each control that pops up a second form with relevant information

That is a great idea too! The hover-over effect seems elegant. But, if I can't get it to work, then I'll do a help button like you said that bring up second form with all the tips. I can have one help button for each form I have. Thanks!

Originally Posted by Shanthan

Thanks jleonard5106. This doesn't seem to work for me. I changed CmdTrade in your code to optTrade, which is the option button that want to hover over and get the tip, but it doesn't work. Anyways, I was hoping for an effect similar to what happens in Microsoft Word when you hover over the buttons in the ribbon. I don't know how they do it, but maybe I can make create my tip into an image and get it to pop-up. What do you think?

I think i got it this time.

2 labels and a frame. When the mouse moves over OptTrade the frame becomes visible. When the mouse moves over the userform OptTrade is not visible.

This is as close as I can get. I attached a file hope it helps.

Originally Posted by jleonard5106

I think i got it this time.

2 labels and a frame. When the mouse moves over OptTrade the frame becomes visible. When the mouse moves over the userform OptTrade is not visible.

This is as close as I can get. I attached a file hope it helps.

Wow, that works! Thanks jleonard5106. This is going to be a problem though when I have a lot of things on which I need to show tips. In those situations, I'll use Joseph's idea.

Is there a way delay the apparence of the tip box by about 2 seconds? Once I move away, then it should disappear right away. I don't want the user to be distracted by the tip box if they don't need to see it.

Sorry for the Delay, See attached file.

Changes Made.

• Delay between the frame and labels. Replaced the frame with a new label "LabTrade".

• Created Userform Initialize to set the labels to .visible = false

• Created Timer Sub

• Added Comments.

Originally Posted by jleonard5106

Sorry for the Delay, See attached file.

Changes Made.

• Delay between the frame and labels. Replaced the frame with a new label "LabTrade".

• Created Userform Initialize to set the labels to .visible = false

• Created Timer Sub

• Added Comments.

Thank you, jleonard5106, Winon and JosephP and everyone who helped me with this problem. The final version that jleonard5106 is exactly what I wanted. I'll be using the single help-button idea to bring up another userform as well. Thank you all for your hardwork and input. Keep up the good work! I still have several little things to complete my project. I'll be requesting your help in other threads. lol Thank you again!