vba

  1. T

    VBA copy data from multiple excel books to one master workbook

    Hi everyone, I'm trying to copy data from multiple workbooks into one sheet in a master workbook. The workbooks are all stored in a single folder on my desktop along with the master workbook and each contains just one worksheet with the same name. The data in each workbook always starts from...
  2. J

    Export Date from text box in userform to dtpicker in sheet

    Hello! i'm having trouble linking a Date box from a userform to a dtpicker in sheet (because i need the dtpicker with calendar available if the date is to be altered). I have tried this code, but obviously it didn't work...DATE1 is the box in the userform and DTPicker1 (from the development...
  3. A

    VBA : simple IF then multiply by cell value

    Hello, I have a loop with a simple IF, but when i try to multiply the value by the value of another cell it gives the error "Run-time error '13' Type mismatch", could someone help me to correct it? Dim ShSource, ShDest As Worksheet Dim s, cell As Range Set ShSource = Worksheets("Planogram")...
  4. K

    Change Office display language with VBA

    Hi Guys, Small issue yet annoying: I use Excel/VBA in different languages and I'd like a solution where I run a VBA code and display language updates automatically (let's say from English to German). I'm talking about this setting in Excel: I assume it can be done with some API or editing...
  5. J

    Delete Range based on Cell Value and Shift Up

    Hello, I know this has been asked before, but I can't get any of the examples to work for my data. I have data in columns A:D. I need to check column D and if cell is 0 (a result of a formula) then delete A:D of that row and shift up. Then go to next. I only want to delete columns A to D...
  6. W

    VBA to change multiple shapes color in Excel

    I'm beginner in Excel so i'm looking for a way by which if I type yes in a cell it should change color of multiple shapes with same color and if I type NO it should remove the color from those shapes and same goes for other zone entries as show below image. Example: If i type On in G22&25 it...
  7. S

    VBA: Insert row + keep formulas

    Hi all, I already read some threads in this big forum but didn't find what I am looking for. I hope it is ok to ask for some help on this: I have a table and a button to click in A1. If I click this button, a new row shall be inserted below the current active cell including only the above used...
  8. G

    Paste value once

    I have this VBA, however, when I run it, it repeats until I get a runtime error. I am trying to get it to where it pastes the cell's value if it reaches over a text limit. The limit would be 20. This cell(A2) has a card scanned and pastes the values of the card in the cell, instead of clicking a...
  9. A

    VBA - Set Object within If Statement

    So, I created a series of formula on a sheet called Extractor in a workbook called "Processor*". The filename of the workbook "Processor*" will usually vary, having other characters to the right of it. My intention is to copy the range covering all formula I created in a sheet named "Extractor"...
  10. I

    How to extract a single span value from a URL behind an iframe Element?

    I am trying to pull a single value from a work website that refreshes every 5 minutes into an Excel cell. This is the final step in automating an entire workbook filled with a bunch of formulas I created. I am using HTTP Get Request to do this. However, I am having problems pulling the actual...
  11. T

    VBA to assign linked cell

    Please help if you can. The code below is to insert a new line at a row referenced from "uc" then copy the checkbox from a previous row and assigning the correct linked cell for the checkbox. It works upto the line where the linked cell is assigned (row inserted and checkbox created) , the...
  12. W

    ClearContent not working

    I have the following code. It doesn't work. Says, "1004 Error", when implemented. Don't know what have done wrong. Private Sub CommandButton1_Click() Unload Me ThisWorkbook.Sheets("Set Exams-Answers").Range("F21, H23:H26, F31, H33:H36, F41, H43:H46, F51, H53:H56, F61, H63:H66, F71, H73:H76...
  13. B

    Copy and Paste between Workbooks

    Hi Everyone, Please help. I'm wanting to open a closed workbook with a macro, then make the variable, then set the variable, then copy from a separate (already open) workbook and paste into the new set workbook. How do I do this correctly? I keep getting this error. My current vba is the...
  14. N

    Setting a userform combo value from a worksheet cell value

    Hi my first post so sorry, I have a userform with a few combo boxes on it three of them I can update the values but one will not update. Its the only one that triggers some code but I am happy to run the code after. Me.TextBox1.Value = Range("E14").Value ' works fine'...
  15. R

    My pivot table refuses to refresh unless I do it manually

    My pivot table isn't refreshing when I tell it to. Worksheet 1 This sheet has a connection to a SharePoint list. Worksheet 2 This sheet has a table that is similar to Worksheet 1, but has additional columns for calculations. This table is then used as my source for the pivot table, which is...
  16. s_macloskey

    Add +1 to a cell value (plus complications!)

    Good morning all, I have another VBA/AcitveX/Button query that I hope someone can help me to solve! Also please forgive me as I don't 100% know the QUESTION I am asking, I just know the result I am after. (I have also have to redact some of the information becuase of where I work.) Context...
  17. randaubienghoc

    Send bulk email from Excel issues: 1-Attach multiple files with file paths, 2-Copy visible ranges and 3-Add default email signature keeping formats

    Hi everyone, As a new VBA learner, I am seeking for your help to solve these three problems when automatically send Outlook email from Excel. The code is now lacking these improvements. Your support would be highly appreciated. 1. Attach multiple files with file paths by criteria (For same...
  18. B

    VLOOKUP returns nothing / Macro gives me an error message

    Hi I presently have vlookup formulas in numerous cells that are linked to a value entered in cell F18 and a macro is linked to a value in cell H31 I need a macro that will generate a message box if the number entered in cell F18 is not found during the vlookup on Sheet2 which in turn will not...
  19. E

    Find last row of data in column A on a specific sheet, and after that copy data down to that row on another sheet.

    I am almost there I think. But this seems to search for data in all columns on the first sheet. I only want to check column A on Sheet 1. Sub FindLastRow() Dim LastRow As Long With Sheets("Sheet 1") If WorksheetFunction.CountA(.Cells) > 0 Then 'Search for any entry, by searching backwards...
  20. A

    VBA - Max Values and Match

    Hi all, I am stuck on a problem. I have need to insert a vba macro into a sheet for my admin team. I want to find the highest value from a range in one sheet and return the value to another sheet if the adjacent column matches. I also want it to return it to the next blank cell in that row...

Some videos you may like

This Week's Hot Topics

Top