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?
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?
It's called controltiptext
add a label to a userform for example and select the label then look at the project properties for controltiptext....
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
thank you lucas.
but for the controls we put on the worksheet (for example command bottun) this property is not in the property lists.
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Steve, does this mean that the menu item only appears for that workbook or is then on every workbook opened?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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.
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
Could you give us an example?
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Dear Lucas,
What is this menu item? you mean instead of putting buttons on a worksheet you creat menu item?
Hi Maryam,
I notice the thread is marked solved but you ended with a question??
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
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
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/show...highlight=menu
for a simple floating toolbar:
http://vbaexpress.com/kb/getarticle.php?kb_id=921
Steve
"Nearly all men can stand adversity, but if you want to test a man's character, give him power."
-Abraham Lincoln
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?
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...!
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/ex...922011033.aspx
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link