Solved: If value "tick mark" then ...

[ndendrinos]

Hello again,
On Sheet "Parts" starting in column B I have all my part numbers , description, unit price etc (7 columns)
Need to have the customer insert tick marks on the items needed then press a command button and transfer (copy paste) all the parts needed on sheet1 range : A6:G16
I have the code for the tick mark.
Thank you

[Jacob Hilderbrand]

By tick mark you mean? A CheckBox? Is this a CheckBox from the Forms toolbar or the Control Toolbox?

[ndendrinos]

Hello DRJ.
Just solved that one the hard way.
The attachment includes a sheet code as well as a module
Column A in sheet1 is formatted to "bold"
There must be a better way
Thank you

[ndendrinos]

Someone changed the header of my post to "If value "tick mark" then ..."
Thinking that maybe I'm dealing with divine intervention here I've changed the line If rng.Font.Bold = True Then to If value "tick mark" then
and got an error "Syntax Error"