+ Reply to Thread
Results 1 to 3 of 3

Fill a listbox from a non active sheet with option button

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Fill a listbox from a non active sheet with option button

    Hi
    I have an option button and a listbox, i am trying to fill the listbox when clicking on the option button, i can get it to work just fine if i have the sheet where the data is as the active sheet but when i hide the sheet it does not work. Any help would be appreciated.

    thanks

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

    Re: Fill a listbox from a non active sheet with option button

    maybe
    Please Login or Register  to view this content.
    probably need more information about how you fill the listbox now ;-)
    Josie

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

  3. #3
    Registered User
    Join Date
    10-14-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    82

    Re: Fill a listbox from a non active sheet with option button

    Thanks works a treat.

+ 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. VBA code: appear items of option button to a listbox
    By hydz1213 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-17-2013, 08:02 AM
  2. Option button value to active cell ?
    By dannac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-04-2012, 08:40 PM
  3. [SOLVED] Active X ListBox Fill Range
    By zplugger in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2012, 12:12 PM
  4. Option button (active control) code to perform a calculation
    By Taggsuk in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-18-2008, 07:00 PM
  5. auto-fill option button
    By Norman in forum Excel General
    Replies: 1
    Last Post: 01-24-2006, 05:25 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