+ Reply to Thread
Results 1 to 1 of 1

Form Controls and ActiveX Controls - Option Button

  1. #1
    Registered User
    Join Date
    Seattle, WA
    MS-Off Ver
    Office 365 / Office 2019

    Form Controls and ActiveX Controls - Option Button

    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
    1. 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

    Attached Files Attached Files
    Last edited by mmchaley; 02-11-2021 at 05:17 PM. Reason: Attaching File

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Form Controls - Option Button not working
    By excel_googler in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-03-2016, 12:32 PM
  2. Form Controls v. ActiveX Controls
    By Richard Stringfellow in forum Excel General
    Replies: 2
    Last Post: 01-11-2016, 08:06 PM
  3. [SOLVED] Form Controls Option Button
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2014, 01:15 PM
  4. Replies: 2
    Last Post: 11-16-2012, 04:35 AM
  5. Form & ActiveX Controls
    By John Bates in forum Excel General
    Replies: 11
    Last Post: 03-05-2011, 03:59 PM
  6. Form controls vs. ActiveX controls
    By wmorrison49 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-25-2008, 10:59 AM
  7. ActiveX Controls vs Form Controls
    By Alex in forum Excel General
    Replies: 1
    Last Post: 01-11-2006, 04:50 AM

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1