Category "vba"

How can I cancel a button's action on an Access form if the button is double clicked?

I have a MS Access database that has a switchboard on it that opens different forms within the database. For some reason, some of the users like to double click

How to copy a column value if condition is met in cell to the left

I currently have code that inserts two columns, and copies values from two other columns into these two new columns. 'Insert 2 Column to the Left of S Colum

VBA doesn´t add datalabel

I have an existent graph to which I added a macros. The macros should update the axes, add a datalabel to the last point and delete the datalabel of the previou

Changing SensitivityLabel in Outlook 365 email with VBA

How can I access the methods of Office.SensitivityLabel in Outlook 365 that will allow me to create and set a label for a new email. Looking at the (sparse) doc

Bitly API v4 - VBA Excel Macro

I'm trying to get the shorten bit.y URL in my excel file, but instead I'm obtainig the following message, {"created_at":"2022-05-04T21:48:32+0000","id":"bitly.i

Move selected email to folder based inputbox value, Outlook

could someone help me to create script for moving emails in the outlooks folders based on value added to inputbox? Idea is that, I select one or more emails and

Populate word tables from an Excel table

From our audit database I derive an Excel table like this one below. What I need to do is populate a table in a word template document with the content of the f

Getting data from URL into MS Access table

There's a website that provides weather data: https://www.visualcrossing.com/weather/weather-data-services I want to import that data into a table with a butto

VBA Word - InsertFile changes the style (font, size...) of the bookmark and adds a new line

I'm trying to fill a Word document with plain text files in VBA. Here is what I have : The Word document has bookmarks with default text inside (this helps me t

Error 1004 keeps popping out when trying to execute the sort VBA command

Part 1: Please help to advise where did it went wrong. Would like to sort for column E via descending order with header Sub SortRows() Dim destSht As Worksheet

Clear the Multiple Page content in simple coding

Hi I am having 11 sheets in my workbook. I need to delete some contents in all the sheets except 1 sheet. I have written some code. while I am rund the code act

Object required for comboboxes/checkboxes that already exist on my worksheet?

Okay, totally noob coder here. I'm working on a sheet that has a repeating series of 1 combo box linked to one other combobox and a checkbox. Basically, the fir

How to reduce the displayed Majorgridlines in order to match them to the "Category" texts?

Within this picture, an Excel chart is displaying approximately 100 values + times (red curve): Excel is "intelligent enough" to reduce the number of the displ

Transferring string arrays from VBA7 to C++

I'm currently working on a project where I want to be able to manipulate and graph data with relative ease in Excel. However, a lot of the data involved exceeds

Loop through three specific Outlook folders

I have Excel VBA code that imports Outlook mail data from one folder into Excel. I change this for three folders all at the same level (not subfolders). Is ther

For Each Loop stops after deleting one row

I am trying to use an if else statement to delete the entire row when a text value is found in a cell within a given range. The code stops after deleting one ro

Excel convert digits into respective words [closed]

I would like to convert the number of digits in excel into respective words as shown in the picture above. How can I achieve this functionali

System error when opening macro &H800700C1

I was using regularly a macro add-in in excel which stopped working all of a sudden. I get several error messages in the following order when I launch the macro

Exporting sheets as pdf error: Run-time error '1004'. We didn't find anything to print

I'm trying to export all sheets in the workbook as separate pdf files using one button. I followed a YouTube tutorial: https://www.youtube.com/watch?v=FRZ6n3gHt

Save InlineShape picture to file in Word VBA

I am trying to extract a picture from a Word document and save it in a file, using vba. I don't really care about the output format, as long as it is readable.