findstring

Morning, I am not sure which part of the code below adds a following digit of 1 each time the same name is entered. If the name exists then a 2 would be added to the end of that name. Should then that name be entered again then this time it is followed by 3,in the future 4,5,6 etc etc Can we...

Hi, -I’m trying to construct a function that will enable auser to filter data by selecting a specific name in a pre-defined cell. I’m using this code: Sub Find_W2() Dim FindString As String Dim Rng As Range FindString = Sheets("Data").Range("I30").Value If Trim(FindString) <>...

Hi. This must be so easy for you guys and gals I tried using........... Findstring = "GUESTCharlieBrown" LeftString = Left(Findstring, 5) GuestString = Findstring - LeftString ..........should have produced "CharlieBrown" What's wrong? Findstring is OK as "GUESTCharlieBrown" LeftString is OK...

Hi guys - I'm trying to store a variable in one module that is created by a user input box and retrieve that variable in another module, but it is not working properly. I've verified that my module is global, not specific to a sheet. The findString variable is not passing for some reason, it...

Hi, the code below puts some data on the clipboard and generates an Email message (adress and subject generated by hyperlink) Would it be possible to paste the clipboard's content into this Email's body Pasting it manually works fine, but some vba code would complete the macro...

Hi all, I am trying to fill cells based on info that is entered and selected in a VBA form. The form contains a textbox to enter a value (newEntry), this value will be copied to the cell at the end of the list in row A of sheet2 ('flightspecific'). The form also contains 4 listboxes that will...