Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If WB not there; give message: What am I doing wrong? | New Users to Excel | |||
How to give an error message if a cell value entered is larger than permitted | Excel Discussion (Misc queries) | |||
Record a macro to use in any workbook--give it to others. | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
Why does this statement give an error message? | Excel Programming |