Results 1 to 5 of 5

putting spinbuttons in a worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2008
    Location
    The Netherlands
    Posts
    21

    putting spinbuttons in a worksheet

    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.

    Sub kringveld()
      With ActiveWorkbook.Sheets(1).OLEObjects.Add("Forms.SpinButton.1", , , , , , , 160, 60, 10, 20)
        .LinkedCell = "F10"
      End With
    End Sub
    Last edited by VBA Noob; 11-14-2008 at 05:41 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1