Hi ,
I have a List Box, defined with the Forms ToolBar Menu.
I would like to change the background color with this:
ActiveSheet.Shapes("List Box 85").Select
With Selection
.ListFillRange = "$J$12:$T$20"
.LinkedCell = "$T$11"
.MultiSelect = xlNone
.Display3DShading = True
.BackColor= RGB(0, 0, 255) these two lines doesn't work!!
.BackColor = 45
End With
End Sub
But all I get is
Run time error 438
Object doesn't support this property
Any help will be appreciated, thanks
Jose Luis
Bookmarks