With shtControlPanel
Select Case UCase(strValue)
Case cstrMONTHLY_PAID
.optMonthly.Value = True
DB_PayFrequency = PayMonthly
intFrequency = cintMONTHLY_PAID
Case cstrWEEKLY_PAID
.optWeekly.Value = True
DB_PayFrequency = PayWeekly
intFrequency = cintWEEKLY_PAID
Case cstr4WEEKLY_PAID
.optOther.Value = True
DB_PayFrequency = PayEvery4Weeks
intFrequency = cint4WEEKLY_PAID
Case Else
.optWeekly.Value = True
DB_PayFrequency = PayWeekly
intFrequency = cintWEEKLY_PAID
End Select
' ...
End With
In this code fragment, shtControlPanel is the CodeName of the worksheet
containing, among other things, 3 ActiveX option button (radio) controls,
namelY:
optMonthly
optWeekly
optOther
This code fragment has worked for months in Excel 2013 workbooks.
Suddenly, without any alterations made to the software, the code fails at
the compile stage opening the workbook, objecting to optMonthly, saying the
member cannot be found.
Has anyone experienced a similar problem?
The environment has bee subject to Windows updates only.
Any ideas would be appreciated.
Thanks
John A Cooke
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.
