Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-18 Thread SG
Hi Abhi, Thanku so much for the clarification. On Monday, February 17, 2014 7:41:40 PM UTC+5:30, Abhi wrote: > > It's from the same form control toolbox you have picked the option button > from. Upon hovering the mouse pointer over the control, it says "Group Box > (Form Control)". You pick the

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
It's from the same form control toolbox you have picked the option button from. Upon hovering the mouse pointer over the control, it says "Group Box (Form Control)". You pick the group box first, draw it to the size on sheet, then you put option buttons in there. After you have put all the buttons,

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
okeyzzThanku so much for explanation. One more thing, i'm unable to find this group box in toolbox. Is this is the Microsoft Form 2.0 frame?? if yes, then how you have grouped these radio buttons in this box. Because on dragging this, we have to use frame object for option button in which li

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
Not exactly! For Option Buttons to act individually, you need to keep them in a group. The box you are seeing around the 5 buttons is a Frame (came from same toolbox) and when the option buttons are inside a frame, they are grouped and work individually from others. Since there were 3 questions, t

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
O yes. Thanku so much. I guess the idea behind its working is that you have unfreezed the linked cell in properties. Am i right sir?? On Monday, February 17, 2014 6:23:08 PM UTC+5:30, Abhi wrote: > > Something like this? > > > On Mon, Feb 17, 2014 at 4:58 PM, SG >wrote: > >> >> >> Hi ex

Re: $$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread Abhishek Jain
Something like this? On Mon, Feb 17, 2014 at 4:58 PM, SG wrote: > > > Hi experts > > Please help me with your effective solution. I'm working on a training > template in which individual scores would be analyzed & scores for all > trainees comes in summary sheet. For this, in each individual sh

$$Excel-Macros$$ Values for Radio Buttons

2014-02-17 Thread SG
Hi experts Please help me with your effective solution. I’m working on a training template in which individual scores would be analyzed & scores for all trainees comes in summary sheet. For this, in each individual sheet I have used radio buttons. What I need is for a parameter, if I click un