putting spinbuttons in a worksheet

[Justme47]

Hi,

The code below places a spinbutton on the worksheet. The linked cell = F10
This works ok.
The orientation is vertical and max is 100
However I would like to set the orientation to horizontal and the max value to 1500.

Which commands must be added for this in the macro below?
I work with Excel2000.

Your help will be appreciated.

Please Login or Register  to view this content.

[royUK]

Welcome to the Forum. Please read the Forum Rules & use Cod Tags in future

[Justme47]

Ok, I will use Cod Tags

[Leith Ross]

Hello Justme47,

The OLE Object has 2 parts. The OLE container and the object that the container holds. The container portion basically specifies the placement, size, and few other properties like Enabled, Locked, and PrintObject. To access the objects properties and methods, we have to use the Object property of the OLE Object, like this...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[Justme47]

dear Leith, this was what I was looking for!
Thank you for your support.

Gerhard