Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is Days the argument in the ValidateWorkingDays procedure? If so, Me is not
needed as it should be used in the call With Days .SetFocus .SelStart = 0 .SelLength = Len(Days.Text) End With and ValidateWorkingDays(Me.txtApril.Text, cancel = False) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Jake" wrote in message ... I have a form that allows users to enter working days for a month in 12 text boxes and I call a ValidateWorkingDays procedure in the BeforeUpdate event for each monthly text box. If user needs to re-enter value I have this code in my ValidateWorkingDays procedu With Me.Days .SetFocus .SelStart = 0 .SelLength = Len(Days) End With Days is a string in the ValidateWorkingDays procedure and I pass the textbox control text to the procedure e.g. Call ValidateWorkingDays(txtApril.Text, cancel = False) I get invalid use of Me keyword in a runtime error. I don't want to repeat code in each month. I'm new at this thanks for any help. Jake |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to pass a variable from Form back to calling procedure | Excel Programming | |||
Calling sub procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming | |||
Calling a procedure in a procedure | Excel Programming |