checkbox to copy and delete content of a cell

A

ash3154

I need help with VBA:
A1 B1 C1 D1
value checkbox if checked put value in C1, uncheck then clear
value checkbox " "
value checkbox " "

goes on for 500 rows.

Thanks
 
C

Cimjet

HI
Can you use this?
If you are using a "=EMBED("Forms.CheckBox.1","")"
right click-properties-link cell to "B1" and in C1 type this formula-
=IF(B1=TRUE,A1,"") and copy down.
Regards
Cimjet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
Anything will help 0
how can I lock/unlock a range of cells depending on state of a checkbox? 4
Data Validation and drop-down list using IF, AND and what else? 8
Need help with excel and checkboxes 2
Sum only selected controls 2
Checkbox issue - Checkbox overlapping when filter is applied 1
If, Or, and 5

Top