Programmatically format VBA buttons

**Admin** · 09-21-2012, 01:40 PM

Hi,

Yes your assumption is right. You could also try this way as well

Code:

If .Controls(i).Name Like "abc*" Then 'begins with abc,"*abc" > ends with abc, "*abc*" contains abc
'//or use like
'If .Controls(i).Name = "abc" Then
    .Controls(i).BackColor = RGB(0, 64, 0)
End If

**Belleye** · 09-21-2012, 02:03 PM

Sorted thanks very much +1

**Rick Rothstein** · 09-21-2012, 02:22 PM

Originally Posted by Belleye

Sorted thanks very much +1

Based on who the Threaded View of this forum shows you responded to, I think our messages may have crossed... I think you will want to read the message I posted (Message #5) as I believe it does what you might have been originally looking for.