Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel advanced training - Select case
|
|
|
The UK's most regular 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
excel advanced training - Select case
Resolved · Low Priority · Version Standard
Reply Mon 22 Oct 2007, 16:27Delegate Jalpa said...
Jalpa has attended:
Excel VBA Intro Intermediate course
Select case
How do you structure a select case?
For upcoming training course dates see: Pricing & availability
RE: 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
|