EXCEL - How do you make a Radio button larger in an excel sheet?

Hi,

I cannot find out how to make a radio button larger. I was told you may be able to do it through code, but I can't figure it out. Any help? I was wondering if i could choose my own size?

Thanks,

Are you using VB6 or VBA (Visual Basic within excel)?

Visual Basic inside Excel

Thread moved from the 'CodeBank VB6' forum (which is for you to post working code examples, not questions) to the 'Office Development/VBA' forum... note that while it certainly isn't made clear, the "VB Editor" in Office programs is actually VBA rather than VB

Code:

---

Sheets("sheet2").Shapes("optionbutton1").Width = 399

---

change sheet and radio button name to suit, same for height

Quote:

---

Originally Posted by westconn1

Code:

---

Sheets("sheet2").Shapes("optionbutton1").Width = 399

---

change sheet and radio button name to suit, same for height

---

Okay. So I need to right click the Button and hit assign macro, and go to new and change the settings from there?
When I did that nothing happened. mine was: Sheets("sheet1").Shapes("optionbutton1").Width = 399

Quote:

---

So I need to right click the Button and hit assign macro

---

i doubt that you would want to change the size of the button from within its own click event

Quote:

---

When I did that nothing happened.

---

put a breakpoint on that line of code to see if it ever runs

Quote:

---

Originally Posted by anoble1

Hi,
I cannot find out how to make a radio button larger. I was told you may be able to do it through code, but I can't figure it out. Any help? I was wondering if i could choose my own size?
Thanks,

---

Reading your reply to westconn1, it sounds to me as if you actually just want to change the size of the radio button and to do it via cosde was the work-around!
If thats true, did you rigth click on the RadioButton and formated it?
The change via code and via formatting will NOT change the small cirlce of the Button, the whole Control (circle with text) will be changend!