Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced training - Select case
Jalpa has attended:
Excel VBA Intro Intermediate course
How do you structure a select case?
Jalpa
The Select Case routine has the following structure:
Select Case Country
Case "UK"
DeliveryCost = 2.00
Case "Ireland
DeliveryCost = 2.50
Case Else
DeliveryCost = 4.00
End Select
Hope this helps
Carlos
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question.
Our Microsoft Qualified trainers will then respond within 24 hours (working days).
Frequently Asked Questions
What does 'Resolved' mean?
Any suggestions, questions or comments? Please post in the Improve the forum thread.
If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:
Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.
TrustScore
4.9
/ 5
2533 reviews
Call for assistance
We will call you back
Formerly Best Training
© 2026 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
Software Training London Ltd. t/a STL
2nd Floor, CA House, 1 Northey Street,
Limehouse Basin, London, E14 8BT, United Kingdom.
Registered in England and Wales.
