Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a drop down list to beginning letter of item?
I have created a drop down list in Excel and I want to be able to type the
letter K and it go to those items in the list that begin with K. Does anyone know how I can set this up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I set up a drop down list to beginning letter of item?
Kerri, place any button ( or autoshape ) into your sheet
copy the Sub below rightclick on the tab of the sheet paste the sub into the module Go back to your button or autoshape right click on it select Assign Macro ( now this macro will run when the shape is clicked) choose the one you just pasted in replace "sheet1" with the name of your current worksheet replace "FindThis" with the cell you want to match ( your dropdown window cell) And replace the "LookHere" with the column you want to look in You can designate a column (pref col A... insert one if you need to ) type the letter( col A ) at the beginning of your list (in col B) col A col B A Adams Afrin Agnes B Bailey Barnes Beetle etc...... HTH Sub GoFindThis() Dim myFind As Integer Dim rng As Range myFind = Worksheets("sheet1").Range("FindThis").Value Set rng = Worksheets("sheet1").Range( _ "LookHere").Find(myFind, _ LookIn:=xlValues, LookAt:=xlWhole) If Not rng Is Nothing Then Application.GoTo rng, True Else MsgBox myFind & " You selection was not found" End If End Sub "Kerri" wrote: I have created a drop down list in Excel and I want to be able to type the letter K and it go to those items in the list that begin with K. Does anyone know how I can set this up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Drop Down List | Excel Discussion (Misc queries) | |||
Advanced Excel Drop down List | Excel Discussion (Misc queries) | |||
Drop Down List + VLOOKUP | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |