AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 1,835
- Office Version
- 2019
- 2016
- Platform
- Windows
I'm having bit of brainfade, I think !
Private p As String
Private d As String
Private m As String
The value I want to assign is returned by Designations("m/") or "p/" etc.
Do I need for example, m= Designations("m/"), repeated for every case, or can I somehow handle it with one line regardless of value "m/" or "d/" or "p/"
Private p As String
Private d As String
Private m As String
The value I want to assign is returned by Designations("m/") or "p/" etc.
Code:
Function Designations(d As String) As Variant
Designations = Switch(d = "p/", "Producer:", d = "o/", "Orchestra:", d = "m/", "Movie Or Musical:")
End Function
Do I need for example, m= Designations("m/"), repeated for every case, or can I somehow handle it with one line regardless of value "m/" or "d/" or "p/"