Results 1 to 7 of 7

VBA: Using Symbols

Threaded View

  1. #1
    Registered User
    Join Date
    07-27-2012
    Location
    Philippines
    MS-Off Ver
    Excel 2003
    Posts
    4

    VBA: Using Symbols

    I have a problem, when I have if-else statements that specifies the value of my combo-box, I encountered error on symbols (greek letter raw to be specific)
    It only displyed ? as seen in the incomplete program. Any help would be appreciated.



    Private Sub ComboBox1_Change()
    
    If ComboBox1.Value = "Pa" Then
    
    
    
    ElseIf ComboBox1.Value = "Pb" Then
    
    
    
    ElseIf ComboBox1.Value = "G" Then
    
    
    
    ElseIf ComboBox1.Value = "R" Then
    
    
    
    ElseIf ComboBox1.Value = "T" Then
    
    
    
    ElseIf ComboBox1.Value = "M" Then
    
    
    
    ElseIf ComboBox1.Value = "a" Then
    
    
    
    ElseIf ComboBox1.Value = "Pb" Then
    
    
    
    ElseIf ComboBox1.Value = "?a" Then
    
    
    
    
    
    
    
    End Sub
    Last edited by Cutter; 07-27-2012 at 09:00 AM. Reason: Added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1