Results 1 to 4 of 4

Thread: Select Case Prob [RESOLVED] thx p

Threaded View

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Jun 2003
    Posts
    124

    Select Case Prob [RESOLVED] thx p

    I have the following code

    PHP Code:
     Dim KeyAscii As Integer
     KeyAscii 
    Asc(strPath.Chars(0))
    Select Case KeyAscii
           
    Case KeyAscii 67
               cDrive 
    cDrive 1
                
    If bDriveC False Then
                      intStartingY 
    intStartingY 1
                      oSheet
    .Cells(intStartingY7).Value strDriveLetter
                      bDriveC 
    True
                 End 
    If
                 
    oSheet.Cells(intStartingY8).Value cDrive
                 intDriveLocation 
    intDriveLocation 1
           
    Case KeyAscii 68
                
    'similar to above code
           '
    .
           
    '.
           '
    .
           Case 
    KeyAscii90
                 
    'similar to above code

    End Select 

    i cant get the cases to be selected, i've tested with msgbox (KeyAscii) and am sure that the Ascii values are correct.

    any help would be great

    thanks
    Last edited by daveStudent; Jul 15th, 2003 at 11:02 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width