Help with macro to give a message box
 

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

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

Help with macro to give a message box
 

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"
wrote in message
news:nik_gujarathi.2825yy_1148048124.3395@excelfor um-nospam.com...

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

Help with macro to give a message box
 

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

Help with macro to give a message box
 

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