Why not just select column a and apply Data=Validation.

--
Regards,
Tom Ogilvy



"John" wrote:

Hi,

I have a validation list (H1:H5), I hope, using VBA, the list can
automatically attach itself to any cell in the first column of the worksheet
when the cell gets input focus.

How can I do this?

Thanks.