ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing Form Button Background Color (https://www.excelbanter.com/excel-programming/310637-changing-form-button-background-color.html)

wrkoch[_7_]

Changing Form Button Background Color
 

I've tried but I can't seem to figure this out.

I have a worksheet(1) in a workbook. On that worksheet I created
button using the forms tool and associated it with a macro. It is th
only control on the sheet and in the workbook. All is fine except...

The button background color is grey and the lettering is black. Har
to read. What I want to do is changed the button color. I thought
could get at it with the shapes object but I can't figure out th
syntax.

Any help would be appreciated

--
wrkoc
-----------------------------------------------------------------------
wrkoch's Profile: http://www.excelforum.com/member.php...fo&userid=1006
View this thread: http://www.excelforum.com/showthread.php?threadid=26180


PCLIVE

Changing Form Button Background Color
 
If you just want to change the background color, right-click on the button
and select 'Properties'. Choose the color on the 'BackColor' field.

HTH
Paul

"wrkoch" wrote in message
...

I've tried but I can't seem to figure this out.

I have a worksheet(1) in a workbook. On that worksheet I created a
button using the forms tool and associated it with a macro. It is the
only control on the sheet and in the workbook. All is fine except...

The button background color is grey and the lettering is black. Hard
to read. What I want to do is changed the button color. I thought I
could get at it with the shapes object but I can't figure out the
syntax.

Any help would be appreciated!


--
wrkoch
------------------------------------------------------------------------
wrkoch's Profile:

http://www.excelforum.com/member.php...o&userid=10064
View this thread: http://www.excelforum.com/showthread...hreadid=261806





All times are GMT +1. The time now is 12:00 AM.

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