Help with macro to give a message box

  • Thread starter Thread starter nik_gujarathi
  • Start date Start date
N

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
 
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]...
 
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)?
 
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 said:
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)?
Click to expand...
 
Back
Top