Conditional assignment?
 

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

Conditional assignment?
 

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

Jim Thomlinson


"Maury Markowitz" wrote:

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