#1
|
|||
|
|||
VBA: How to change color of a CommandButton
Hi there,
I want to change the command-button color from red to green using VBA I defined a variable as a shape and used this code myShape.Fill.ForeColor.RGB = RGB(0,255, 0) Well, it does not work, no changes so far. Any Idea, what I did wrong? Regards Bruno |
#2
|
|||
|
|||
Command Buttons are not Shapes and in this case you need to change the backcolor
Sub changeme() Dim octrl As Object 'change slide number and name to suit Set octrl = ActivePresentation.Slides(1).Shapes("CommandButton 1").OLEFormat.Object octrl.BackColor = &HFF End Sub If you explain exactly what you are trying achieve there may be a better method |
#3
|
|||
|
|||
This is, what I want to achieve
Hello there,
Thanks for your advise, I want to have something like the radio buttons. 5 in a row If I click on one of them, the color should change. The problem with radio buttons is the layout: I can not use them, because the mark is not in the center of a square. Regards Bruno |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CommandButton, 3 PCs with 3 different office(s) | CYFire | Excel Programming | 1 | 12-13-2015 05:31 AM |
CommandButton random statu | cromano | Word VBA | 7 | 06-13-2014 07:40 AM |
Email Document via Commandbutton | aqhibjaveed | Word VBA | 1 | 03-25-2013 11:22 PM |
change One highlight Color to Another | Redbarn | Word VBA | 1 | 03-16-2013 02:03 PM |
color change for same shape | ajkiran | PowerPoint | 1 | 11-10-2012 07:41 AM |