Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List Box (Excel 2000)

    Afternoon All,

    This should be simple for everyone but me.....I would like to make a listbox visible=false when the user makes a certain selection.

    How can I make the property of a listbox (visible) false?

    Thanks
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List Box (Excel 2000)

    Where is this list box? On a userform, or does it sit on a worksheet?

    If it is on a worksheet, how was it created?
    a) In Data | Validation...
    [img]/forums/images/smilies/cool.gif[/img] Using the Forms toolbar.
    c) Using the Control Toolbox toolbar.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Louisville, Kentucky, USA
    Posts
    605
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Box (Excel 2000)

    Using the forms toolbar
    Roberta Price <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: List Box (Excel 2000)

    Forms list boxes are part of the Shapes collection of the workbook. Use something like

    ActiveSheet.Shapes(1).Visible = False

    If you have more than one shape on the worksheet, you may have to replace 1 by another number.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: List Box (Excel 2000)

    In addition to the SAPES object you can use the list box object (change name as apropriate)

    activesheet.listboxes("List box 1").visible = false

    Steve

Posting Permissions

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