Hello there!
i need help with a macro to copy cells (the text in them) when the corresponding checkbox (linked with them) is checked into a textbox in the same sheet..
and i would be great if the text is removed from the textbox when i uncheck the corresponding checkbox! if its too complicated then its ok, i will have to deleted manually!
for example:
i have text in column B and checkboxes in A, if checkboxes A2, A3 and A49 are checked then the text in B2, B3 and B49 get copied in the textbox..
this would help me a lot in my job, so i appreciate the help very much
thanks in advance
i need help with a macro to copy cells (the text in them) when the corresponding checkbox (linked with them) is checked into a textbox in the same sheet..
and i would be great if the text is removed from the textbox when i uncheck the corresponding checkbox! if its too complicated then its ok, i will have to deleted manually!
for example:
i have text in column B and checkboxes in A, if checkboxes A2, A3 and A49 are checked then the text in B2, B3 and B49 get copied in the textbox..
this would help me a lot in my job, so i appreciate the help very much
thanks in advance