+ Reply to Thread
Results 1 to 9 of 9

Search for a specific form control button

  1. 11-28-2012, 06:23 AM #1
    gotama
    gotama is offline
    Registered User
    Join Date
    11-28-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Search for a specific form control button

    I have a rather large sheet with lots of embedded form control buttons, each one with a document link. Is there a function (no VBA) to search for a specific
    form control button in excel? for example: i want to find the form control button which is linked to the "application" document.

    thanks in advance and best regards
    Last edited by gotama; 11-28-2012 at 08:11 AM.
    Reply With QuoteRegister To Reply
  2. 11-28-2012, 06:30 AM #2
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Search for a specific form control button

    Is there a function (no VBA) to search for a specific form control button in excel?
    As far as I know the answer is "No".


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved

    If the suggestion helps you, then Click *below to Add Reputation
    Reply With QuoteRegister To Reply
  3. 11-28-2012, 06:36 AM #3
    gotama
    gotama is offline
    Registered User
    Join Date
    11-28-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Search for a specific form control button

    thanks for the fast answer. is the situation different when using ActiveX form controls? is there an "easy" VBA solution to the original problem? thanks and best regards
    Reply With QuoteRegister To Reply
  4. 11-28-2012, 06:54 AM #4
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Search for a specific form control button

    I believe it's possible using VBA but no idea. Please check with Excel Programming / VBA / Macros Forum
    Reply With QuoteRegister To Reply
  5. 11-28-2012, 07:55 AM #5
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Search for a specific form control button

    Please don't post your question in more than one forum as SixthSense seems to suggest, it's against the rules

    yes, using VBA, you can loop through all the forms controls in your worksheet to find the one you want.
    Reply With QuoteRegister To Reply
  6. 11-28-2012, 08:12 AM #6
    gotama
    gotama is offline
    Registered User
    Join Date
    11-28-2012
    Location
    Switzerland
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Search for a specific form control button

    got it. thx
    Reply With QuoteRegister To Reply
  7. 11-28-2012, 10:36 AM #7
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Search for a specific form control button

    @ Kyle123,

    I believe that OP can create a thread in the relevant forum of this site by providing the link to this thread for getting the attention of the experts which will help the OP for getting the issue resolved.

    I don't think so I have instructed the OP against the forum rules because saying
    Please check with Excel Programming / VBA / Macros Forum
    doesn't mean that OP should leave this thread.

    Please correct me if I am wrong
    Reply With QuoteRegister To Reply
  8. 11-28-2012, 10:48 AM #8
    Kyle123
    Kyle123 is offline
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,239

    Re: Search for a specific form control button

    I believe that OP can create a thread in the relevant forum of this site by providing the link to this thread for getting the attention of the experts which will help the OP for getting the issue resolved.
    No, they should only have a single thread per question, otherwise it's against rule 5.

    5. Don't duplicate posts. We have seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one.

    If the op really wanted to they could request that this thread be moved to the relevant forum, but tbh it's probably not worth it since most members look through all the forums anyway

    doesn't mean that OP should leave this thread.
    Of course not, which is why I qualified my statement by saying "seems to suggest"
    Reply With QuoteRegister To Reply
  9. 11-28-2012, 10:56 AM #9
    :) Sixthsense :)
    :) Sixthsense :) is offline
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,788

    Re: Search for a specific form control button

    @ Kyle123,

    I Regret for the inconvenience and misguiding the OP. I will be more cautious in my future post!

    Thanks for correcting my mistake
    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)

Tags for this Thread

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