I want to call the "Refresh" function of the Microsoft Dynamics NAV Excel Add-in which has a button on the ribbon using VBA. I tried recording a macro when clic
I have a worksheet change event that runs when three adjacent cells in columns C, D and E are filled with any value, which puts the date of entry into a separat
Normally when using the VBA editor, code autosuggests from available methods.properties for whatever object being referenced. I'm trying to pull data from an Ex
I've seen this error message on other posts but none matched my situation. I have a few AutoFilter functions done one after the other checking if the target cel
I have some VBA that works as follows. For messages that are selected in Outlook, it marks them as read, assigns a category and moves them to a subfolder. It
I am trying to create a macro that inserts an image into one cell when the user enters specific information into an other cell. Right now it's working but not r
I am trying to create a macro that inserts an image into one cell when the user enters specific information into an other cell. Right now it's working but not r
Regarding this question “combine or merge cells with the same values vertically and horizontally” Link, the provided answer (edited one) it works ,b
I am writing for an application that validates if users perform tasks successfully in various Microsoft applications. One of these skills is
The purpose of the macro is to avoid creating a new worksheet each time a user double clicks / drills down on a pivot table value. Instead the script copies the
My problem is the following. I have two tables. The first table is a guest list where the information on who is the guest and how many beds he need is stored. S
I am trying to insert real-time data from a financial service provider into Excel, which can only be fetched with an Excel-plugin in blocks of roughly 100,000 v
I have implemented this method to multiply every array element by a number held in a variable, it works, but I believe it is terribly slow. Is there an accepted
I Want to customise automatically in Excel a Reference number according to the content of the line it is representing. I have a table for test procedure that lo
I want to detect if text/values are being deleted from a number of cells that are not located adjacent to each other so I can execute a routine. As an example I
I have a SAP GUI script running every day in VBA. In the script I am exporting some data from SAP to several different Excel files, and these are saved to a net
My vba code connected to a button is crashing on runtime. It is stating sub or function not defined. I am new to vba code so I dont know how to solve this. It a
I created a form with 3 textboxes & a search button. Also a query that is setup to take the criteria in the textboxes & filter the results of a table wi
The following code populates ComboBox on a userform in vba with unique values. I use the same code to populate two other ComboBoxes. It doesn't work when the da
I'm trying to get the file list of a folder in VBA The DIR command acts as if the * wildcard is messing up the whole mask that I input. Here is my file list: No