Questions tagged [excel-vba]

1 votes
0 replies
Hide/show chart placeholders in Excel 2016 (Office 365)
I'm trying to write a macro to hide/show chart placeholders in Excel 2016 (Office 365). I have been using: ActiveWorkbook.DisplayDrawingObjects...
asked 5 months ago
0 votes
2 replies
Error 80010108 when removing web connection after web scrape with VBA
I have the following code to retrieve some data from a web-table. Sub Retrieve_ticker_list() Dim Stockticker As Long...
asked 5 months ago
0 votes
1 replies
CommandButton: Change the buttons bgcolor on click
I'm not at all familiar with Excel. Though I want one function that's pretty complicated to achieve for a first timer as me. I want a button th...
asked 5 months ago
0 votes
2 replies
VBA HTML Pull Listing Info within Links
I have a list of roughly 150 URL's (all to Swappa.com/xxxxxx) that I'd like to pull info from. I have figured out how to pull the first listing...
asked 5 months ago
1 votes
3 replies
How to delete a certain value using vba commands?
I am trying to write a function that automatically deletes the minimum value for a given selection of cells. I know how to find the minimum value...
asked 5 months ago
0 votes
1 replies
Connect MySQL(multiple instances) Database with Excel VBA
I have multiple instances of MySQL installed in my pc which are instance1 & instance2... 1st instance data directory is "C:\MYSQL2\Data", a...
asked 5 months ago
1 votes
2 replies
Conditional copying from another sheet with many statements isn't working
I wanted to save tons of time with a script, so I googled some ways to copy some cells from Excel sheet to another if the statement is true (and...
asked 5 months ago
0 votes
0 replies
Win Defender Long Scan Time on VBA Sleep Lib “kernel32”
Opening an Excel spreadsheet with a macro containing the following cause Windows Defender to take about 10 seconds to scan before the document is...
asked 5 months ago
0 votes
2 replies
I get 1004 error when trying to do a Vlookup/Index-Match in my VBA code, or no results at all
i am working on a long macro to automate a procedure. Unfortunately part of the code is simply not working - i am talking about the lookup part....
asked 5 months ago
0 votes
1 replies
How can I concatenate column B contents if the cell under autofilter identifier is blank?
I am using autofilter to look up a criteria in column A in Sheet1 and return the corresponding value from column B in a table, however I want to...
asked 5 months ago
0 votes
1 replies
Multiple UserForms that trigger each other; UserForm_QueryClose not working as expected
I've got 5 UserForms and some of them activate depending on what the input of the first UserForm is. The first UserForm code is below. Privat...
asked 5 months ago
0 votes
1 replies
Why is FormulaR1C1 putting unwanted brackets into formula?
I'm making a template which will include a formula in every cell of column C, which my colleague can just copy into his working sheets. For that...
asked 5 months ago
-1 votes
1 replies
Macro not dividing as it should - part 2
I posted a question on the Stack site to help with some code because it’s not working exactly the way I want it to. A person kindly responded wit...
asked 5 months ago
-1 votes
1 replies
Generate “duplicate” row if between a date there is more than one month involved
I'm asked to "automatize" some excel tasks regarding medical licenses, what I mainly need right now is to identify if a license is longer than a...
asked 5 months ago
0 votes
0 replies
VBA: Replacing characters like * or &
I'm using code below ThisWorkbook.Sheets(1).Cells(1, 2).EntireColumn.Replace what:="&^%", replacement:="LOL" Data(in cell(2,2)): Sometext&...
asked 5 months ago
0 votes
0 replies
“Unable to get Pivotfields property of the pivottable class” runtierror
I am getting a runtime error" Unable to get pivotFields property of pivottable class" while running the code below. It throws error for each case...
asked 5 months ago
-2 votes
1 replies
Text in a row to a repeating column
I have an excel table where there are part codes in a column and for every part code, there are 3-4 subsections (1100-1400) with information whic...
asked 5 months ago
0 votes
0 replies
VBA Slicer linked to Pivot charts using Data Model( without Pivot Table)
I am trying to control/update few pivot charts ( in Data Model mode) together. First, I created few Charts from "Table1" (Data Model without pi...
asked 5 months ago
0 votes
2 replies
How to save as a workbook that I already have, as a CSV, with a new name given by the user through an inputbox?
I need a macro to save a workbook as a CSV file. The code I already have works well, but in addition, I want the user to be asked to type a new f...
asked 5 months ago
0 votes
1 replies
Excel VBA - convert range with pictures and buttons to HTML
I wrote a function that turns an excel range into HTML for further use in an email body. The problem is that I now want to add pictures and butto...
asked 5 months ago
0 votes
1 replies
Can I reduce this with For/Next Loop in VBA
I feel like there should be a way to increment this with a for next loop. I want to make the shapes visible based on the cell value in C36. Is th...
asked 5 months ago
0 votes
2 replies
Is there any way to apply concat formula for a range with worksheet_change?
Recently I have update the MS office version to Office 365 and I found that one of my excel file doesn't work. It is a simple code to apply conca...
asked 5 months ago
0 votes
1 replies
“Run-time error '424': Object required” in Excel VBA
I want to create an enquiry sheet for users to check their own data. When user inputing some information which fits to the data list, the rest of...
asked 5 months ago
0 votes
0 replies
Excel VBA - Copy from multiple sheets with condition and placing in certain cell in different sheets
I'm new to VBA Excel and I have some code that will go through multiple sheets and copy values in certain range of cells if the criteria are met....
asked 5 months ago
0 votes
2 replies
If I specify hours and a number of days, then copy the hours into the number of days
I'm trying to do something that seems rather simple, but has some issues in execution. Let's say I have a specific number of hours and a number o...
asked 5 months ago