Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet

Guessed · #23 10-08-2020, 12:49 AM

Or perhaps you are not clever enough for your own good - the buttons should be Ribbon buttons but that is a whole other ball game.

I'm not sure how you created the 'buttons' on the sheet but I'm hoping they aren't regular boxes of the same type we have been working with. If this is the case, this change to the code should work

Code:

  For Each aCtl In Me.frameMarking.Controls
    For Each aShape In aSheet.Shapes
      If aShape.Type = 1 Then
        If aShape.Title = aCtl.Tag Then
          aShape.Visible = aCtl
        End If
      End If
    Next aShape
  Next aCtl

If that doesn't work, you will need to post your workbook so I can see how your buttons differ from the labels.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Trying to link a cell from one worksheet to another	gambo	Excel	1	01-18-2019 10:26 AM
How to populate a userform combobox from an excel worksheet	jrooney7	Word VBA	14	09-16-2018 08:52 PM
Userform calls other userform, then populate worksheet	Lehoi	Excel Programming	0	02-03-2016 02:58 PM
link worksheet on shared file	hifrank	Word	0	06-24-2015 07:29 AM
How do you copy a row from one worksheet to another?	mars1886	Excel Programming	3	02-11-2014 02:12 PM