vba

  1. T

    Running graph-creating macro through multiple rows

    Hey, I dont and cant use VBA nor any other programming language at all but need this thing for my work, so sorry in advance for my phrasing; I created a macro simply through "record macro" button in excel. The pourpose of it is to create a simple graph out of one row of a table. Now I need...
  2. M

    How to copy a column to another column in another workbook according to today's date using VBA?

    I'm totally new to VBA. I want to build a code that can DAILY copy values of column B in a workbook named by today's date (picture 1) to sheet 1 in another workbook named Credit (picture 2) in the column corresponding to today's date. The column headers of the file Credit is the days of every...
  3. D

    VBA code or other solution to color cells white if they contain no data

    Hello everybody, I am currently facing an issue. I would like to create a code that colors my cells with a complete white background and no borders if they contain no data (numbers, letters, signs or anything else). Please see the following snip: For the blank cells from Cell A135-D135 and...
  4. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  5. A

    Timer in VBA - Stop, Start, Pause and Reset

    Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub btnStart_Click() CmdStop = False Paused = False Start = Now() ' Set start time. btnPause.Enabled = True btnStop.Enabled = True btnReset.Enabled =...
  6. D

    Copy pasting cells from one worksheet to another in Excel

    Hello everybody, I am currently having some problems with my excel spreadsheet. In short, I have a list of materials in my "Order form" sheet 1 and I have all the hard data in a hidden sheet called "Products" (sheet 2). Currently, I have just set the fields in my "Order form" sheet = the...
  7. S

    Copy range from workbook and paste it into a closed workbook

    I'm wanting to log user inputs from one spreadsheet to another one that would be closed. It just needs to paste to the next available row. I've scoured the internet and am having trouble finding something that works. The below code will open the workbook but isn't copy/pasting the info or...
  8. D

    Conditional formatting (extended? or vba code?) for entire row

    Hello everybody, I am currently managing a worksheet containing a stock overview, which looks like this: I have made two conditional formatting rules which assert under my "Antal" (meaning Quantity) column that if the number is below or equal to 0 the color should be red and if the color is...
  9. C

    Keep UserForm on Top (Office365, 64-bit)

    Hello All, As the title says, I have around 7 UserForms and I want them to be always on top of ALL windows once opened. Currently, I had set the ShowModal to False on the UserForm properties. My issue is when I minimize Excel, it also minimize the UserForm. Details of the file: • Office 365 •...
  10. D

    Run-time error "53": File not found - How to fix?

    Hello everybody, I am currently running an excel file in which I have created an order form that people can fill out with their information and the products that they would like to order. I am using a VBA code (please let me know in the comments if you want me to attach the entire code)...
  11. M

    Need help with macro

    Hello! I am trying to use the below macro to flag an error message when a date range exceeds 7 days. I have used the below which only applies to the first cell in the column. What must I do to apply it to the whole column, I have 350 rows. Just to let you know column K is a calculation of...
  12. M

    Copied Date Data is NOT a Number

    Hi, How do I copy date data retaining its number format? Dim Sourceworkbook1 As Workbook Set Sourceworkbook1 = Workbooks.Open("[File path & name]") Application.ScreenUpdating = False Sourceworkbook1.Sheets("[tab name]").Copy After:=ThisWorkbook.Sheets("[tabname]") I have written a matching...
  13. D

    Import range from from excel files in a folder and save as based on a cell value

    Hello everyone, I have a few excel (.xlsm) files in a folder made for each experiment (PhD student) based on an older version master template excel file. Now that I have updated the master template to include further analysis, I would like to have all the previous experimental data to be...
  14. K

    Find Synonyms for a word in MS Excel using VBA

    Dear VBA experts, i have set of words in column A, i need a excel VBA macro to get the meaning for each word in column A on corresponding B column. Please help me with a code. Thanks in advance ! Regards, Karthikha.
  15. A

    Extract Data from a Table with Macro/VBA

    Hi All, I Have a table and Macro code below. What I want to do is: -Copy all numbers to a worksheet named "TEST" (Helper worksheet) -Criteria are: 1. If Header of Column is "Total" - End VBA 2. Start with Range(E2) then if value is "-" or if Value of Cells(activerow, 2) = blank then select next...
  16. K

    Find Synonyms for a word in MS Excel using VBA

    i have set of words in column A, i need a excel VBA macro to get the meaning for each word in column A on corresponding B column.
  17. M

    VBA to display record ID in Textbox within a Form

    Hello! Hoping this is a simple question. Is there a way to display the ID (primary key, just the default autonumber) of a Record entry on a form in a textbox? I am currently able to display the Record Number with the following code which works great but i'm looking for the Primary ID also...
  18. M

    copying images from one folder and pasting in another based on schedule in excel file

    Hi guys Hope you all well and safe from Covid. while in lockdown im hoping someone can assist me with this query. i had a macro created whereby image product code is listed in Column A, Column B lists the location of that particular image and Column C displays the location of where i want...
  19. C

    How to create a chart graph that pulls data from two workbooks on each worksheet that have the same name

    Hello excel world. I am in your debt. I need your help if you are willing to help me... I am sorry for the inconvenience cause in the pass... Please read my concerns: #1 I have "2" workbooks name: Unemployment_Rate GDP_Annual_Growth_Rate_% #2 in "Unemployment_Rate" workbook. I have "1"...
  20. F

    (Word VBA) set CellAlignVerticalTop for every tables in selection

    Hi, I want to create VBA that helps me set Word Table format as follow: - align each table to center of the document - this one work fine. - set text format in each cells Align Top Left (this is identical to select Table and go to Table Tools > Layout > click Align Top Left at Alignment area.)...

Some videos you may like

This Week's Hot Topics

Top