Results 1 to 8 of 8

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

  1. May 8th, 2013, 02:31 PM #1
    anoble1
    anoble1 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2009
    Location
    ALABAMA
    Posts
    13

    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,
    Reply With Quote Reply With Quote
  2. May 8th, 2013, 08:56 PM #2
    Nightwalker83
    Nightwalker83 is offline
    PowerPoster Nightwalker83's Avatar
    Join Date
    Dec 2001
    Location
    Adelaide, Australia
    Posts
    13,344

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

    Are you using VB6 or VBA (Visual Basic within excel)?
    when you quote a post could you please do it via the "Reply With Quote" button or if it multiple post click the "''+" button then "Reply With Quote" button.
    If this thread is finished with please mark it "Resolved" by selecting "Mark thread resolved" from the "Thread tools" drop-down menu.
    https://get.cryptobrowser.site/30/4111672
    Reply With Quote Reply With Quote
  3. May 9th, 2013, 06:48 AM #3
    anoble1
    anoble1 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2009
    Location
    ALABAMA
    Posts
    13

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

    Visual Basic inside Excel
    Reply With Quote Reply With Quote
  4. May 9th, 2013, 09:08 AM #4
    si_the_geek
    si_the_geek is offline
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,974

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

    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
    (Microsoft MVP from July 2007 to June 2017) . . . . . . . . . . Hitchhiker's Guide to Getting Help at VBForums

    Database Development FAQs/Tutorials (updated May 2011) (includes fixing common DB related errors, and [VB.Net] ADO.Net Tutorial, and [Classic VB] ADO tutorial /further steps)
    other useful DB bits: . Connection strings (alternative copy).•. MDAC/Jet/ACE downloads .•. SQL Server downloads .

    Classic VB FAQs (updated Oct 2010) (includes fixing common VB errors)
    some of my Classic VB bits: . Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. SQL 'Select' statement formatter/checker .•. Convert colour number to colour name .•. FlexGrid: fill from recordset .•. FlexGrid: AutoSize columns .•. DB Reserved Words checker .
    Reply With Quote Reply With Quote
  6. May 10th, 2013, 04:19 AM #5
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

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

    Code:
    Sheets("sheet2").Shapes("optionbutton1").Width = 399
    change sheet and radio button name to suit, same for height
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  7. May 13th, 2013, 02:55 PM #6
    anoble1
    anoble1 is offline

    Thread Starter
    New Member
    Join Date
    Aug 2009
    Location
    ALABAMA
    Posts
    13

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

    Quote Originally Posted by westconn1 View Post
    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
    Reply With Quote Reply With Quote
  8. May 13th, 2013, 04:24 PM #7
    westconn1
    westconn1 is offline
    PowerPoster
    Join Date
    Dec 2004
    Posts
    25,618

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

    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

    When I did that nothing happened.
    put a breakpoint on that line of code to see if it ever runs
    i do my best to test code works before i post it, but sometimes am unable to do so for some reason, and usually say so if this is the case.
    Note code snippets posted are just that and do not include error handling that is required in real world applications, but avoid On Error Resume Next

    dim all variables as required as often i have done so elsewhere in my code but only posted the relevant part

    come back and mark your original post as resolved if your problem is fixed
    pete
    Reply With Quote Reply With Quote
  9. May 14th, 2013, 02:00 AM #8
    opus
    opus is offline
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

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

    Quote Originally Posted by anoble1 View Post
    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!
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button

    Wait, I'm too old to hurry!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width