Spin Button Programming

  • Thread starter Thread starter Squeaky
  • Start date Start date
S

Squeaky

Hi All,

Using Excel 2007. Is is possible to change the linked cell of a spin button
(Active X) using VBA?

Thanks,

Squeaky
 
Hi,

ActiveSheet.OLEObjects("SpinButton1").LinkedCell = "f12"


--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top