View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
davegb davegb is offline
external usenet poster
 
Posts: 573
Default Object doesn't support...

this property or method. Message I'm getting when I enter any text
password into the text box which uses this code:

Private Sub cbOK_Click()
sPwrd = ufPwrdEntry.tbPwrdEntry.Value <---Object doesn't support...
If sPwrd = "" Then
MsgBox "Please enter the password to access this worksheet.",
vbOKCancel
End If
End Sub

Just setting a string variable to what was entered into a textbox, I
thought. Any suggestions?

Thanks!