Macro for dynamic checkbox

[Alex808]

Hi!
I have dynamic checkbox for each string that was found in column A.
eg.

A B
"Ferrari" chkbox
"Porsche" chkbox
"Chrysler" chkbox
"Mercedes" chkbox
"Fiat" chkbox

Now.What kind of Macro should I enter so when I click any checkbox, I can copy the string on column C?

eg.
A B C
"Ferrari" chkbox "Porsche"
"Porsche" chkbox:True "Fiat"
"Chrysler" chkbox
"Mercedes" chkbox
"Fiat" chkbox:True

How I start?
Sorry, but my English is not so good

 

[Andrzejek]

You are asking people to read your mind, and we can not :-(

What application? - I guess Excel
Your checkboxes - are they on a UserForm on in the sheet?

Have fun.

---- Andy

 

[PHV]

Furthermore, what have you tried so far and where in your code are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Alex808]

Mmm...
1 - Excel
2 - in a sheet

I can allocate the file excel on sandspace.com? box.net is filtrate..
Thanks

 

[SkipVought]

"Now.What kind of Macro should I enter so when I click any checkbox, I can copy the string on column C?"

No macro at all!

You can use Data > Validation - LIST in column C, using the list in column A. Then, all the user does is select from the Data Validation DropDown in Column C.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Alex808]

Ok !!! Thanks Skip!!
Thanks at all!