ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   form button question (https://www.excelbanter.com/excel-programming/352426-form-button-question.html)

dorre

form button question
 
Bon jour

can form buttons be colored? made visible/not visible, etc. I can't find
where these properties are.

Thanks Dorre




tr00per

form button question
 
Dorre,

Are you talking about a CommandButton? If so....Yes, CommandButtons
have properties: BackColor, Visible, etc. Read about the properties of
CommandButtons in Microsoft Visual Basic Help under: CommandButton
Control.


avveerkar[_34_]

form button question
 

One suggestion is to import gif or tiff image on your sheet and assign
macro to it so that it can be used as button. There are many free we
sites where you can get beautiful buttons to import. Eg o
http://www.coolarchive.com/buttonmaker.php you can design your ow
buttons and then import them on your sheet. You will have very elegan
looking worksheet. Try it. It is really cool with excellent colors
caption fonts etc.

If you want button on a tool bar then you can use EXCEL's own Butto
Editor which offers you a 16x16 grid to paint your own button. ( Righ
click anywhere on a tool bar select customise, select command tab o
"customise menu", select macros category, drag custom button ( yello
smilee) on any tool bar, right click on this button ( with customis
menu still open - dont close it ) and select edit button image.
A V Veerka

--
avveerka
-----------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033
View this thread: http://www.excelforum.com/showthread.php?threadid=50862


dorre

form button question
 
no, i'm talking about buttons from the forms toolbar.

"tr00per" wrote in message
oups.com...
Dorre,

Are you talking about a CommandButton? If so....Yes, CommandButtons
have properties: BackColor, Visible, etc. Read about the properties of
CommandButtons in Microsoft Visual Basic Help under: CommandButton
Control.




Tom Ogilvy

form button question
 
You can change the font color, but I believe the color of the button is
controlled by the windows settings.

--
Regards,
Tom Ogilvy


"dorre" wrote in message
...
no, i'm talking about buttons from the forms toolbar.

"tr00per" wrote in message
oups.com...
Dorre,

Are you talking about a CommandButton? If so....Yes, CommandButtons
have properties: BackColor, Visible, etc. Read about the properties of
CommandButtons in Microsoft Visual Basic Help under: CommandButton
Control.







All times are GMT +1. The time now is 08:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com