How to enable Userform with optionbutton checked?

**meprad** · 05-23-2013, 09:58 AM

Dear Excel Experts,

I have designed a userform with 10 optionbuttons. When these optionbuttons are clicked I linked the value in the cell next to active cell using offset as like this :
If OptionButton10.Value = True Then ActiveCell.Offset(0, 4).Value = 20
If OptionButton9.Value = True Then ActiveCell.Offset(0, 4).Value = 30 (and so forth)

The userform is basically a score card to give the score against each rows in the worksheet.
This userform pops when i clicked the last cell of a row.

Now what i want is, when I open userform, I want optionbutton "marked" based on the cell value above.
I have also attached excel file to make my question more clear.

Any kicks to roll on right direction will be very much appreciated.

best,
Prad

**tehneXus** · 05-23-2013, 01:08 PM

try this: File.xlsm

file contains your code plus:

Please Login or Register  to view this content.

**meprad** · 05-24-2013, 12:33 AM

Dear Tehnexus - Super !!! you saved me my friend and thanks a million for your help. you are a excel magician. May I dare to ask you one more simple thing? sorry, it may sound stupid...

I want to close userform when the escape key is pressed, I tried with few codes but no success. Once again thank you so very much ......

best,
Prad

**tuongtu3** · 05-24-2013, 01:22 AM

Try this file with button "Exit". You can either hit "Exit" button or ESC key.

Regards,
tt3

**meprad** · 05-24-2013, 07:06 AM

Thank you soooo much Tuongtu3 ....this is such a great help for me....I'll keep posting with different challenges in excel that come across in days to come. wish you all good !

regards,
Prad