IIF statement

  • Thread starter Thread starter Alex Martinez
  • Start date Start date
A

Alex Martinez

Hello,

I am wondering if there is a case statement similiar used in Visual Basic
that I can use instead of using IIf statment. Any tips will be appreciated.
Thank you.
 
Alex,

In VBA you can use a Select Case statement. In my experience, this is
not usually an alternative to using an IIf() function. Each has its
place. In other words, it depends on the context and your purpose.
Related to this question, there would also be the If...Then...Else
statement in VBA, and the Switch() function. If you could give an
example of what you are trying to achieve, someone may be able to offer
more specific advice.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if statment in case statement 2
Too many IIF statements 3
NESTED IIF STATEMENT. PLEASE HELP. 5
IIf question 7
IIF alternative in query 2
SQL IIF statement with TOP 10 0
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
Two IIF criteria 1

Back
Top