str1

I have followed several links here and elsewhere and just can't figure out what I am doing wrong! I select items from a listbox display and then wish to update (2 lines for my testing). The first iteration appears to go through all steps when in debug mode BUT does not actually update the...

Hi, Looking to see who could modify this code so that it works with 1) Excel Tables & 2) More than 2 criteria. Ultimately, I want to display to the user what the filtered content is showing. Function AutoFilter_Criteria(rng As Range) As String'This will allow you to see Auto Filter Criteria...

Because I just found out VBA, I have found and matched the type of the internet is quite good but also want to add two 3D pie charts, as attached. Thanks to the support people for the attached file. Thanks guys so much. Sub GuiMail_NHDT_27062018() Dim objOutlook, objOutlookMsg, cn, rst As...

i have this vba code that ive been working on since last year and i cant seem to run it without excel crashing when i add more data to it. is there any way to tidy this up or make it run more efficiently (faster)? i have 100 rows x 6 columns but sometimes up to 15 columns wide. I just cant...

Hi. 2 years ago we had a spreadsheet written by a former employee to process some template documents based on the content of an Excel sheet. The word document templates have the text "Column A", "Column B" etc. in them and there is some VBA code in a master spreadsheet that populates...

The three subs below work fine in windows 7, unfortunatelyI upgraded to windows 10 a few days ago and now it will not work. I get ?? when I paste. Anyone know how I can fix this. Sub Invoicenumber() PlayTheSound "Speech Disambiguation.wav" Dim clipboard As MSForms.DataObject Dim str1 As...

Below is the code for a userform that im working on. But have str1 & str2 combining but if the user does not select str1 which is a list box it comes up a error. any way around this? Private Sub CommandButton1_Click() Dim RowCount As Long Dim ctl As Control Dim str1 As String Dim str2 As String...

I have a code below that runs all possible combinations for as many columns as i have in sheet 1. the problem is that if i have a certain number of cells that would create more than 1,048,000 (excel line limit) different permutations, then the code will stop even though there could be more...