Attachmate & Excel question, short
Attachmate & Excel question, short
(OP)
Excel 2010 can handle up to 64 nested IF statements in a single line. Can the same be said for Attachmate? As an example, can I have a macro look at a specific location and based off the corresponding text run a specific action. As an example, 22 letters of the alphabet, can the macro look at a specific location, determine the letter, then based off and IF Statement, do a specific action dependent on that letter? Yes or no would be good at this point, so I can attempt it on my own if possible. Thanks guys.
Talk To Other Members
RE: Attachmate & Excel question, short
Excel formulas and VBA are two different animals.
If you were coding in Excel VBA, a Cadillac compared to the Attachmate Yugo, you could use the Select Case ... End Case statement structure.
But in Attachemate VB, just use If ... Else ... End If and nest them.
I'd strongly urge you to Block Indent your structures and this is how I'd start with a complete block
CODE
If x = x Then Else End IfSkip,
Just traded in my OLD subtlety...
for a NUance!
RE: Attachmate & Excel question, short
rem
RE: Attachmate & Excel question, short
Skip,
Just traded in my OLD subtlety...
for a NUance!
RE: Attachmate & Excel question, short
I rarely code in Atachmate VB. Most of my codeing is in Excel VBA. And as it happened, my Extra VB Help did not reference the Select Case structure.
Select Case is probably the best approch for " 22 letters of the alphabet"
CODE
'all declarations at head of code module Dim s As String '...... statements that follow declarations Select Case s Case "A" 'this is what happens 'when this value is 'in the Case expression Case "B" 'this is what happens 'when this value is 'in the Case expression Case Else 'this is what happens 'when this value is 'none of the values 'in the Case expression End SelectSkip,
Just traded in my OLD subtlety...
for a NUance!