+ Reply to Thread
Results 1 to 4 of 4

Guide Line Required For code for option buttons and two list boxes

  1. #1
    Registered User
    Join Date
    02-15-2015
    Location
    Pakistan
    MS-Off Ver
    2010
    Posts
    13

    Guide Line Required For code for option buttons and two list boxes

    I have a problem with my code i have write for option buttons with two list boxes on user form.I have the following objects.

    1. A user Form
    2. Option Buttons having names start from A to C
    3.Two list boxes

    I want that when click on an option button having name alphabetically , the first list box show the list accordingly and when click any item in the first listbox, the second list box shows items accordingly.

    I have write the code but it is not working.
    I have attached the file ,please check and let me help to correct the code.

    HTML Code: 
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: Guide Line Required For code for option buttons and two list boxes

    Please Login or Register  to view this content.
    Also; Chairity is misspelled. Should be Charity.
    Last edited by AlphaFrog; 12-25-2017 at 09:09 AM.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  3. #3
    Registered User
    Join Date
    02-15-2015
    Location
    Pakistan
    MS-Off Ver
    2010
    Posts
    13

    Re: Guide Line Required For code for option buttons and two list boxes

    Thank You Sir ... You are great , the code is working very well.Thaks aagin

  4. #4
    Registered User
    Join Date
    02-15-2015
    Location
    Pakistan
    MS-Off Ver
    2010
    Posts
    13

    Re: Guide Line Required For code for option buttons and two list boxes

    sorry to disturb you again.I have try your code on another vba file.the code work for the first four cases but after that it stop working .please review my file and let me know about my mistake.My latest file is in attachment.Please only check the first sheet(Head of Acc) and ignore the other sheets.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Guide Line Required for Listbox
    By M-ishaq in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2017, 11:33 AM
  2. Printing using Option Buttons and Check Boxes
    By jordan2322 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2012, 05:34 PM
  3. Using IF to code option buttons and list boxes
    By knightrdrx in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-07-2010, 02:38 PM
  4. Linking option buttons in different group boxes
    By opopanax666 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-03-2009, 03:44 AM
  5. Check boxes and Option buttons
    By Chris Martin in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 04:21 AM
  6. option buttons or check boxes
    By meandmyindigo via OfficeKB.com in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-07-2006, 08:00 AM
  7. [SOLVED] option buttons/check boxes are shifting
    By Dan in forum Excel General
    Replies: 2
    Last Post: 07-27-2005, 01:06 PM

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