+ Reply to Thread
Results 1 to 5 of 5

Object buttons tied to Frame

  1. #1
    Registered User
    Join Date
    03-12-2007
    Location
    Salem, Oregon
    MS-Off Ver
    2007
    Posts
    25

    Object buttons tied to Frame

    I have a form that has object buttons in a frame. I see that I can only select one or the other of the object buttons that are in a frame. Is it possible to see if no object buttons were selected in a frame and then display a msgbox telling the user that they need to go back and pick a button?
    Last edited by larry711; 02-04-2009 at 02:02 PM.

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Object buttons tied to Frame

    Hello larry711,

    When you say "form", do you mean a worksheet or a VBA UserForm?
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    03-12-2007
    Location
    Salem, Oregon
    MS-Off Ver
    2007
    Posts
    25

    Re: Object buttons tied to Frame

    VBA UserForm

    Attached is an image of the UserForm. You can see there is a Frame around 2 ObjectButtons that is titled Joist. You can only pick one or the other of the ObjectButtons. If the 2 ObjectButtons in the frame are not checked than I am wanting a msgbox to pop up and tell the user they forgot to select the Floor Joist.

    Hopefully that will explain it better.
    Attached Images Attached Images
    Last edited by larry711; 02-03-2009 at 04:39 PM.

  4. #4
    Registered User
    Join Date
    03-12-2007
    Location
    Salem, Oregon
    MS-Off Ver
    2007
    Posts
    25

    Re: Object buttons tied to Frame

    Well I figured out a way to get it to work.

    Please Login or Register  to view this content.

  5. #5
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Object buttons tied to Frame

    Hello larry711,

    Good job! Points to you for figuring that problem out.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1