Tool box for a (very) newbie

[T8keiteasy]

Hi,

I don't usually use VBA on excel so my question will be VERY easy to you.

I've inserted a combo box just to make a choice between many choices (ListFillRange C1:C9)

My question is about associating this combox to the cell so I can paste and copy to others cells...
When no choice is made the combox should disappear (look like an empty cell)...

Easy no ?

Thank you

Now, it's about French users too !!!

 

[xlbo]

You may be better off looking at Data>Validation and choosing the "List" option

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[T8keiteasy]

Thank you !

Now, it's about French users too !!!