Hello all,
I am developing a form for a daily report.
I am attempting to use option buttons for items line Weather Delay, Inspections occurred, Materials Received, etc.
I started out using the Form Controls. Everything was going along fine, I was making my group box, then inserting my 2 option buttons for yes and no. The first 6 went well. When i got to the 7th group it decided to attached itself to the No Option in Group 4. So after some messing around, I deleted Group 4 and Group 7 and re-inserted new groups. Those worked as intended, but the same problem repeated when I got to Group 12 with Group 9. After some more frustration, I deleted all the Form Controls and used ActiveX Controls.
Everything is working great, UNTIL I copy my template sheet to create sheets for the rest of the week. Now my ActiveX controls are not maintaining their values when subsequent selections are made on new sheets. - I realized my problem is that the group name needs to be changed for each control group.
Question: Is it possible to get the GroupName property to "see" the sheet name and insert that prior to or after the group name i have assigned?
Question2: what would some code look like that would do the following
- Copy a sheet (or a set of sheets - one full week with the weekly summary)
name the sheet(s) based on user input or a stepped pattern
rename the GroupNames that are needed to be renamed
Thanks,
Mark
Bookmarks