PDA

View Full Version : Solved: If value "tick mark" then ...



ndendrinos
05-06-2007, 04:41 PM
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
05-06-2007, 10:48 PM
By tick mark you mean? A CheckBox? Is this a CheckBox from the Forms toolbar or the Control Toolbox?

ndendrinos
05-06-2007, 11:11 PM
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
05-07-2007, 06:11 AM
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"