LinkBack URL
About LinkBacks
Dear VBA Guru's
In the attach Excel userform, is a snippet that contains a major obstacle to completing my application.
There are (5) date fields, upon entering a date in the first field the others will populate consecuative weeks automatically.
On page 1 of the multipage, [PHASE I], are (3) checkboxes for each of the corresponding weeks.
The (15) checkboxes are initially labeled "A", "B", and "C"; the result of which could represent any process or inquiry for that particular checkbox for the indicated week.
Page 2 of the multipage, [WEEKLY SUMMARY], reveals a checkbox for each of the (5) weeks which the user may choose to view a summary for any particular week.
Upon selecting a week to view 'checkbox', the user clicks the [VIEW SUMMARY] control button which displays the selected [WEEK] and --> Should <-- display a result for whichever criteria was chosen from the previous checkbox selection on the page [PHASE I].
-----
Example:
If in the first week selection "A" and "C" were chosen, (checkbox1 & Checkbox3), then by choosing checkbox16 and applying [View Summary], the summary sheet should indicate:
Week 1, the first textbox should result in "GC", and the 3rd. textbox should result in "GC".
Likewise, if no choices,(A,B, or C) were made for week 2, then upon selecting to view 'Week 2' (checkbox17) then the textboxes on the summary sheet should be cleared.
Therefore, the selection for any week should reflect which selection was made for that corresponding week upon viewing the summary.
At this time, I can't think of how else to explain the mechanics of the process.
I have tried "IF" statements, "IF AND", "IF ELSE", and tried each code in the checkbox lines, textbox lines...
My brain is fried on this one, and it is most crucial to completing this project.
Please, I'm in need of someone with knowledge... not controversy.
Thank you, Thank you, Thank you.
As always, kudos are in the form of "Special thank you to: "your username" in the first lines of code.
Register To Reply
Bookmarks