Hi All,

Not sure where i am going wrong with this but I am trying to enable or disable a spinbutton based on the value in a textbox. The code I am using is below. Reg.16 is the textbox and Me.spInviteAtt.Enabled is the spinbutton. Any help would be useful.

Private Sub Userform_Initialize()
If Reg16.Text = "Yes" Then
Me.spInviteAtt.Enabled = True
Else:
Me.spInviteAtt.Enabled = False
End If
End Sub
Thanks,

Forrestgump1980