+ Reply to Thread
Results 1 to 2 of 2

List box Help

  1. #1
    Registered User
    Join Date
    11-14-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2003
    Posts
    55

    List box Help

    Question 1: On the DATA VALIDATION list box is there any way I can start to type in the text and the list will jump to that section.

    for example:-

    A32 - Management of the Works
    A33 - Quality standards/control
    A34 - Security/Safety/Protection
    A36 - Facilities/Temporary works/services
    E30 - Reinforcement for in situ concrete
    E31 - Post tensioned reinforcement for in situ concrete
    E40 - Designed joints in in situ concrete
    K10 - Plasterboard dry lining/partitions/ceilings
    K11 - Rigid sht. flooring/sheathing/deck/sark/lining/casing
    K12 - Under purlin/inside rail panel linings

    So if I type in "K" it will jump down to show the "K" entries.

    Question 2:
    Can I determine the size of the list box drop down window?

    Thanks in anticipation.
    Last edited by Bravo33; 07-06-2013 at 05:26 AM. Reason: Expand description

  2. #2
    Valued Forum Contributor
    Join Date
    03-29-2013
    Location
    United Kingdom
    MS-Off Ver
    Office/Excel 2013
    Posts
    1,749

    Re: List box Help

    If you use ActiveX controls (Combobox) they do that automatically
    Elegant Simplicity............. Not Always

+ 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