Noname > 28-08-10, 10:58 AM
Private Sub MyDrive_GotFocus()
Dim fs, d, dc, s, n
Set fs = CreateObject("Scripting.FileSystemObject")
Set dc = fs.Drives
n = 0
For Each d In dc
s = s & d.DriveLetter & ":,"
n = n + 1
Next
MyDrive.ListRows = n
MyDrive.RowSourceType = "Value list"
MyDrive.RowSource = s
End Sub