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.
Thanks,![]()
Private Sub Userform_Initialize() If Reg16.Text = "Yes" Then Me.spInviteAtt.Enabled = True Else: Me.spInviteAtt.Enabled = False End If End Sub
Forrestgump1980
Bookmarks