I'd like to move the selected email to the "Junk Email" folder and create a spam rule for that email address that automatically sends all future emails from tha
I have an Excel document consisting of data imported into multiple tabs. The columns in each tab are stretched out and hard to read. I am trying to cycle throug
The code is intended to add the same hyperlink to all Heading 1 style text. (Purpose: clicking any heading brings you to the top of the document). It works for
I need to get multiline text from textarea element of web-page. I see in Chrome developer tool that text I need is stored in value property of textarea. I marke
With the help of the web, I have been able to write some VBA to check content controls on a Word 2013 template document and use the content to create a filename
I have a workbook with several comboboxes (and listboxes) and a lot of vba written around them. I've used the same code in the Workbook_Open procedure to format
I would like to exit my for loop when a condition inside is met. How could I exit my for loop when the if condition has been met? I think some kind of exit at t
I'm trying to create a SHA256 object from MS Access VBA. I'm running Access 2016 on a Windows machine with .NET 4.8. Public Function Base64_HMACSHA256(ByVal sTe
I am creating an activity tracker in Excel. I'd like to be able to "Select all that apply" from drop down lists in two separate columns on the same sheet. I am
I wrote a macro to check if a date is the last day of a month. If so this cell should blink every 1 second, so I'm calling a Do While loop. I want to start the
I'm trying to use two custom lists to order the columns in a specific reach. First I define the two custom lists (arrays) and in the .Sort statement I give the
How do I color all the series (lines) in a specific (selected/current) chart the same color? I have the following, but it does nothing: Sub Same_Color() Dim
The accepted wisdom is that using a construct like Dim dict As New Dictionary is poorer in performance than Dim dict As Dictionary / Set dict = New Dictionary.
How to play local video file on loop on an excel userform?
I'm working on a school project to compare if date1 is equal to date2 - 1 (date1 is one day earlier than date2). date2 is located one cell below date1. This is
I am sending an email using Outlook object from a subroutine vba The email gets send from my email and the recipients see : [email protected] . Is there any wa
I run into run-time error 1004 Works if I use the cell as an argument but I don't want to constrain to one cell. I can get this to run if I use an input param
I need to deploy an Outlook rule that runs a script. So in other words I need deploy both an Outlook rule and the script it runs. I know I can get users to impo
I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine. Now, when I o
I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is w