Help with macro to give a message box

[nik_gujarathi]

Hello frineds,
I was looking for a small macro that will give a error message if th
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 each row

 

[Bob Phillips]

Add checkboxes from the forms toolbar, then assign each checkbox to this
macro

Sub CheckValues()
Dim oCheckbox As CheckBox
Dim iRow As Long
With ActiveSheet
Set oCheckbox = .CheckBoxes(Application.Caller)
If oCheckbox.Value = xlOn Then
iRow = oCheckbox.TopLeftCell.Row
If .Cells(iRow, "J").Value = .Cells(iRow, "M").Value Then
MsgBox "Same on row " & iRow
End If
End If
End With
End Sub



--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"nik_gujarathi" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

You have a checkbox in each row and if it is checked or unchecked (or just
checked?) you want it to fire a macro that puts up a msgbox if the value in
columns M and J of that row have the same value. What kind of checkbox - is
it from the control toolbox toolbar or the forms toolbar (the forms toolbar
checkbox would be much more adaptable to this requirement)?

 

[nik_gujarathi]

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

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)?