Is there a way to make buttons that are not so boring? Im looking for a way to make a button like a flash button. Perhaps one with a gradiant fill. Thanks
Is there a way to make buttons that are not so boring? Im looking for a way to make a button like a flash button. Perhaps one with a gradiant fill. Thanks
Use a gradient image > copy > paste as image into the controls picture property.
Kind Regards,
Ivan F Moala From the City of Sails
Not sure i follow you. do you have an example?
Austen,
With any ActiveX commandbutton, it has a "Picture" property. Find an image that you want on your button, go to the properties and hit the ... that appears when you click in the field. You then browse to your image and say OK.
Ken Puls, CMA - Microsoft MVP (Excel)
I hate it when my computer does what I tell it to, and not what I want it to.
Learn how to use our KB tags! -||- Ken's Excel Website -||- Ken's Excel Forums -||- My Blog -||- Excel Training Calendar
This is a shameless plug for my new book "RibbonX - Customizing the Office 2007 Ribbon". Find out more about it here!
Help keep VBAX clean! Use the 'Thread Tools' menu to mark your own threads solved!
Hi Austen,
Never thought about this before, but why not?
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
You could use an image with a shadow if you really wanted to.
Trouble with unusal controls is user may not realize they should be clicking them.
Cheers
Andy
Thanks guys. Those give me some ideas. Will post back with any more. For now I shall mark this post solved.
is that a dead bunny?
Office 2010, Windows 7
goal: to learn the most efficient way
Hi Trippy,
If I were you, I'd be more worried about Kelly, I'm sure she's strangling a penguin!
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
thank you i was also looking for this