check box not working on user form

[wpryan]

Hello,

I have a check box which I want to use to populate a userform with default values by use of a checkbox. I'm getting an "Object variable or With block variable not set" error.

code:

Private Sub ckCapsDef_Click()


    Dim ws As Worksheet
    Set Worksheet = Sheets("Temp")
    
    If Me.ckCapsDef = True Then
        Me.txtcPwr = ws.Cells(3, 1).Value
        Me.txtcDiam = ws.Cells(3, 2).Value
        Me.txtcHeight = ws.Cells(3, 3).Value
        Me.txtcLSD = ws.Cells(3, 4).Value
    Else:
        Me.txtcPwr = ""
        Me.txtcDiam = ""
        Me.txtcHeight = ""
        Me.txtcLSD = ""
    End If
End Sub

Any help is appreciated.

 

[steve the fish]

Try:

Set ws = Sheets("Temp")

 

[wpryan]

Duh, such a simple thing! thanks a heap!