I've got the userform that you can see below. The frame "FOLHAS A CONSULTAR" means the worksheet that I want to use after I pick the options in the option button above. Inside that frame there are 3 frames (Esforço axial), (Esforço de corte) and (esforço axial + corte) that contain labels with the name of the worksheet.
Atfer I pick options it only appears 1 label in each frame. Like the next figure.
I need to associate the label that is visible in figure 2 in each frame to a cell on the worksheet, and use a hyperlink to that result that guides me to the worksheet that I need to use. How can I say in VBA that I only want that the label that is visible on that frame at that point, appears on a cell in the worksheet?
I dont know if I'm being clear with want I need to do.