Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Option Group (Excel 2000)

    I have a form in Access that is used to calculate quantities based on length width and depth. Each length width and depth has an option group associated with it so that the operator can select an appropriate unit of say, feet, yards or metres for the entered measurement.

    I am trying to duplicate this Access form in Excel as a

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Option Group (Excel 2000)

    You have run into one of the big differences between Access controls and MSForms controls. AFAIK, you'll have to check each option button - a lot more work than just getting the value of the option group.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Group (Excel 2000)

    Thanks Hans ---- <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Option Group (Excel 2000)

    Rupert,
    The easiest way I find to use option groups in userforms is with code like the following:
    <pre> Select Case True
    Case OptionButton1
    MsgBox "Opt Button 1 checked"
    Case OptionButton2
    MsgBox "Opt Button 2 checked"
    Case OptionButton3
    MsgBox "Opt Button 3 checked"
    Case Else
    End Select
    </pre>

    Hope that's of some use.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Newbury, Berkshire, England
    Posts
    712
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Option Group (Excel 2000)

    Thanks for that Rory.

    I searched this site and the web for information without much success, however I recently discovered that Excel users don't call them option groups but call them something else, this has obviously hampered my search.

    I thought you might be interested in what I'm up to. I have a form in Access that calculates how much gravel a customer requires based on the length width and depth of the area to be covered plus a conversion factor to convert the volume into a metric tonnage.

    I found this excellent tool which converts Excel into Java script so I'm trying to reproduce my Access form in Excel. I can then convert it into a web page and make it available to people that visit our website.

Posting Permissions

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