I am trying to make a pricing spreadsheet which deals with certain head count, hours, complexity multipliers, etc. In an ideal world, there are 5 "stock" offers which these never change, and then a custom offer which I need the ability to manually choose each variable. I want to use VBA to force cells to a predetermined selection based on a user choice initially, but then allow the user to override the default selection if they need to add more headcount or hours or whatever. So load a predetermined value, then allow an "override".
So I am trying to start the coding aspects, but as you can tell, I am pretty bad at coding as I cannot create a basic IF, ElseIF, Else statement without errors. Ideally the code would look something similar to what I posted below. Where I am getting stuck, is how can I force a cell to a value, then allow the user to modify it without completely breaking the sheet's VBA?? I am needing some super awesome excel VBA people to help me. Thanks in advance!
So I am trying to start the coding aspects, but as you can tell, I am pretty bad at coding as I cannot create a basic IF, ElseIF, Else statement without errors. Ideally the code would look something similar to what I posted below. Where I am getting stuck, is how can I force a cell to a value, then allow the user to modify it without completely breaking the sheet's VBA?? I am needing some super awesome excel VBA people to help me. Thanks in advance!
VBA Code:
If ([J3] = "") Then
{
'// Custom project, no default values
}ElseIf ([J3] = "Design") Then
{
[E13] = "Design Review Level 1"
}ElseIf ([J3])= "Engineering") Then
{
[E3] = "Engineering Review Level 1"
}End If
End Sub