Conditional assignment?

[Maury Markowitz]

I can't believe this hasn't come up in my code before...

Does VBA have a conditional assignment function? Like...

msg = (user = "Maury") ? "Foo" : "Bar"

Maury

 

[Jim Thomlinson]

Nothing as concise as that but you can use iif instead of if