Search results for query: *

Sorry, Yes "strMySearch As String

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

Does anyone know if it is possible to create a Search Box in Excel that will return the rows where a searchterm has been found and is capable of finding text within a string? The Search I am using at the moment just works if the complete cell content has been submitted. The code I am using at...

Please ignore the thread above, I have resolved the problem

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...

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

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...

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

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.

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...

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 =...

Thanks dhookam, works OK now

Sorry for my ignorance but what is the NZ function?

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.

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.

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...

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.

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

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 "".

Thanks Skip, works a treat.