A combobox does this. Use the one from the control toolbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" wrote in message
...
I am sorry I tried through newsgroups search I could not get solution.

in some webpage if I click an alphabet e.g. A ,I get the list of items
(name, scrips etc) beginning with A
is it possible to do something like this in excel with vba or without vba


--
remove $$$ from email addresss to send email