Thread: Error #91 Object Variable or With Block Not Set

Hey All,

I have a Piece of code that when a form is initialised it runs. I Want the code to find if there is a value in the current cell selected and if there is load the form if not dont load the form.

This is the code that i have produced:

Code:

Private Sub UserForm_Initialize()

Dim Target As Integer
Let Target = Selection.Value

If Target = 0 Then
    MsgBox Prompt:="PLEASE SELECT AN ITEM", Buttons:=vbOKOnly + vbInformation
    Unload PRICE_CHANGE
End If
End Sub

The Problem is that it works fine if the "Unload PRICE_CHANGE" isnt in there but the error #91 "Object Variable or With Block Variable not Set"

I have tried a number of ways to overcome it but just cant get it to work.

any help will be great. Thanks

Tom