+ Reply to Thread
Results 1 to 2 of 2

displaying a spreadsheet in a userform using spreadsheet control

  1. #1
    Registered User
    Join Date
    04-25-2012
    Location
    portsmouth,england
    MS-Off Ver
    Excel 2007
    Posts
    21

    displaying a spreadsheet in a userform using spreadsheet control

    Hello all,

    i want to make a table in a userform that takes the values from a range of cells and researching i found that you could show the spreadsheet in the userform by something called the spreadsheet control, can someone tell me what this is and how to use it?

    Thanks in advance,
    uduyt

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: displaying a spreadsheet in a userform using spreadsheet control

    the office web components aren't part of office 2007+. the last version was for office 2003. it will still work in 2007 but you need to download it and make sure all your users have the same version. 'how to use it' is a bit too vague. ;-)
    you might be able to use a listbox instead which would be simpler.
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ Reply to Thread

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