In an excel cell,choosing a value,similar to combobox in VB - reg

[Thirumalai]

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.

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.

"Thirumalai" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
>
>
>

[Ardus Petus]

Have a look at Data>Validation select List

HTH
--
AP

"Thirumalai" <[email protected]> a écrit dans le message de
news:[email protected]...
> 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.
>
>
>
>