Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA Target Worksheet change
When I cut and paste the below MS excel macro into a new workbook
module sheet, it does not work? I type the y in column c, this macro will not work... Please help... Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 3 Then If (Target.Text = "y") Then MsgBox "hello" End If End If End Sub |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel VBA Target Worksheet change
This kind of code goes behind the worksheet.
If you rightclick on the worksheet tab that should have this behavior, you can select view code. Paste the code in that code window that just opened up. wrote: When I cut and paste the below MS excel macro into a new workbook module sheet, it does not work? I type the y in column c, this macro will not work... Please help... Private Sub Worksheet_Change(ByVal Target As Excel.Range) If Target.Column = 3 Then If (Target.Text = "y") Then MsgBox "hello" End If End If End Sub -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I protect a worksheet yet allow editing in Excel 2000 | Excel Discussion (Misc queries) | |||
Excel worksheet display #### | Excel Discussion (Misc queries) | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
How do i get the excel worksheet to automatically add or change c. | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions |