Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dscs

  1. dscs

    vlookup true finds next larger value that is < lookup value - I need >

    I looked at the link and tried to mess with INDEX / MATCH but I'm still having trouble figuring this out. Here is more detail. Sheet1 (Lic) has Columns: A FirmNum-LicSt-LicExpDate B Firm Num C Firm Name D License State E License # F License Exp Date Sheet2 (Policies) has...
  2. dscs

    vlookup true finds next larger value that is < lookup value - I need >

    Normally VLOOKUP works for me but this time if it can't find an exact match I need it to find the next larger value that is > the lookup value. This is because I am trying to find a row that matches criteria that includes a date and need to find a date that is NOT expired (in the future). I...
  3. dscs

    retrieve current row # from table in word

    I have a table that has 12 rows. The user can click on the 1st column in each row which has the same entry macro in it. I want to be able to determine which row the user came from so that I can clear out that row and all rows till the end of the table, then do other processing. Is there a way...
  4. dscs

    Document_Close() check result of "Do you want to save this doc" dialog

    I am still having trouble with this. I have this setup as a Template so when I double click on the template to create a new document, it has it's own "ThisDocument". Is this correct? The Template has a Validation Module (Macro) that I run in FileSave and in FileSaveAs. If there are no Errors...
  5. dscs

    Document_Close() check result of "Do you want to save this doc" dialog

    I want to be able to check if "Yes" is selected if "Do you want to save this doc" dialog is displayed so that I can do some validation before the document is saved. I can't find how to check for the result of this dialog. Any help would be appreciated.
See more

Part and Inventory Search

Back
Top