vba

  1. D

    Populate excel listbox with database table

    Hi, I am trying to make an excel userform that connects to an access database. So far I can search and create new database entries from withing excel. But I can't seem to populate my listbox with a selection of my database table. Here is my code for initializing the userform and fill the...
  2. C

    VBA form not being recognised by the code

    Hi All, I've searched this forum and others without success solving this weird problem. It might be an Excel bug, but I'm hoping it's just something I'm doing wrong. My fairly basic spreadsheet has two userforms. One works perfectly well but the other won't even load. It did when I first...
  3. Ramadan

    How to include my email signature in VBA

    I have found a code on the web to send excel file as attachment and modified it to settle my needs but I need your professional help to add my signature image to the email body and to make the email body text to be set as (Right to Left) here is my code and screenshot of my email signature need...
  4. M

    VBA code failing and miscalculating when running high numbers of lines (200+) but ok when doing it line by line

    Hi, Is there any way to help solve this issue. Currently I have a tab called 'BATCH' where I paste all my data. VBA code is written to calculate different versions of premiums by different permutations (code below). Suddenly the VBA miscalculates (so putting 365 values where 30 values should be...
  5. B

    Found a VBA code to rename sheet name as the current date, but now, trying to make this new sheet as the active worksheet.

    Hi everyone I found a VBA code to rename sheet name as the current date, but now, trying to make this new sheet as the active worksheet. Everything works well except for making the newly or existing worksheet the active worksheet. I have tried 2 commands (those rem out and in red), and they...
  6. R

    find last row in column c and fill out column A and B untill last row found in C

    how can I find last row in column c and auto fill out column A and B based by drag down formulas present in row A2 and B2 until last row found in Column C using VBA / Macro?
  7. A

    Detecting when a user has highlighted a row and displaying the contents of that row in another sheet

    Hello, I am pretty new to excel and I am trying to create a macro or by using equations to detect when a row is highlighted, the content in that row gets copied and pasted in another sheet in a specific row. How do I go about doing it? This is an example of the data in sheet2 (where the content...
  8. M

    MSXML2.XMLHTTP very slow windows 11

    The following code is fast in windows 10, but in windows 11 it can take up to a minute to receive stock data. Any ideas? LocalFilePath = folderPath & "/stockData.csv" Application.ScreenUpdating = False Set oReq = CreateObject("MSXML2.XMLHTTP") With oReq .Open...
  9. T

    VBA code wont open new version of Outlook!

    Hi All I have been using the below code to open Outlook and send off an email but since some of the users have updated their outlook, it doesn't work? Dim xOutlookObj As Object Dim xOutApp As Object Dim xOutMail As Object Dim xMailBody As String On Error Resume Next Set...
  10. M

    Updating Conditional formatting using VBA adds in conditions rather than replacing them

    I have a sheet where users will sometimes paste in elements. In doing so they can replace the conditional formatting in either nothing or some other formats. I have some VBA on a button designed to replace the formatting with the "correct" conditional formatting (see below). The issue I am...
  11. yearego021

    VBA to Save as PDF broken with unwanted deleting of tabs.

    I have a macro to save the workbook into pdf that is currently "running" but deleting a sheet that I do not want deleted. Here are the steps of the macro. 1. Make the necessary tabs visible. - Works 2. Unprotect workbook. - Works 3. Create a copy of a tab for each varation of a value in a drop...
  12. E

    VBA modelmeasures.add error 438

    Hello everyone, I am trying to add a new measures using VBA to my power pivot data model. Unfortunately I keep getting this run time error 438. I am using windows microsoft 365. Below you can find the whole code. I have colored red the part of the code that is giving me the previously mentioned...
  13. W

    VBA code for multiple columns

    The function is to put an 'X' on the row within that column when the keyword matches what is in column A. I have this working for column 'E' but I would like to apply it to columns F-K as well with the same function. Any suggestions are appreciated! Thank you in advance! Private Sub...
  14. M

    Selenium Element not corresponding to Click

    I have the following element that is the 4th element on a nav bar within a website: <a href="#step3" data-toggle="tab" data-bind="click: function(){ viewModel.GetRequiredDocuments(viewModel.xxxx); viewModel.xxxx(); }" aria-expanded="true">Documents</a> I am able to select the element. I...
  15. M

    How to create XML using VBA (Excel Macros) with readable result?

    Hi, i am never created my own VBA before. However, i needed to make XML file from my excel data. I want to have some condition such as ignoring empty row, ignoring character such as / - @ #. The VBA also only processing data from certain row until certain row dynamically with the last row is the...
  16. D

    Umwandler erweitern (doc. zu docx.)

    Hallo Zusammen, da unsere Firme leider noch sehr viele alte Worddateien im einsatz hat, welche aber oft nicht richtig Laden etc. Es funktioniert in Excel teoretisch genauso, weshalb ich hoffe ihr könnt mir helfen. habe folgendes Macro erstellt um doc. in docx. umzuwandeln. Dieses Macro...
  17. A

    VBA and Windows Scheduler

    Good day. I have a functional Excel knowledge; however, is very new to task automations. Essentially, I want to automate the following process using Windows Scheduler and Excel Macros: - Open Excel - Open PERSONAL.XLSB - Open latest file in the specified path - Run Macro called...
  18. V

    Disallowing user to change cell color

    Hello dear excel-lers, I have a workbook that helps me to record people's phone attendance on weekly basis. Each sheet is a list with names and timeslots. Users then are expected to choose from a drop-down menu 1 of 3 options (1-office, 2-home office, 3-formation). There is also a formula that...
  19. Ramadan

    VBA code to add current date when the sheet receive new update

    I have a worksheet that only receive updates from other sheet with filter formula, no manual entry at all occurs in this sheet and I need a code to add the current date Now() in cell "C3" as soon as the sheet receive any update from the source sheet .. I have a code but it insert the date based...
  20. G

    How to unzip the file from folder based on cell range

    Hello, I am trying to unzip a file for folder based on Cell Range. For Example Cell Range A1: have my file name (xyztestfile.zip). I am new to VbA and need help

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top