+ Reply to Thread
Results 1 to 6 of 6

Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

  1. #1
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    Dear Forum,

    I am user form in which I have Four frames:
    Frame1- contains just 2 Option Buttons as Dr and Cr
    Frame2- contains 4 Option Buttons such as BANK , CHEQUE, INTERNET and ECS.

    Frame3- contains Multiple Option Buttons but the Frame3 is meant only for recording the Debit Entries

    Frame4- contains Multiple Option Buttons but the Frame3 is meant only for recording the Credit Entries.

    Now what I want is to prevent the user from clicking the Frame 2 before selecting the Frame1- either Dr or Cr

    and then similarly if the Frame1 either option is selected then he can choose between different Modes..

    Similarly, if he has not selected the Dr or Cr from the First Frame and also no option is selected from the second frame for the Mode then he should not be able to select anything in both the frames..

    The third and fourth frames as mentioned are for recording the Dr and Cr Entries so that I have taken care of by Disabling the Frame for Credit when the Debit option is selected in the first frame however if nothing is selected how to prevent the selection With/Without Greying the Frame..?

    Thanks in advance

    Warm REgards
    e4excel..

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    add this to the commandbutton/macro which executes the userform1:

    Please Login or Register  to view this content.
    Then just change the outcome of a chechbox/optionbutton by enabling the frames again.

    if you still have problems, then please attach your workbook.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  3. #3
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    As of Now I am still making the User Form so its in the Workbook activate Event however later I can always put it on a command button but Disabling the Frames would make it look Grey in the very beginning, is there any other way of preventing a click apart from that..

  4. #4
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    you can disable the checkboxes/optionbuttons within instead. This way the frame will stay unchanged. How else would you like to prevent someone from clicking it? Hide it?

  5. #5
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    Actually I am not so good in VBA so I am not fully aware whether thats the only way of doing that basically my idea was to prevent access to the 2,3 or 4th Frame before the first 2 Frames are selected and I thought by default I had make the second and third and fourth frame disabled then it will not look nice..so thought maybe if theres any other way which I am not aware of..

    Presently, what I am doing is that from the First Frames 2 option buttons, if i have selected the Dr then I disable the Credit Frame and vice-versa but this is only if something is selected in the first place from the first frame but what i wanted is to maintain the order without allowing the user to select the second and third and fourth frame..

    Thanks so thats the only way..right

  6. #6
    Registered User
    Join Date
    11-03-2008
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    2,521

    Re: Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.

    Thanks Bishonen..

    It worked the way I wanted ..

    Great..

    Warm Regards
    e4excel

+ 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