+ Reply to Thread
Results 1 to 7 of 7

userform with frame and option buttons

  1. 04-25-2008, 01:29 AM #1
    erich_7719
    erich_7719 is offline
    Registered User
    Join Date
    04-09-2008
    Location
    Michigan, USA
    Posts
    62

    userform with frame and option buttons

    I tried to find the answer in other posts first and maybe I overlooked it. I don't know mutch about using the option buttons.

    So ...
    the form has...

    -a text box for the product name
    -3 option buttons in a frame for the types of containers

    How do I word the code to determan which button is active, and to assign each button its value?
    Reply With QuoteRegister To Reply
  2. 04-25-2008, 02:30 AM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Can you be a bit more specific with what your form does, maybe attach an example?
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  3. 04-25-2008, 09:56 AM #3
    erich_7719
    erich_7719 is offline
    Registered User
    Join Date
    04-09-2008
    Location
    Michigan, USA
    Posts
    62
    Hopefully the example will explain it better.

    The text box for the Weight is working right in the non-example.

    Oh...The third option button is so I can have the product and the weight (on another Table) be deleted at the same time.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 04-25-2008, 10:46 AM #4
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    I'm not sure what you re doing exactly, but a ComboBox to select from would be much more efficient.

    i think your idea leaves a lot to chance, you rel on the user selecting the correct cell to populate TextBox1 wit an address. If you really wan his you don't need the textBox, simply

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  5. 04-25-2008, 11:36 AM #5
    erich_7719
    erich_7719 is offline
    Registered User
    Join Date
    04-09-2008
    Location
    Michigan, USA
    Posts
    62
    This is something like what I am wanting, but I can't quite figure it out.
    Please Login or Register  to view this content.
    Thank you for your help in my confusion.
    Reply With QuoteRegister To Reply
  6. 04-25-2008, 11:43 AM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Try

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  7. 04-25-2008, 11:57 AM #7
    erich_7719
    erich_7719 is offline
    Registered User
    Join Date
    04-09-2008
    Location
    Michigan, USA
    Posts
    62
    Thank you that worked.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1