Hello Again!
I'm almost done with this little application. One thing I should know how to do (But don't) is chane the value of a text based on another cell value.
I have a "Dealer" column with about 27 dealer abbrv. like "ALK", "DGN" and so on. I want to set the email based on the value in this cell when My user form intitalizes I really don't want to do this:
[VBA]Private Sub UserForm_Initialize()
If ActiveCell.Offset(-1, -10) = "ALK" Then
txtEmail.Text = "john@domain1.com"
ElseIf ActiveCell.Offset(-1, -10) = "CLK" Then
txtEmail.Text = "rob@domain2.com"
ElseIf ActiveCell.Offset(-1, -10) = "DDT" Then
txtEmail.Text = "regina@domain3.com"
ElseIf ActiveCell.Offset(-1, -10) = "DGN" Then
txtEmail.Text = "Natasha@domain4.com"
end if
end sub
[/VBA]
Is there a better way to write this condition ??
Hopefully this question makes sense.