+ Reply to Thread
Results 1 to 5 of 5

Spreadsheet Control Not Available

  1. #1
    Registered User
    Join Date
    04-05-2016
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    40

    Spreadsheet Control Not Available

    Hello,

    I am attempting to add a Spreadsheet control into my userform - I know that I am to right click on the toolbox, click additional controls, and that I should find Microsoft Spreadsheet control there (or something to that effect), but I do not see anything relating to a spreadsheet control.

    Is this option not available anymore? If so, is there a replacement option to show spreadsheet data embedded in a userform? I am using Excel 2016

    Best regards!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482

    Re: Spreadsheet Control Not Available

    What kind of control?

  3. #3
    Registered User
    Join Date
    04-05-2016
    Location
    Philadelphia, Pennsylvania
    MS-Off Ver
    Microsoft Office Professional Plus 2013
    Posts
    40

    Re: Spreadsheet Control Not Available

    It is my understanding that there should be a "Microsoft Worksheet Control" or "Microsoft Spreadsheet Control" available in the more controls options - or at least there used to be. Looking to show spreadsheet information within a userform.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: Spreadsheet Control Not Available

    It's no longer available, and no, I don't think there's a replacement - not widely available anyway

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,917

    Re: Spreadsheet Control Not Available

    Unless you have 64bit Office, you should be able to download the Office Web Components library and it should still work, though of course anyone using your workbook will also need to have it available.
    Rory

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use a Spreadsheet control in userform
    By kryt0n in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-12-2014, 05:51 AM
  2. displaying a spreadsheet in a userform using spreadsheet control
    By uduyt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2012, 08:09 AM
  3. add a Spreadsheet control through VBA
    By gs4366 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2011, 10:25 AM
  4. Spreadsheet control
    By gtmeloney in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-16-2009, 08:37 PM
  5. [SOLVED] Spreadsheet Control (import from spreadsheet)
    By mpeplow in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-16-2007, 06:42 AM
  6. [SOLVED] Odd spreadsheet control
    By 39N 95W in forum Excel General
    Replies: 1
    Last Post: 06-13-2006, 01:50 PM
  7. Microsoft Spreadsheet Control?
    By TCook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-22-2005, 09:00 AM
  8. [SOLVED] Spreadsheet 9.0 Control
    By mohsen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-06-2005, 12:05 PM

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