Find or Search Problem

From: VBAvirgin (VBAvirgin.1fj5io_at_excelforum-nospam.com)
Date: 11/11/04 

Date: Wed, 10 Nov 2004 18:04:07 -0600

Thank You Dave, your assistance is much appreciated. I attempted to
record my macro and then went in to edit it, and I think
_that's_where_I_messed_up_.
Looking at your code, I'm trying to decipher where I could put a
wildcard (*) option for the search in the event that the user doesn't
know the correct spelling. As it is, I believe it has to be an exact
match. Would it be a True/False or 0/1 variable?
I thought I was on the right track but obviously I was wrong. Thank you
very much. 

-- 
VBAvirgin
------------------------------------------------------------------------
VBAvirgin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=16327
View this thread: http://www.excelforum.com/showthread.php?threadid=277160

Relevant Pages

  • Re: combo box to be used in Macro
    ... That workbook has to be open, ... Dave, I have now tried your code and it works great. ... link the macro from the file that has opened to the combo box. ... I like to add a button near the dropdown (or ...
    (microsoft.public.excel.programming)
  • Re: Reduce Size of Blank Rows (again)
    ... Dave, I apologize for not being more specific. ... I am using MS Excel 2007. ... wrong) the macro you provided is aimed at reducing the font size of the ... LastRow = Cells.SpecialCells.Row ...
    (microsoft.public.excel.newusers)
  • Re: combo box to be used in Macro
    ... Dave, I have now tried your code and it works great. ... link the macro from the file that has opened to the combo box. ... a combobox from the Control Toolbox toolbar, then you can click on the Design ... I like to add a button near the dropdown (or ...
    (microsoft.public.excel.programming)
  • Re: code failing in hidden rows
    ... kind of related to the macro enabled/disabled problem: ... those cells located within the hidden range do not reflect ... Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: combo box to be used in Macro
    ... Dave, I have now tried your code and it works great. ... link the macro from the file that has opened to the combo box. ... a combobox from the Control Toolbox toolbar, then you can click on the Design ... I like to add a button near the dropdown (or ...
    (microsoft.public.excel.programming)