Help with userform on VBA!

Closed
alfa_eng
Posts
10
Registration date
Thursday September 17, 2015
Status
Member
Last seen
September 30, 2015
- Sep 22, 2015 at 06:39 AM
Hello.

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.

Please, can someone help me.
Thanks