View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roger L[_2_] Roger L[_2_] is offline
external usenet poster
 
Posts: 10
Default Auto select when using Combo box in worksheet

I have a combo box (ComboBox1) on a spreadsheet which is linked to a range
name ("Masterlist") which includes a list of titles. I'm trying to get the
combo box to automatically select from the list as I'm typing the characters
in the title. Does anyone have code that will allow this to happen?

I want to be able to type each letter and as I do, the selector will move up
and down the combo box matching what has been typed. Thanks for your help.

Roger