thanks, my basic need is i have a webquery in A1 based on a macro.Instead of
selecting from datavalidation list in A1 i would like to automise it by
selecting the parameter 'word' from the list in Column B.

"Gary''s Student" wrote:

The usualy method is to use a Data Validation pull-down list. When you click
on the empty A1 cell, all the options in column B appear and a single click
will fill cell A1.

See:

http://www.contextures.com/xlDataVal01.html
--
Gary''s Student - gsnu200783


"TUNGANA KURMA RAJU" wrote:

I am looking for a function or proceedure to link cell and its contents in a
worksheet?. For example:
in Sheet1 :
A1=blank
B1=Mango
B2=apple
B3=50
B4=XYZ
I want to hyperlink cells B1 to B4 to Cell A1.When I select B1,cursor should
move to cell A1 with value 'Mango',and if I select B3, cell A1 should
display 50.
Any body from this forum suggest me a function !!!