Infor bubble on activeX command buttons

I'm rather new to the whole programming and VBA area of excel. I've been playing around with the activeX command buttons and have surprisingly used them in great fashion with my work spreadsheets. But I was wondering is there a way to make a info bubble appear while hovering over a button before it is clicked to allow someone who isn't familiar with my workbook to get a description of what the button does? Thank you in advance for any and all help and suggestions you bring to me.

Hello welcome to the forum

You could have a Message box pop up on the Mouse Move Event for Active X command button, for example:

Please Login or Register  to view this content.

This would have the button caption on the Title bar and your information would be in the 'Information here' string.

DBY

DBY,
Thank you for the response. When I add this code to the sheet it opens up a dialog box before it prompts me to save. I would like to have a description bubble appear on a mouse over prior to a click. Did I just add the code in the wrong spot?

This is the string I'm trying to create.....

Private Sub CommandButton6_Click()
Dim ButtonCap As String
ButtonCap = Me.CommandButton6.Caption

MsgBox "save on desktop", , ButtonCap & " Description"
ChDir "C:\Users\esmcca\Desktop"
ActiveWorkbook.SaveAs Filename:= _
"C:\Users\esmcca\Desktop\UF Tracking by color.xlsm", FileFormat:= _
xlOpenXMLWorkbookMacroEnabled, CreateBackup:=False
End Sub


Also I would like to have this just save and not prompt me to see if I want to overwrite the existing file. I do want to overwrite it because I'm trying to save with a click. Is that a possibility as well?

Hello
The code I uploaded would go into the Mouse Move Event on the Worksheet CommandButton 6. When the mouse is moved over that button the message box appears. If you just want to save the workbook without any questions you can just use:

Please Login or Register  to view this content.

It will just save it to where it loaded from. Is that what you wish to do?

Oh I didn't realize there was different things in the other drop down menu. This is my first time ever using VBA and excel so I'm learning as I go. I did get it to work with the mouse over. But is there a way to just get it to appear and disappear while hovering over the button instead of making it a message box?

Hi
It's all I can think of with Active X controls. Sorry.

Its ok it was a great help thank you.