AzharNadeem
New Member
- Joined
- Mar 16, 2014
- Messages
- 9
Hi Experts,
I need bit of help with my first VBA Project. I am trying to build a down payment and amortization calculator. Here is the VBA code I used
I need help in two aspects
i) I tried to put all the cells dependant upon B5 in one range like range("B6, B9, B13,E5") but this does not work as desired. Also tried with $ sign
ii) I am trying to make cell B8 (price) unlocked if B5="Solar". The sheet will be password protected. I tried many solutions found online but neither of them worked.
Kindly help in this regard.
Regards
I need bit of help with my first VBA Project. I am trying to build a down payment and amortization calculator. Here is the VBA code I used
VBA Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$5" Then
Range("$B$6").Value = "Please Select"
End If
If Target.Address = "$B$5" Then
Range("$B$9").Value = "Please Select"
End If
If Target.Address = "$B$5" Then
Range("$B$13").Value = "Please Select"
End If
If Target.Address = "$B$5" Then
Range("$E$5").Value = "Please Select"
End If
If Target.Address = "$B$6" Then
Range("$B$7").Value = "Please Select"
End If
End Sub
I need help in two aspects
i) I tried to put all the cells dependant upon B5 in one range like range("B6, B9, B13,E5") but this does not work as desired. Also tried with $ sign
ii) I am trying to make cell B8 (price) unlocked if B5="Solar". The sheet will be password protected. I tried many solutions found online but neither of them worked.
Kindly help in this regard.
Regards
Attachments
Last edited by a moderator: