Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Case function
Does Excel have a function similar to the "Case" command in other programming
languages? |
#2
|
|||
|
|||
In VBA, yes
Select Case myVal Case 1: 'do something Case 2: 'do something else Case Else; ' exception End Select -- HTH RP (remove nothere from the email address if mailing direct) "Al" wrote in message ... Does Excel have a function similar to the "Case" command in other programming languages? |
#3
|
|||
|
|||
XL itself doesn't, since XL is not a programming language. It does have
IF() and CHOOSE() functions, which can be used similarly. OTOH, VBA has a Select Case statement that is pretty well explained in VBA Help. In article , "Al" wrote: Does Excel have a function similar to the "Case" command in other programming languages? |
#4
|
|||
|
|||
Bob,
Pardon my ignorance but how do I call the myVal routine from within Excel? "Bob Phillips" wrote: In VBA, yes Select Case myVal Case 1: 'do something Case 2: 'do something else Case Else; ' exception End Select -- HTH RP (remove nothere from the email address if mailing direct) "Al" wrote in message ... Does Excel have a function similar to the "Case" command in other programming languages? |
#5
|
|||
|
|||
Hi Al,
It is part of a macro, here is an example that is an event macro http://www.mvps.org/dmcritchie/excel/event.htm#case even though event macros are not the most common macros they are easier to install. This particular macro would be triggered by entering a constant into a cell (as opposed to a value changing due to a formula). installed by right click on sheet tab, view code, place code inside. Some information on standard macro installation and use http://www.mvps.org/dmcritchie/excel/getstarted.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Al" wrote in message ... Bob, Pardon my ignorance but how do I call the myVal routine from within Excel? "Bob Phillips" wrote: In VBA, yes Select Case myVal Case 1: 'do something Case 2: 'do something else Case Else; ' exception End Select -- HTH RP (remove nothere from the email address if mailing direct) "Al" wrote in message ... Does Excel have a function similar to the "Case" command in other programming languages? |
#6
|
|||
|
|||
It is not a routine, it is a variable being tested for in the case
statement.It applies to VBA, not to Excel itself. If you want a case type function in a worksheet, there isn't one. There are many lookup functions that might do what you want, but you would need to present the problem to tell. -- HTH RP (remove nothere from the email address if mailing direct) "Al" wrote in message ... Bob, Pardon my ignorance but how do I call the myVal routine from within Excel? "Bob Phillips" wrote: In VBA, yes Select Case myVal Case 1: 'do something Case 2: 'do something else Case Else; ' exception End Select -- HTH RP (remove nothere from the email address if mailing direct) "Al" wrote in message ... Does Excel have a function similar to the "Case" command in other programming languages? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reminder notifications in a column | Excel Discussion (Misc queries) | |||
How can i change this VBA project According to Indian Numeric | Excel Discussion (Misc queries) | |||
Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
Amount or Numbers in Words | New Users to Excel | |||
Is there a formula to spell out a number in excel? | Excel Worksheet Functions |