Assign Macro to Checkbox
IMO?
Bob Phillips wrote:
Checkboxes, from the Forms toolbar or the Controls toolbox, do not reside on
a row, they are on a layer extra the worksheet. You could link it tom a
cell, but better to just check the name IMO
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"jafsonic" wrote in message
oups.com...
Thank You,
If I use a forms checkbox, will I still be able to reference the
current / selected row that the checkbox is in?
Bob Phillips wrote:
Use checkboxes from the Forms toolbar, and assign them all to the same
macro, use
Application.Caller
to check which has been clicked.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"jafsonic" wrote in message
ups.com...
I have a series of checkboxes which affect conditional formatting in
other cells in each given row where the checkbox is located. The code
is generic enough to use with every checkbox. I could call a
subroutine from each checkboxY.click command, but is there a way to
set
all the checkboxes to just use the one routine?
Thanks, this is driving me nuts and I don't want to have to edit EVERY
single macro.
|