PDA

View Full Version : Solved: Is there any tooltiptext in excel?



maryam
05-04-2007, 08:58 PM
In VB there is a property called tooltiptex to define a yellow mark for the controls. Is there something like that when we work in VBA in Excel?

lucas
05-04-2007, 09:20 PM
It's called controltiptext
add a label to a userform for example and select the label then look at the project properties for controltiptext....

maryam
05-04-2007, 09:25 PM
thank you lucas.

maryam
05-04-2007, 09:35 PM
but for the controls we put on the worksheet (for example command bottun) this property is not in the property lists.

lucas
05-04-2007, 10:15 PM
That appears to be true maryam.....sorry...you really should try to find a different way to run your macros than an ugly button on the sheet though. I never use a button on the sheet...it's too easy to set up a simple menu item...doesn't take any space on the page, it's not ugly, etc.

Aussiebear
05-04-2007, 10:19 PM
Steve, does this mean that the menu item only appears for that workbook or is then on every workbook opened?

lucas
05-04-2007, 10:22 PM
I like to set them up for each workbook individually....they travel with the workbook that way. All others I use are created from an addin.....

attached and custom menu's are a pain and have caused me problems.

Edit: Should mention that they are created on workbook open and deleted on workbook close...so they don't show in any other workbook...only the one you want it in.

Aussiebear
05-04-2007, 11:56 PM
Could you give us an example?

maryam
05-05-2007, 01:08 AM
Dear Lucas,
What is this menu item? you mean instead of putting buttons on a worksheet you creat menu item?

Aussiebear
05-05-2007, 02:08 AM
Hi Maryam,
I notice the thread is marked solved but you ended with a question??

asingh
05-05-2007, 06:01 AM
Hi,

Sorry to type on a solved thread....could someone show..how to create a menu button..and have the coder fire from there....I also want to stop..placing command buttons on the XLS grid.

thanks
asingh

lucas
05-05-2007, 09:00 AM
This is what I use....
http://j-walk.com/ss/excel/tips/tip53.htm

couple of other links
http://vbaexpress.com/kb/getarticle.php?kb_id=427
http://www.vbaexpress.com/forum/showthread.php?t=50&highlight=menu

for a simple floating toolbar:
http://vbaexpress.com/kb/getarticle.php?kb_id=921

maryam
05-06-2007, 06:53 PM
I dont know how to make a thread unsolved again?
but any way the initiating question is solved.
for menu maker you may look at another thread I posted previousely titled "menu editor".
so you mean better to have a menu than seprate command buttons on the worksheet?

asingh
05-06-2007, 09:16 PM
Is there not some simpler method to add a menu button to the top tool bar..in excel. Like how a command button is added to the application..drag and drop..and then bind the back end code....to it. Does it have to be done..via code...!

Aussiebear
05-06-2007, 10:03 PM
I think I read it somewhere that on John Walkenbach's website there is a methodology showing how to add a button to the toolbar.


Sorry not there but try here instead http://office.microsoft.com/en-us/excel/HP051922011033.aspx