Question Combo Box

qiqinuinaifen128

Registered User.
Local time
Today, 11:21
Joined
Dec 21, 2008
Messages
29
I'm just begin to learn VBA. I have a simple question

I have a Combox and below is the value in my Combo Box

Bank Transfer
Cash Payment
Credit Card
Cheque Payment

My question is, how can i write my command for

If (Bank Transfer is selected)
message display "Bank Transfer is selected"
If (Cash Payment is selected)
message display "Cash Payment is selected"
If (Credit Card is selected)
message display "Credit Card is selected"
If (Bank Transfer is selected)
message box display "Bank Transfer is selected"

Thank you in advance
 
Code:
Select Case Me.MyCombobox
    Case "Bank Transfer"    '<-- Case 'x': 'x' is the value in the first column of the combobox.
        'code
    Case "Cash Payment"
        'code
    'etc.
End Select
 

Users who are viewing this thread

Back
Top Bottom