Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
using Switch() to call functions
I have different code modules i've created and they are to be ru
depending on the user that is logged in. I would prefer to use th Switch() statement instead of a series of If..Then..Else statements Problem is, i'm not sure how to do it since the definition of Switch( seems to have to return something. I'm more familiar with C++ and I' like to be able to use the VBA Switch much like I could with the C+ switch. If anyone can point me to some information or give me a example, I would greatly appreciate that. Thanks -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
using Switch() to call functions
Try the "Select Case" statement. That's VBA's equivalent of Java's Switch()
statement, so it's probably the same as the Switch() statement in C++, too. Regards, Wes |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What do you call values used with a functions? | Excel Worksheet Functions | |||
Can you call functions between sheets in the same book in excel? | Excel Worksheet Functions | |||
How to call worksheet functions from Access ? | Excel Worksheet Functions | |||
How to call COM Add-In functions from a macro | Excel Programming | |||
Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF? | Excel Programming |