Drop Down Lists - navigation

Originally Posted by Burnsy

Hello Excel Gurus,

I have made a very lengthy drop down list in an excel form as I need to restrict the user from entering additional categories.

I would like to make it simple to select data whereby the user starts types the first letter of the category to jump them to the item they want to select rather than having to scroll through the entire list each time.

A number of entries will be on each form and the current method would get very tedious.

Does anyone know how to do this??? I am using Excel version 2003 on PC.

Thanks N

This needs to be done with the combo box from the controls tool bar, this requires vba, are you willing to go that way??

If you place your combo box on the sheet, and your list is on sheet 2 column A, this code will populate the combo box

   ComboBox1.List = _
      Worksheets("Sheet2").Range("A1") _
      .CurrentRegion.Columns("A").Value