Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Nested 'ElseIf' statements

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Nested 'ElseIf' statements

Resolved · Low Priority · Version 2003

Reply Thu 10 Mar 2011, 11:29Delegate Graeme said...

Graeme has attended:
Excel VBA Intro Intermediate course

Nested 'ElseIf' statements

Can you please advise if there is a limit to the number of 'ElseIf' statements you can nest into a single 'If' > 'End If'?

For upcoming training course dates see: Pricing & availability

Reply Tue 15 Mar 2011, 10:46Trainer Stephen said...

RE: Nested 'ElseIf' statements

Hi Graeme

Thanks for your question

In principle there is no limit to the number of ELSEif in an if block. I would however recommend using a Select Case block for checking a large number of multiple conditions, as this is easier to maintain and understand

Regards

Stephen

Excel articles

· Using The Excel Forms Toolbar To Spruce Up A Workbook
· How To Insert, Delete, Format, Hide, Copy And Protect Worksheets In Excel
· Importing Excel Data Into Access
· How To Split A Stacked Chart In Excel
· How To Use The Subtotal Function In Excel

Please browse our web site to find out more about
basic training excel and other Microsoft training courses.

Excel tip:

Bracketed negative numbers

Often Excel users wish to display negative numbers in colour red and bracketed

Intstructions
Step1. Select Format > Cells menu options. Within Numbers tabsheet, select Category = Custom.
Step 2. Select a type such as #,##0;[Red]-#,##0;; that specifies a colour in square brackets.
Step 3. Amend as follows; #,##0;[Red](#,##0;;

Notes: Excel formatting featues are of the form
"Positive; Negative;Zero;Text" separated by semicolon.

View all Excel hints and tips