Tom,
The value of cells in column M and J is linked to checkbox. When
chech the first box, the value of cell in column M becomes "TRUE", bu
when it is unchecked it is "False". Same is with the second checkbox
The second check box is linked with cells in column J. I want the use
to check only one box in each row. I know I can do it by using th
Option Button & group box, but there are some other macros whic
prohibits me using the group box. Hence I am using the check bo
option.
I have used check box from the Form toolbar. Hence I was looking for
macro which will get fired with any of the check box & will give me a
error message if the user checks both the boxes
Tom Ogilvy Wrote:
You have a checkbox in each row and if it is checked or unchecked (o
just
checked?) you want it to fire a macro that puts up a msgbox if th
value in
columns M and J of that row have the same value. What kind of checkbo
- is
it from the control toolbox toolbar or the forms toolbar (the form
toolbar
checkbox would be much more adaptable to this requirement)?
--
Regards,
Tom Ogilvy
"nik_gujarathi" wrote:
Hello frineds,
I was looking for a small macro that will give a error message i
the
value of cells in column M & J is same.
Here is the main problem..
This macro should get activated with a check box present in eac
row.
--
nik_gujarathi
------------------------------------------------------------------------
nik_gujarathi's Profile
http://www.excelforum.com/member.php...o&userid=34522
View this thread
http://www.excelforum.com/showthread...hreadid=543727
--
nik_gujarath
-----------------------------------------------------------------------
nik_gujarathi's Profile:
http://www.excelforum.com/member.php...fo&userid=3452
View this thread:
http://www.excelforum.com/showthread.php?threadid=54372