+ Reply to Thread
Results 1 to 2 of 2

Select active X option button and drop down in a another excel file using macro

  1. #1
    Registered User
    Join Date
    06-25-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Select active X option button and drop down in a another excel file using macro

    Hi All

    I have a excel file with active x option button and drop downs.
    On clicking them they do something(hide some rows in large dataset below).

    I have created a button in another excel file and wish to select these option buttons and then copy the result(filtered rows) in this file.

    Can any1 provide VBA code.

    Regards,
    Vishal

  2. #2
    Registered User
    Join Date
    06-25-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Select active X option button and drop down in a another excel file using macro

    'GOT THE SOLUTION MYSELF - IT's WORKING


    Sheets("Report").Select

    Dim optionButton_BySD As Object
    Set optionButton_BySD = ActiveSheet.OLEObjects("OptionButtonBySD").Object
    BySD.Value = xlOn

+ 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