vba in excel

  1. J

    VBA Array Transformation Question

    I very often get two dimensional arrays of returns for a given fund, months across the top and years down the left side: Jan Feb ... Dec 2019 1% 2% 1% 2020 2% 1% 3% This format is useless to perform analysis, so I will typically...
  2. amitami67

    VBA excel criteria search for string paste rows to sheet

    Dear members, I'm having a lot of trouble with this VBA code for a table that has rows starting from 341-533 and columns A-K. I'm trying to write code that enters a specific string criteria in a text box to search for a string like "rent" or "volunteer" in a multiple detailed string column like...
  3. amitami67

    VBA criteria search for string paste rows to sheet

    Dear members, I'm having a lot of trouble with this VBA code for a table that has rows starting from 341-533 and columns A-K. I'm trying to write code that enters a specific string criteria in a text box to search for a string like "rent" or "volunteer" in a multiple detailed string column like...
  4. S

    Excel 2016 send email notification, WINDOWS 10

    I am trying to create a VBA that sends me a reminder/email in Outlook based on a date in a specific column in this case (column R) and then adds the date the reminder was sent in the next column (S) . Can someone please assist me.
  5. C

    Sending an email with excel

    A while ago, OBP helped me create an excel sheet that automatically sends me an email when a cell displays "send". Lately it has been sending an email regardless of whether the cell displays send. It's also not displaying the "action required" in the email. I was hoping someone could point out...
  6. E

    How to copy comboboxes with checklistd in VBA

    Hello all, I am new to VBA (in Excel) and i am wondering how to tell vba that when a checklist is ticked i can copy the data that is in my text and comboboxes to my spread sheet to my spreadsheet. i have already done the code for the adding without the check boxes.
Top