tinamiller1
New member
- Joined
- Aug 28, 2013
- Messages
- 16
- Reaction score
- 0
- Points
- 0
I have a worksheet where I have a drop-down cell with values from a hidden sheet. Then I have other cells where a monetary value is placed in that cell based on what is selected in the drop-down cell. When an option is selected in the drop-down cell, I want the corresponding monetary cell to allow a value to be entered and the other cell to then hide. Or disable so no data can be entered. My drop-down cell is G9, my 2 other cells are B67 and B69. Here is an example of my code:
I get a debug error no matter what I try
Code:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True
If Range("G9").Value = "Implant Pass-through: Auto Inovice Pricing (AIP)" Then
Range("B67").Hidden = False
End If
If Range("G9").Value = "Implant Pass-through: PPR Tied to Invoice" Then
Range("B67").Hidden = True
End If
If Range("G9").Value = "Implant Pass-through: PPR Tied to Invoice" Then
Range("B69").Hidden = False
End If
If Range("G9").Value = "Implant Pass-through: Auto Invoice Pricing (AIP)" Then
Range("B69").Hidden = True
End If
End Sub
I get a debug error no matter what I try