mystring

Hi, I have a code from Stackexchange, which is giving a runtime error 13 with 2 of the 3 supporting examples. And, I have not been able to decode why. Sub Example 3 executes but Sub Example 1 and Sub Example 2 fail. Need help in getting it rectified. Function MultiSplitX(ByVal SourceText As...

Good afternoon, I have a range containing a series of values in hh:mm:ss format. If any of these durations exceed 10 minutes (the "10" being contained in a worksheet range ThresholdMinutes), I need to extract the minute section of the string and add it to a string variable MyString - this is...

Hi all, Is it possible to use multiple substrings with inStr? I want to test if the following characters are contained within mystring /, \, ?, %, *. Many Thanks

Hi To simplify my problem in A1 is text Code1, A2 Code2, A3 Code3 etc I want to add a box (possibly a userform) to each cell A1, A2, A3 When the box is selected run a macro which uses the value in the cell and assigns it to a fixed cell elsewhere So if select box over A1 the macro assigns Code1...

Hi, If on same row, and when Col"E"(5) AND Col"R"(18) BOTH equal MYSTRING, I would like the row/cellrange deleted and shiftedup... have tried many variation's with my limited skillset here, and am stuck. Can someone please assist, ThankYou!! Dim Lastrow As Long Dim i As Long Dim MyString...