excel

  1. C

    Combobox value to display adjacent cells in textboxes

    I have the following code from a previous project i worked on and tried to modify it to find the value of a cell in column A and if the value matches, then display the two adjacent cell values in the two textboxes i have on the user form: Dim i As Integer Dim arrIn As Variant Dim arrOut() Dim j...
  2. W

    VBA Code to get distinct count with muliple criteria

    Can some one help me with a VBA code that gives distinct count of data in in "I" Column of sheet1 (dynamic) after filtering "Temp" and "Tem" in A column and "MX" in E column. I have a code as below which gives distinct count from "I" column but not able to add the filters. Would be great if get...
  3. S

    Help with Find command - Match names on multiple tabs

    Hi there, new member here - self taught excel vba so still a beginner and hoping someone may be able to help point me in the right direction or be able to offer code which could work with what I need. I am working on a spreadsheet that has to be completed quarterly so am looking to automate a...
  4. S

    Ambiguous name detected unable to run code

    Private Const AuditSheets As String = "|Sheet3|" ' Must start and end with the "|" character Private Const AuditRange As String = "$C$2:$G$32" ' Change the tracked range as necessary Private Const LifeSpan As Double = 0.0013 ' 24 hour lifespan Private NextTime As Date Private Sub Workbook_Open()...
  5. G

    Excel VBA:Paste multiple times

    Hi All, I am new to Excel Macro and to this forum. I am trying to write a macro to copy a range multiple times. Please correct me if I am wrong. Sub Macro1() Dim x As String Dim x1 As String Dim x2 As String Dim p, q As Integer Range("A1").Activate p = 1...
  6. M

    VBA Code to copy a cell when a match is found

    I am kinda new to VBA and have been using VBA to increase my efficiency and to analyze data faster so my VBA coding skills are not so great. This particular problem has me a bit lost as I have tried googling to get some code that I can modify but can't seem to find anything that does what I...
  7. G

    Count consecutive negative numbers

    I am looking for a formula or vba, whichever is easier, where if the value in the row is negative, it will count until the next 0 or positive number, for the whole column. An example is below. I searched and couldn't find the exact thing I was looking for. Any help will be greatly appreciated...
  8. S

    Run-time error '1004':[ Expression.Error] The name 'Source' wasn't recognized. Make sure it's spelled correctly

    I'm trying to add Power Query code to VBA but I'm getting an error that the "Source" wasn't recognized. The name 'Source' wasn't recognized. Make sure it's spelled correctly. I've been trying to do different spellings or playing with the commas but I'm still getting that error. Would need a...
  9. F

    Take data from specific worksheets and place them in a master workbook

    Hello, I have a folder with many excel files arranged on date. Every file has a couple of worksheets where data is stored. Lets say I have this in my folder: 210520.xlsx 220520.xlsx 230520.xlsx Every file has a couple of worksheets. One of them is called Data_New. Is it possible to take the...
  10. Y

    ComboBox and Date

    I wondering how can i formulate this textbox status to display textboxStatus to blank when combo box is closed and when combobox1 is in "Open" then TextBoxDate.Value - DateNow. if ComboBox1 = "Open" then TextBoxStatus = txtBoxDate.Value - DateNow Else if ComboBox1 = "Closed" then...
  11. A

    Excel freezes while running macro

    Hello all I have a module which gets data from a web API and then copies that data to the excel sheet, while this macro is running, all the other excel sheets freezes for a couple of seconds. Any help to optimize this code would be greatly appreciated. I just want this macro to run in the...
  12. K

    Issue with Shared Workbook (not co author)

    I have a shared excel spreadsheet (no co-author as my work is still in the dark ages) My issue is I can’t fully edit it on a computer other than the one I first created it on and neither can the authors I added I can share/unshare and edit as I please on the original computer, but If I go to a...
  13. G

    Macro for Convert DOT to Comma and Comma to DOT

    Dear Friends, Need help from you, i am trying to convert Dot to comma and when i covert the value decimal points are not appearing example attached and given below as well. When the third decimal point if is zero then i am not getting the third decimal after i convert example below. Input ...
  14. R

    Finding and returning one of multiple potential values from a range

    Hi Everyone Unfortunately I cannot download XL2BB (work IT security), so I have had to use the below screenshot. I am working on a large formula and have got stuck on one component. For ease, I have broken out this component and simplified it as follows: I have 5 values: MYTPP; MAPTM; EGPSD...
  15. S

    Insert text from Excel into word document - after bookmark

    Hello, I hope you all are well. I want to insert text from an excel-cell (B16) into a word document. The text should be inserted after the respective bookmark ("B1"). I have written the following code: Sub InsertAfterBookmark() Dim objWord As Object Dim ws As Worksheet Set ws =...
  16. R

    Import XML via VBA

    I am trying to modify a filedialog I currently use to import xml files. I would like to change from the folder selection to individual file selection, but I cannot seem to get it to work for me. If possible could somebody please help me? Or point me in the right direction. Thank you. Sub...
  17. E

    Amend/understand VBA formula that includes Scripting Dictionaries

    Hi all, I have the below code in part of my excel vba that I need to amend but could do with some help understanding. In cells T, W, and Z there is a sum if formula in row 2, this VBA replicates this formula down to the last row. I am trying to update the formula so that it does this for...
  18. Y

    Lock cells based on conditional format colour

    Hi, I have a spreadsheet which allows users to mark there attendance in the office on a particular day. However, there is a condition where if a certain person is coming in to the office, people sat next to them cannot come in same day and this applies multiple times. I have done conditional...
  19. M

    Excel formula

    Hi I need help with the following table. I'm not sure how to write the formula for the result: My formula is : =IF(AND([@[Case Reason Reason Peanut ]]="True",[@Peanut]="False"),"True",IF([@[Share Contact ]]="False","Peanut")) Case Reason Reason Peanut Peanut Share Contact Result False...
  20. W

    Move Files To Dynamic Folders Based On Cell Value

    Im not sure this is still possible... I referred few posts but they dont work with current office edition.. I have a folder with say around 100 excel workbooks. I need a macro to 1. Open each file in the directory specified 2. Read the contents of a particular cell, E8 3. Create a folder in...

Some videos you may like

This Week's Hot Topics

Top