Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2005
    Location
    North Carolina, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    create search feature inside worksheet (excel 2003)

    Does anyone know if I can create a search button with a worksheet that will call on the FIND menu option? To make myself more clear, they will click on the word SEARCH in cell A2 (for example) and the find box will open. If this cannot be done, can excel be created so that the find box opens automatically when a worksheet is opened?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: create search feature inside worksheet (excel 2003)

    Select View | Toolbars | Control Toolbox to display the Control Toolbox.
    Click on the 'Command Button' button, then click on a convenient place in the worksheet.
    Excel will automatically switch to design mode.
    Double click the new button to create code for it.
    The Visual Basic Editor will be activated. Make the code look like this:

    Private Sub CommandButton1_Click()
    Application.Dialogs(xlDialogFormulaFind).Show
    End Sub

    You can change the caption of the command button in the Properties pane on the left hand side; if you don't see it, select View | Properties.
    When you're done, switch back to Excel.
    Click the first button on the Control Toolbox to turn off design mode.
    You can now test the command button.

    Note: make sure that macro security (Tools | Macro | Security is set to Medium, not to High)

  3. #3
    New Lounger
    Join Date
    Sep 2005
    Location
    North Carolina, USA
    Posts
    12
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: create search feature inside worksheet (excel 2003)

    That worked perfect, thank you!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •