23rd April 2024 22:20
Stackoverflow - Number of High Scored Vba Questions
Top Monthly Stackoverflow Vba Questions
| Question | Score | Views | Answers | Answered |
|---|---|---|---|---|
| Copy from Cell In Excel and copy to next available Line in Text File | 1 | 18 | 3 | True |
| Error 1004 when Filtering Top 10 in Pivot Table with VBA | 1 | 24 | 1 | False |
| Index Match Loop VBA | 1 | 11 | 1 | False |
| Update Cell Value in Filtered Sheet Via VBA | 1 | 27 | 2 | True |
| Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API | 4 | 114 | 1 | True |
| Print Multiple Sheets to PDF using VBA | 3 | 40 | 2 | True |
| Creative way to work with large model (potentially using excel macros/vba) | 2 | 33 | 0 | False |
| Excel VBA - 2 cell values combined always equal 1 | 2 | 38 | 2 | True |
| VBA Excel file is saved next to the newly created folder but not inside | 1 | 56 | 3 | True |
| Rounding up using VBA DateDiff | 1 | 54 | 2 | True |
| Is it possible to change the content of a cell with VBA to make it a formula? | 1 | 51 | 1 | True |
| SHA 256 VBA for Excel without .netframework | 1 | 30 | 1 | True |
| Code excel VBA Userform to enter data into multiple rows | 1 | 30 | 1 | True |
| strange behavior : How elements are inserted in vba arrays? | 1 | 36 | 1 | False |
| Find Duplicate Values and Copy all the duplicate rows into another sheet | 1 | 40 | 1 | True |
| VBA Paste on filtered sheet | 1 | 58 | 2 | True |
| How to pass through a VBA Project Password and remove the VBA Project Password via vb code | 1 | 23 | 0 | False |
| Write xml from VBA | 1 | 52 | 1 | False |
| how do I save a text files by group using the Area Code of the Account Number? | 1 | 33 | 1 | True |
| Excel VBA Macro Axis Font Formatting | 1 | 44 | 1 | True |
| Extract data from multiple sheets into one sheet using array VBA | 2 | 43 | 2 | True |
| VBA to copy all top rows from files in the same folder and merge into 1 file | 2 | 45 | 1 | True |
| Adding multiple columns all at once | 2 | 51 | 2 | True |
| Vlookup Function Excel VBA | 2 | 42 | 1 | True |
| Excel VBA Chart Not Plotting Second Series | 2 | 26 | 1 | True |
| Excel VBA Macro Show / Hide Chart Title | 1 | 52 | 1 | False |
| How to save as string each item selected in listbox | 1 | 53 | 1 | True |
| VBA works only once | 1 | 61 | 3 | True |
| Vlookup Range Without Getting #NA Value if is Not Found | 1 | 79 | 2 | True |
| VBA Selecting Multiple Noncontiguous Table Columns by Name | 1 | 39 | 2 | True |
| Table Update from a form using VBA | 1 | 55 | 1 | True |
| Change Value on a Cells if 2 criteria is met | 1 | 48 | 2 | True |
| Save pdf file to sub folder based on a cell value | 2 | 81 | 1 | True |
| How to Change Value on Certain Cells Coppied from another Cells with VBA | 1 | 34 | 1 | True |
| Extracting text from a merged range in multiple sheets | 1 | 64 | 3 | True |
| Excel VBA Evaluate function | 2 | 63 | 1 | True |
| Lookup last used primary key then adding one | 1 | 70 | 2 | True |
| If Cell contains specific text in col A copy cell from Col C into Col F stacked | 1 | 36 | 3 | True |
| Removing Duplicate Legend Entries using VBA | 1 | 25 | 0 | False |
| How can I copy a date from excel to powerpoint through vba and forcing english format regardless of local formatting? | 1 | 41 | 1 | False |
| VBA macro does not recognize sheets in workbook | 1 | 43 | 2 | True |
| Variant holding 2 pointers | 4 | 110 | 0 | False |
| Excel: =IF(ISBLANK with Dynamic Data | 1 | 66 | 1 | True |
| Copy and Paste with Specialcells | 1 | 37 | 1 | True |
| Deleting tabs from a TabControl with VBA /MS Access | 1 | 101 | 1 | True |
| VBA - detect if user is running on 365 | 1 | 48 | 0 | False |
| Save Excel Sheet to a folder as PDF with filename based on cell value + Current Month name | 1 | 44 | 1 | True |
| EXCEL VBA Runtime Error 1004 "Application-defined or Object-defined error" | 2 | 42 | 1 | True |
| microsoft from 2.0 controler textbox to retrieve the hindi content in vba | 1 | 38 | 0 | False |
| VBA macro not able to call API second time | 1 | 59 | 1 | True |
| Copying several columns from one worksheet to another dependent on a criteria | 1 | 28 | 0 | False |
| Access sub to update a single record always updating the first record in a table | 1 | 58 | 2 | True |
| Is there a way to convert a VBA module into a VBA string? | 1 | 67 | 2 | True |
| How to create a "sub-error handler" in procedure? | 1 | 38 | 1 | True |
| Edit Excel Cell with ActiveX | 1 | 27 | 1 | True |
| Vlookup Range of Data to Another Sheet Using VBA | 2 | 66 | 1 | True |
| VBA to create Multi level Bill of Material from Single Level Bill Of Material | 1 | 43 | 0 | False |
| Concatenate Two Cells Into One Cell Everytime There Are New Data Row Added | 1 | 67 | 2 | True |
| Efficient way to compare huge file set in excel for non technical user | 1 | 12 | 0 | False |
| Use CurrentRegion To Find Table Headers | 1 | 45 | 2 | True |
| Can 64-bit Excel VBA use VB6 ActiveX? | 2 | 64 | 0 | False |
| Excel cell validation set by vba sets incorrect data range | 1 | 28 | 1 | True |
| UFT .Highlight is working from repository but not from Action | 1 | 21 | 0 | False |
| Copy/Paste cell value ony after drop-down list trigger | 1 | 47 | 1 | True |
| Add New Column in Excel pulling one word from Descriptive Cell | 1 | 20 | 0 | False |
| Printing labels on Brother QL-800 printer from Excel VBA | 1 | 36 | 1 | True |
| How to dynamically set the object source to a subform | 1 | 44 | 1 | True |
| VBA Runtime error 440 Shapes.Count Failed | 1 | 39 | 1 | False |
| VBA Word changing command button properties prevents closing without save prompt | 1 | 40 | 1 | False |
| Is there a way to set an open workbook as a source without having the file name? | 1 | 81 | 2 | True |
| How can i obtain the row number of the first item in a filtered table with VBA Excel | 1 | 63 | 4 | True |
| VBA Run-Time error '424': Object required on Range-type variable | 1 | 28 | 1 | False |
| MailEnvelope retaining To and BCC information | 1 | 42 | 1 | True |
| Making the same increasing number appear in every sheet of excel | 1 | 58 | 2 | True |
| Code Has Suddenly Failed to Insert Text Into Website Textbox | 1 | 173 | 2 | True |
| UserForm Close Event Hangs | 1 | 42 | 1 | True |
| How to compile data based on fixed column values | 1 | 38 | 1 | False |
| Excel VBA Custom Sort | 2 | 49 | 2 | True |
| Error Code 400 sending emails from VBA using the MS Graph API | 2 | 76 | 1 | True |
| Unable to input any data in input field in selenium | 1 | 37 | 1 | False |
| MS Access - Updating Combobox Selection after another Combobox's Selection in Form | 1 | 32 | 2 | True |
| How do i select multiple, NON connected cells as a range with the offset function in VBA? | 1 | 30 | 2 | True |
| Excel VBA code is clearing Pivot Table Filter | 1 | 21 | 0 | False |
| Format excel report needs performance improvement | 1 | 50 | 2 | True |
| Access Form AllowEdits = True does not enable editing of the form | 1 | 23 | 1 | True |
| MS Access form; only lock the controls when value is 0 and not when the value is empty | 1 | 39 | 1 | True |
| Run Excel Macro using Power Automate Desktop | 1 | 52 | 0 | False |
| how to operate on double-zeroed-indexed array? | 1 | 61 | 2 | False |
| Lifetime of temporary internal variables in VBA? | 4 | 78 | 0 | False |
| I need to replace a square bracketed range with a variable range | 1 | 36 | 2 | True |
| Sql query not return data | 1 | 50 | 2 | True |
| Excel VBA clearcontents wont work if multiple cells are selected and removed | 1 | 46 | 2 | True |
| Having issues with VBA Goal Seek - can't get the macro to work | 1 | 61 | 1 | True |
| Runtime Error 1004 - when range input uses double digit cell | 2 | 53 | 2 | True |
| Problems looping through Access query results and importing into excel spreadsheet | 1 | 31 | 0 | False |
| VBA Error 430 but fixed when I modify the VBA program | 1 | 33 | 0 | False |
| Accelerating VBA macro (now using For... and If...) | 1 | 87 | 5 | True |
| Excel WorksheetFunction.Vlookup is giving inconsistent results | 2 | 83 | 2 | False |
| code says run time error 424 what is wrong | 1 | 46 | 1 | False |
| VBA collect consecutive similar cells in the row | 1 | 53 | 2 | True |
Top Weekly Stackoverflow Vba Questions
| Question | Score | Views | Answers | Answered |
|---|---|---|---|---|
| Copy from Cell In Excel and copy to next available Line in Text File | 1 | 18 | 3 | True |
| Index Match Loop VBA | 1 | 11 | 1 | False |
| Update Cell Value in Filtered Sheet Via VBA | 1 | 27 | 2 | True |
| Error 1004 when Filtering Top 10 in Pivot Table with VBA | 1 | 24 | 1 | False |
| Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API | 4 | 114 | 1 | True |
| Print Multiple Sheets to PDF using VBA | 3 | 40 | 2 | True |
| Creative way to work with large model (potentially using excel macros/vba) | 2 | 33 | 0 | False |
| Excel VBA - 2 cell values combined always equal 1 | 2 | 38 | 2 | True |
| VBA Excel file is saved next to the newly created folder but not inside | 1 | 56 | 3 | True |
| VBA Paste on filtered sheet | 1 | 58 | 2 | True |
| Write xml from VBA | 1 | 52 | 1 | False |
| Is it possible to change the content of a cell with VBA to make it a formula? | 1 | 51 | 1 | True |
| How to pass through a VBA Project Password and remove the VBA Project Password via vb code | 1 | 23 | 0 | False |
| Rounding up using VBA DateDiff | 1 | 54 | 2 | True |
| Find Duplicate Values and Copy all the duplicate rows into another sheet | 1 | 40 | 1 | True |
| SHA 256 VBA for Excel without .netframework | 1 | 30 | 1 | True |
| Code excel VBA Userform to enter data into multiple rows | 1 | 30 | 1 | True |
| strange behavior : How elements are inserted in vba arrays? | 1 | 36 | 1 | False |
| Excel VBA Macro Axis Font Formatting | 1 | 44 | 1 | True |
| how do I save a text files by group using the Area Code of the Account Number? | 1 | 33 | 1 | True |
| Vlookup Function Excel VBA | 2 | 42 | 1 | True |
| Adding multiple columns all at once | 2 | 51 | 2 | True |
| VBA to copy all top rows from files in the same folder and merge into 1 file | 2 | 45 | 1 | True |
| Extract data from multiple sheets into one sheet using array VBA | 2 | 43 | 2 | True |
| Excel VBA Chart Not Plotting Second Series | 2 | 26 | 1 | True |
| Excel VBA Macro Show / Hide Chart Title | 1 | 52 | 1 | False |
| VBA works only once | 1 | 61 | 3 | True |
| Vlookup Range Without Getting #NA Value if is Not Found | 1 | 79 | 2 | True |
| VBA Selecting Multiple Noncontiguous Table Columns by Name | 1 | 39 | 2 | True |
| Change Value on a Cells if 2 criteria is met | 1 | 48 | 2 | True |
| Table Update from a form using VBA | 1 | 55 | 1 | True |
| Save pdf file to sub folder based on a cell value | 2 | 81 | 1 | True |
| How to Change Value on Certain Cells Coppied from another Cells with VBA | 1 | 34 | 1 | True |
| Extracting text from a merged range in multiple sheets | 1 | 64 | 3 | True |
| Excel VBA Evaluate function | 2 | 63 | 1 | True |
| Removing Duplicate Legend Entries using VBA | 1 | 25 | 0 | False |
| If Cell contains specific text in col A copy cell from Col C into Col F stacked | 1 | 36 | 3 | True |
| Lookup last used primary key then adding one | 1 | 70 | 2 | True |
| VBA macro does not recognize sheets in workbook | 1 | 43 | 2 | True |
| How can I copy a date from excel to powerpoint through vba and forcing english format regardless of local formatting? | 1 | 41 | 1 | False |
| Variant holding 2 pointers | 4 | 106 | 0 | False |
| Copy and Paste with Specialcells | 1 | 37 | 1 | True |
| Deleting tabs from a TabControl with VBA /MS Access | 1 | 97 | 1 | True |
| Save Excel Sheet to a folder as PDF with filename based on cell value + Current Month name | 1 | 44 | 1 | True |
| VBA - detect if user is running on 365 | 1 | 48 | 0 | False |
| Excel: =IF(ISBLANK with Dynamic Data | 1 | 65 | 1 | True |
| EXCEL VBA Runtime Error 1004 "Application-defined or Object-defined error" | 2 | 38 | 1 | True |
| Copying several columns from one worksheet to another dependent on a criteria | 1 | 26 | 0 | False |
| microsoft from 2.0 controler textbox to retrieve the hindi content in vba | 1 | 37 | 0 | False |
| VBA macro not able to call API second time | 1 | 59 | 1 | True |
Top Daily Stackoverflow Vba Questions
| Question | Score | Views | Answers | Answered |
|---|---|---|---|---|
| Index Match Loop VBA | 1 | 11 | 1 | False |
| Update Cell Value in Filtered Sheet Via VBA | 1 | 27 | 2 | True |
| Error 1004 when Filtering Top 10 in Pivot Table with VBA | 1 | 24 | 1 | False |
| Copy from Cell In Excel and copy to next available Line in Text File | 1 | 18 | 3 | True |
| Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API | 4 | 72 | 0 | False |
| Print Multiple Sheets to PDF using VBA | 3 | 36 | 2 | True |
| Excel VBA - 2 cell values combined always equal 1 | 2 | 34 | 2 | True |
| Creative way to work with large model (potentially using excel macros/vba) | 2 | 27 | 0 | False |
| Write xml from VBA | 1 | 49 | 1 | False |
| how do I save a text files by group using the Area Code of the Account Number? | 1 | 33 | 1 | True |
| strange behavior : How elements are inserted in vba arrays? | 1 | 31 | 1 | False |
| VBA Excel file is saved next to the newly created folder but not inside | 1 | 54 | 3 | True |
| Vlookup Function Excel VBA | 2 | 41 | 1 | True |
| Adding multiple columns all at once | 1 | 45 | 2 | True |
| VBA to copy all top rows from files in the same folder and merge into 1 file | 1 | 39 | 2 | True |
| Extract data from multiple sheets into one sheet using array VBA | 1 | 32 | 1 | True |
| Excel VBA Chart Not Plotting Second Series | 1 | 23 | 1 | True |
| VBA Selecting Multiple Noncontiguous Table Columns by Name | 1 | 37 | 2 | True |
| Vlookup Range Without Getting #NA Value if is Not Found | 1 | 61 | 2 | True |
| VBA works only once | 1 | 51 | 3 | True |
| Change Value on a Cells if 2 criteria is met | 1 | 47 | 2 | True |
| Table Update from a form using VBA | 1 | 38 | 1 | True |
| Save pdf file to sub folder based on a cell value | 2 | 58 | 1 | True |
| How to Change Value on Certain Cells Coppied from another Cells with VBA | 1 | 33 | 1 | True |
| Extracting text from a merged range in multiple sheets | 1 | 52 | 3 | True |
| Excel VBA Evaluate function | 2 | 44 | 1 | True |
| Removing Duplicate Legend Entries using VBA | 1 | 18 | 0 | False |
| If Cell contains specific text in col A copy cell from Col C into Col F stacked | 1 | 26 | 3 | True |
| VBA macro does not recognize sheets in workbook | 1 | 36 | 2 | True |
| Lookup last used primary key then adding one | 1 | 59 | 2 | True |
| Variant holding 2 pointers | 1 | 47 | 0 | False |
| Excel: =IF(ISBLANK with Dynamic Data | 1 | 54 | 1 | True |
| Copy and Paste with Specialcells | 1 | 32 | 1 | True |
| Save Excel Sheet to a folder as PDF with filename based on cell value + Current Month name | 1 | 38 | 1 | True |
| VBA - detect if user is running on 365 | 1 | 42 | 0 | False |
| EXCEL VBA Runtime Error 1004 "Application-defined or Object-defined error" | 2 | 35 | 1 | True |
| microsoft from 2.0 controler textbox to retrieve the hindi content in vba | 1 | 29 | 0 | False |
| VBA macro not able to call API second time | 1 | 52 | 1 | True |
| Copying several columns from one worksheet to another dependent on a criteria | 1 | 25 | 0 | False |
| Access sub to update a single record always updating the first record in a table | 1 | 48 | 2 | True |
| Is there a way to convert a VBA module into a VBA string? | 1 | 58 | 2 | True |
| How to create a "sub-error handler" in procedure? | 1 | 35 | 1 | True |
| Edit Excel Cell with ActiveX | 1 | 25 | 1 | True |
| Vlookup Range of Data to Another Sheet Using VBA | 2 | 48 | 1 | True |
| Concatenate Two Cells Into One Cell Everytime There Are New Data Row Added | 1 | 55 | 2 | True |
| VBA to create Multi level Bill of Material from Single Level Bill Of Material | 1 | 35 | 0 | False |
| Efficient way to compare huge file set in excel for non technical user | 1 | 12 | 0 | False |
| Excel cell validation set by vba sets incorrect data range | 1 | 25 | 1 | True |
| Can 64-bit Excel VBA use VB6 ActiveX? | 1 | 42 | 1 | False |
| Copy/Paste cell value ony after drop-down list trigger | 1 | 32 | 1 | True |
Top Yearly Stackoverflow Vba Questions
| Question | Score | Views | Answers | Answered |
|---|---|---|---|---|
| Excel VBA Macro Axis Font Formatting | 1 | 44 | 1 | True |
| Copy from Cell In Excel and copy to next available Line in Text File | 1 | 18 | 3 | True |
| Monitor Scaling Issue for Moveable Access Form using MoveWindow win32 API | 4 | 114 | 1 | True |
| Print Multiple Sheets to PDF using VBA | 3 | 40 | 2 | True |
| Creative way to work with large model (potentially using excel macros/vba) | 2 | 33 | 0 | False |
| VBA to copy all top rows from files in the same folder and merge into 1 file | 2 | 45 | 1 | True |
| Adding multiple columns all at once | 2 | 51 | 2 | True |
| Excel VBA - 2 cell values combined always equal 1 | 2 | 38 | 2 | True |
| Vlookup Function Excel VBA | 2 | 42 | 1 | True |
| Extract data from multiple sheets into one sheet using array VBA | 2 | 43 | 2 | True |
| Find Duplicate Values and Copy all the duplicate rows into another sheet | 1 | 40 | 1 | True |
| Rounding up using VBA DateDiff | 1 | 54 | 2 | True |
| VBA Excel file is saved next to the newly created folder but not inside | 1 | 56 | 3 | True |
| how do I save a text files by group using the Area Code of the Account Number? | 1 | 33 | 1 | True |
| Variant holding 2 pointers | 4 | 110 | 0 | False |
| Excel VBA Chart Not Plotting Second Series | 2 | 26 | 1 | True |
| VBA Read URL fails with "An error occured in the secure channel support" after website move to TLS1.3 | 2 | 44 | 0 | False |
| VBA Selecting Multiple Noncontiguous Table Columns by Name | 1 | 39 | 2 | True |
| Vlookup Range Without Getting #NA Value if is Not Found | 1 | 79 | 2 | True |
| VBA works only once | 1 | 61 | 3 | True |
| Change Value on a Cells if 2 criteria is met | 1 | 48 | 2 | True |
| Table Update from a form using VBA | 1 | 55 | 1 | True |
| VBA for Excel - How to get specific Data from Website (HTML)? | 1 | 90 | 2 | True |
| How to change value on certain cells copied from another cell with VBA | 1 | 34 | 1 | True |
| Copy rows of an excel table, excluding header when number of rows varies | 1 | 44 | 2 | True |
| Save pdf file to sub folder based on a cell value | 2 | 81 | 1 | True |
| Extracting text from a merged range in multiple sheets | 1 | 64 | 3 | True |
| Combine non unique worksheets | 1 | 73 | 3 | True |
| Excel User Input a Number and Goes to Matching Number in Another Worksheet | 1 | 48 | 2 | True |
| VBA Excel loop for copy multiple separate cells at once | 1 | 56 | 2 | True |
| Excel VBA Evaluate function | 2 | 63 | 1 | True |
| Excel sheets from List | 1 | 78 | 1 | True |
| VBA macro does not recognize sheets in workbook | 1 | 43 | 2 | True |
| Concatenate Two Cells Into One Cell Everytime There Are New Data Row Added | 1 | 67 | 2 | True |
| EXCEL VBA Runtime Error 1004 "Application-defined or Object-defined error" | 2 | 42 | 1 | True |
| VBA macro not able to call API second time | 1 | 59 | 1 | True |
| Is there a way to convert a VBA module into a VBA string? | 1 | 67 | 2 | True |
| Can 64-bit Excel VBA use VB6 ActiveX? | 2 | 64 | 0 | False |
| Vlookup Range of Data to Another Sheet Using VBA | 2 | 66 | 1 | True |
| Add sequential numbers to Cell range | 1 | 69 | 2 | True |
| Excel cell validation set by vba sets incorrect data range | 1 | 28 | 1 | True |
| VBA storing an ArrayList in Dictionary | 1 | 72 | 2 | True |
| Printing labels on Brother QL-800 printer from Excel VBA | 1 | 36 | 1 | True |
| Excel WorksheetFunction.Vlookup is giving inconsistent results | 2 | 83 | 2 | False |
| Code Has Suddenly Failed to Insert Text Into Website Textbox | 1 | 173 | 2 | True |
| Making the same increasing number appear in every sheet of excel | 1 | 58 | 2 | True |
| Error Code 400 sending emails from VBA using the MS Graph API | 2 | 76 | 1 | True |
| Excel VBA Custom Sort | 2 | 49 | 2 | True |
| Finding last column of a found row with VBA | 1 | 43 | 2 | True |
| Adding a second change event to existing Worksheet Change code | 1 | 78 | 2 | True |