Check Disable Autoplay for All Drives Registry Value (VBA)

Attribute VB_Name = "DisableAutoplayAllDrivesRegCheck"
Option Explicit

Public Sub DisableAutoplayAllDrivesRegCheck()
    Dim wsh As Object
    Dim regPath As String
    Dim value As Variant

    Set wsh = CreateObject("WScript.Shell")
    regPath = "HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Policies\Explorer\NoDriveTypeAutoRun"

    On Error Resume Next
    value = wsh.RegRead(regPath)
    On Error GoTo 0

    If IsEmpty(value) Then
        MsgBox "Value not set:" & vbCrLf & regPath, vbExclamation, "Disable Autoplay for All Drives"
    Else
        MsgBox "Disable Autoplay for All Drives" & vbCrLf & regPath & " = " & value, vbInformation
    End If
End Sub