+ Reply to Thread
Results 1 to 5 of 5

List box and combo box

  1. #1
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Post List box and combo box

    Hi Friends

    i want to know which one is the best one list box ? or combo box ?
    I am currently writing a code on vb for a excel sheet.
    This list box has some 100 values from which the user can select
    how to write the code to insert this 100 values for a list / combo box

    Many thanx in advance

    Chakz.

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: List box and combo box

    Depends on the function you're looking for.

    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    or
    Please Login or Register  to view this content.
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: List box and combo box

    IF i have this listbox or combo box on a excel sheet and values are added into it through the vba code.

    How can i stop the user from moving or dragging the listbox to where he /she wants. i dont want the user
    to have accesss to its properties or right click in the design mode more importantly he should not change the place
    of the either of these list box /combo box. What code should we use

    many thanx in advance

  4. #4
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: List box and combo box

    You'll have to protect the sheet.

  5. #5
    Forum Contributor
    Join Date
    02-12-2011
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    261

    Re: List box and combo box

    Many many thanx

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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