I am using a scrollbar to move my graph point. Struggling on how to access it in VBA.
'set the scroll
Dim scroll As msForms.ScrollBar
Set scroll = dtdash.ScrollBars(1)
scroll.Max = totRowsd
scroll.Min = 0
scroll.LargeChange = 12
scroll.SmallChange = 1
scroll.Value = totRowsd - 48 'do a lookup here on current date
scroll.LinkedCell = "c3"
That is what I have. dtdash is the worksheet. The linkedcell property is not showing up and I am trying to make it a reference to another sheet.
Expert help is appreciated.