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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Bill4tektips

    Excel Search Box

    Sorry, Yes "strMySearch As String
  2. Bill4tektips

    Excel Search Box

    When I put this coding in I am getting an error message saying: "Compile Error, Duplicate declaration in current scope". Any ideas
  3. Bill4tektips

    Excel Search Box

    ...strDataShtNm$, strReportShtNm$, strMySearch$, strMyCell$ Dim lngLstDatCol&, lngLstDatRow&, lngReportLstRow&, lngMyFoundCnt& On Error GoTo myEnd '******************************************************************************* strDataShtNm = "BMS Historical Index" 'This is the name of the...
  4. Bill4tektips

    Add a Search box in excel

    Please ignore the thread above, I have resolved the problem
  5. Bill4tektips

    Add a Search box in excel

    I am trying to add a Search Box in excel and I have got some code off the web. The code says: 'Get the string to search for! strMySearch = InputBox("Enter what to search for, below:" & vbLf & vbLf & _ "Note: The search is case sensitive!", _ Space(3) & "Find All", _ "") but how do I add an...
  6. Bill4tektips

    Change Hyperlinks in Word

    MakeItSo: Yes that works perfect. Thank you for your Patience.
  7. Bill4tektips

    Change Hyperlinks in Word

    MakeItSo, Yes that works, BUT it strips out the link words and replaces them with the Hyperlink. So what was "VJ0402A----XAA" becomes "http://syscoshare05/sysco/Data_Sheets/Shared%20Documents/guide_list_datasheets/a_passives/a1_capacitors/vj0402a_xaa.pdf" but we need to show the link word not...
  8. Bill4tektips

    Change Hyperlinks in Word

    Paul, Yes I tried it but I just got "Run-time error '5824' Method 'TextToDisplay' of object 'Hyperlink' failed
  9. Bill4tektips

    Change Hyperlinks in Word

    kjv1611, Thanks for that but when I try it it just comes up with a Microsoft Word box with "O" in it. Even when I try a Test document linked to Google I am getting the same result. I am not a confident user of VBA so any help would be appreciated from anyone.
  10. Bill4tektips

    Change Hyperlinks in Word

    I have a word document with about 700 hyperlinks to various documents within a WSS site and now they have changed the address of the WSS site. I have tried doing a "Show Field Codes" and doing a Find and Replace but when I undo Show Field Codes and hover over the links they are still showing the...
  11. Bill4tektips

    MS Access Query problem

    It works OK on "Open" but when I add criteria to see if there are any "Closed" I am just getting a blank query again. My sql is: This works OK: SELECT Count(tblfeedback.UKProcessNo) AS CountOfUKProcessNo, tblCycle.CycleName FROM tblCycle LEFT JOIN tblfeedback ON tblCycle.CycleName =...
  12. Bill4tektips

    MS Access Query problem

    Thanks dhookam, works OK now
  13. Bill4tektips

    MS Access Query problem

    Sorry for my ignorance but what is the NZ function?
  14. Bill4tektips

    MS Access Query problem

    I have created a query in Access 2003 to count the number of times an article appears in a field. My problem is that I would like to show "0" if nothing is found and not a blank query. Any help would be appreciated.
  15. Bill4tektips

    Excel - Count years

    Can anyone give me the formula for counting Years in Excel 2007? I have a spreadsheet with thousands of entries over the last 10 years and I need to count how many there are per year.
  16. Bill4tektips

    Help with Conditional Formatting

    I am currently working with Excel 2003 and I have a spreadsheet that I have added some code to to change the cell and font colours. If I change the colours to something different from original, I then have to go over all the cells to get them to change to the new colour. Is there any way of...
  17. Bill4tektips

    Close a window on exit from survey

    We have a sharepoint survey in place to supply feedback. My question is, can you Close the window when someone clicks "finish". Our IM are saying it is not possible but I don't believe them.
  18. Bill4tektips

    Count Dates in Excel

    SkipVought, There are cells in the column that contains text as well.
  19. Bill4tektips

    Count Dates in Excel

    I am trying to count dates in 1 Column and put the result in another. When I try =COUNTIF(!$V$2:$V$500,"") I get a rediculous number. Can anyone tell me what I need to put in place of "".
  20. Bill4tektips

    Excel MATCH Query - Help please

    Thanks Skip, works a treat.

Part and Inventory Search

Back
Top