I wish to make an error check for a Drive List Box, if it searches a drive, but nothing is there, or not located, for it to send a msg box telling the user, and going back to c: drive. right now I ahve this code.
Private Sub ListDrive_Change()
' Set Directory listing to current drive listing
DirectoryList.Path = listDrive.Drive
But upon testing it, if I go to A: drive, and have no disk in there, I get a run time error 68, device unavailable. This is obvious why the error was made, but was hoping if anyone had a quick fix code to hopp in there to check if device is available first, then go, if not msgbox and go back to c: drive. I will keep reading up on MSDN but if anyone can help, it would be most appreciated.