Search code examples
excelvbaactivexobject

Is it possible to change background colour and other visual attributes of Slider Control in Excel (via VBA or otherwise)?


I have been trying to change sliders' background color using VBA:

ActiveWorkbook.Worksheets("Dashboard").Slider21.BackColor = "xxxxx"

but have an error saying Object doesn't support this property or method


Solution

  • Sorry cybujan, doesn't look as though the slider control has any colour properties within VBA, although it does have a Background property in the vb.net version, see here and here.

    enter image description here