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

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy


"nik_gujarathi" wrote:

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

Tom,
The value of cells in column M and J is linked to checkbox. When I chech the first box, the value of cell in column M becomes "TRUE", but 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 user to check only one box in each row. I know I can do it by using the Option Button & group box, but there are some other macros which prohibits me using the group box. Hence I am using the check box option.
I have used check box from the Form toolbar. Hence I was looking for a macro which will get fired with any of the check box & will give me an error message if the user checks both the boxes

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

--
Regards,
Tom Ogilvy


"nik_gujarathi" wrote:

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