software

Dear Friends,

In an excel sheet, for a particular column cells, say for eg Column A, I
have to choose the values in each cells, similar to combobox in VB. i.e with
out typing manually.

How to do it?

Regards,
Thirumalai.Have a look at Datagt;Validation select List

HTH
--
AP

quot;Thirumalaiquot; gt; a écrit dans le message de
...
gt; Dear Friends,
gt;
gt; In an excel sheet, for a particular column cells, say for eg Column A, I
gt; have to choose the values in each cells, similar to combobox in VB. i.e
with
gt; out typing manually.
gt;
gt; How to do it?
gt;
gt; Regards,
gt; Thirumalai.
gt;
gt;
gt;
gt;
Hi

Have a look at Data/Validation. You can choose @list' from here and either
type in your own list or point to a range of cells which will become the
list.

Hope this helps.
Andy.

quot;Thirumalaiquot; gt; wrote in message
...
gt; Dear Friends,
gt;
gt; In an excel sheet, for a particular column cells, say for eg Column A, I
gt; have to choose the values in each cells, similar to combobox in VB. i.e
gt; with out typing manually.
gt;
gt; How to do it?
gt;
gt; Regards,
gt; Thirumalai.
gt;
gt;
gt;
gt;