| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row Variable assignment | Excel Discussion (Misc queries) | |||
| point assignment | Excel Discussion (Misc queries) | |||
| Key Assignment Log | Excel Discussion (Misc queries) | |||
| Assignment problem | Excel Programming | |||
| Assignment by reference or value | Excel Programming | |||
![Maury Markowitz[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
