I tried your suggestion. I have created a combo box

list fill range is a range of 853 cells
match entry 0-fm match entry first letter
dragbehaviour-drabbutton enabled
for the present i kept the linkcell as blank

it is true if I type A in the combo box the first entry beginning with A
comes
as I go on pressing A all the names of A are coming replacing the earlier
one. . I can stop when my "name" comes and drag it to a cell

But i would like to have all the "names" with A should come into the combo
box so that I can select among them to drag and drop. similarly for B etc.
If I succed I can use linkcell and also create a vba that each selected name
comes into different cell.s

I request you to give me a further hint or two. It is always a pleasure and
an education to slog and find on one's own the answer with the help of the
hints from experts.

thanks and regards.
============================================
R.VENKATARAMAN wrote in message news:...
thank you . I shall try


Bob Phillips wrote in message
...
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