Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() Hi, I'm trying to have a reminder message pop up when a certain cell is selected. I would like to do this with VBA as opposed to doing it with a Data Validation input message. I've tried the following code but to no avail. Here's the code followed by the error message. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Row = 5 And Target.Column = 6 Then MsgBox = "Have you verified your Extra Material setting in cell A1? Normal setting is 25." End If End Sub I get the following error message: --------------------------- Microsoft Visual Basic --------------------------- Compile error: Function call on left-hand side of assignment must return Variant or Object --------------------------- OK Help --------------------------- -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=469251 |
#2
![]() |
|||
|
|||
![]()
Casey,
No equal sign on the MsgBox line: Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Row = 5 And Target.Column = 6 Then MsgBox "Have you verified your Extra Material setting in cell A1? Normal setting is 25." End If End Sub You can also modify other cells, or check the input value with the change event. HTH, Bernie MS Excel MVP "Casey" wrote in message ... Hi, I'm trying to have a reminder message pop up when a certain cell is selected. I would like to do this with VBA as opposed to doing it with a Data Validation input message. I've tried the following code but to no avail. Here's the code followed by the error message. Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) If Target.Row = 5 And Target.Column = 6 Then MsgBox = "Have you verified your Extra Material setting in cell A1? Normal setting is 25." End If End Sub I get the following error message: --------------------------- Microsoft Visual Basic --------------------------- Compile error: Function call on left-hand side of assignment must return Variant or Object --------------------------- OK Help --------------------------- -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=469251 |
#3
![]() |
|||
|
|||
![]() Bernie, Thanks for the help. Worked like a charm. Thanks for the added suggestions as well. I might have some uses for those in some other spreadsheet apps. Thanks again. -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=469251 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem office assistant | Excel Discussion (Misc queries) | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
EXCEL 2003 PROBLEM | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) |