📊 VBA (Excel)
Check Disable Windows Spotlight on Desktop Registry Value (VBA)
Reads the Disable Windows Spotlight on Desktop registry value via WScript.Shell.RegRead and reports it in a message box — no PowerShell or reg.exe needed.
DisableWindowsSpotlightRegCheck.bas
Attribute VB_Name = "DisableWindowsSpotlightRegCheck"
Option Explicit
Public Sub DisableWindowsSpotlightRegCheck()
Dim wsh As Object
Dim regPath As String
Dim value As Variant
Set wsh = CreateObject("WScript.Shell")
regPath = "HKEY_CURRENT_USER\Software\Policies\Microsoft\Windows\CloudContent\DisableSpotlightCollectionOnDesktop"
On Error Resume Next
value = wsh.RegRead(regPath)
On Error GoTo 0
If IsEmpty(value) Then
MsgBox "Value not set:" & vbCrLf & regPath, vbExclamation, "Disable Windows Spotlight on Desktop"
Else
MsgBox "Disable Windows Spotlight on Desktop" & vbCrLf & regPath & " = " & value, vbInformation
End If
End Sub