List Box

R

Rob

Hello I need help with a spreadsheet project I would like to improve
on.
I have a spreadsheet the spans many columns. What I would like to do is
set up a drop down list of lets say items in each column
example: column "A" has the word bear in cell a1

a b c d
bear dog cat horse

I want to make a drop down list that works like the "find function"
so if I type be it will find the word bear in the correct column like
is used on web pages for States

hope I explained it well enough for you to understand what I would like
to do.

thank you
Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make repeating drop-down lists? 2
Drop down list control value in vba 2
Mail Merge Directory Conditional Page Break 0
Excel does not accept text format! 0
Inserting a list into "If" function 2
Word VBA - Want to test if Full Name is NOT Present in document 0
drop down list 1
if functions involving drop down lists. 3

Top