Hi all,
As attached is a worksheet I am currently working on, however I'm faced with a problem and hope to get some help here.
As shown in the attachment there are five boxes (rectangle shapes) and 5 option buttons of Form Control (Linked to cell Z2)
What I hope to achieve is to link the 5 boxes respectively to the 5 option buttons into a sense that when one of the option is being selected, only the box being linked to the option button will appear whereas the rest of the 4 boxes will remain hidden.
I tried to make do with conditional formatting and highlighting the cells but I could not achieve the exact dimensions that will be required as compared to the boxes seen.
Exact dimensions are required as I will need to check if the blue box below will fit into the white box or will there be any excess overhang.
Here are the dimensions for the five options in case it could be of some use to lead to a solution:
1. PMC - 96 X 125
2. PGA (20 footer) - 96 X 238.5
3. PLA - 60.4 X 125
4. PEB - 53 X 88
5. PAG - 88 X 125
Do appreciate any sort of assistance available (I'm quite weak and badly trained with MS Excel, and am still quite ignorant to deal with macro without instructions) and do pardon my bad English.
Thanks!
Cheers.
Bookmarks