Tooltip for Excel Sheet Tabst

[villy]

Hello to all...
Just wanna know if anybody can help me. I'm also an excel-vba curious and I am wondering if there are any vba codes or something to show a tooltips in excel's sheet tabs. Just for curiousity, any idea or wise thinking will be greatly appreciated. Thanks
God bless us all.

 

[Trevor G]

Welcome to the forum,

This can't be done through any normal user element being switched on. And I don't know if this can be achieved via VBA.

May I ask why you want to do this?

 

[villy]

Thanks for a quick response. As I mentioned due to curiosity but with deep reason. I created a program in which there are a lot of sheets in a workbook and I want the user of my program to know what is inside of each sheets tab even without opening one of those.

Thanks for responding in my curiosity.

___________________________________________________________
"Diligent hands brings wealth", "Share your blessings and you will be blessed."

 

[Jaafar Tribak]

Thanks for a quick response. As I mentioned due to curiosity but with deep reason. I created a program in which there are a lot of sheets in a workbook and I want the user of my program to know what is inside of each sheets tab even without opening one of those.

Thanks for responding in my curiosity.

___________________________________________________________
"Diligent hands brings wealth", "Share your blessings and you will be blessed."

If you just want some info that describes what is on the tab then how about giving the tabs a descriptive name .

 

[villy]

Thanks that'll be considered... In fact I did but I think its not enough because most of my workbook have same descriptive name that brings confusion in some ways..
Anyway, all I need to know is the posibility that we can have a tooltip or something to describe the sheets names/tabs by just hovering into each.

Thanks for your time anyhow...

_____________________________________________
"Success is when somebody benifits from your wisdom."

 

[villy]

Anybody have an idea about this issue?
Appreciated your efforts thanks.

 

[Jaafar Tribak]

Anybody have an idea about this issue?
Appreciated your efforts thanks.

As much as I would like to I am afraid this can't be done because there is no way to know when the mouse cursor is over the sheet tabs.

 

[JugglerJAF]

Not an ideal solution, but if you're using Excel 2007 or later, you could assign a different colour to each tab and have a worksheet which showed each colour along with a description of what that tab contains/is used for.

 

[villy]

Thank all of you guys I think this is it, I've done already all your suggestions it just so happen that I am looking for something which I think possible to do. I just thought what you can do in VB you can apply directly in Excel-VBA, I was wrong I guess.
Thanks anyway.
God bless
Untill my next curiosity.

 

[Jaafar Tribak]

When you right click to the left of the first tab (where the small navigation arrow buttons are) a popup menu appears listing all the sheets in the workbook.

One thing that may be possible to do is to show a descriptive tooltip as you move the mouse over each item on the popup menu . This is not ideal but much better and practical than tabbing around specially if the workbook contains numerous worksheets.

What excel version do you use ?