I have different accounts in my Outlook. Depending on the currently selected folder, I would like to find the smtp Email address of the corresponding account. (
I have 3 combo-boxes and an OK button. I need to set the value of multiple cells in multiple worksheets equal to the value of the combo box selection. Dim choic
I am trying to file emails using a macro, but I am having issues if the user selects a conversation header. What is the typeOf of these headers? I am trying
I am using a button from an unbound nav form to open a different form. The button Macro closes the nav form and opens the form I want with no issues. I have a q
Scenario I have an excel cell that contains value with leading zereos (Eg: 0002). My macro is copying this value to a variable called runNumber and pasting it i
I am trying to process some rows in a sheet with VBA. I want to cut and paste a set of rows from one sheet to the other and struggling to work out the code I ne
I'm trying to use a vba if statement to check if my cell H22 on sheet 1 matches a cell in column I on sheet 2. can someone please show me where im going wrong?
I'm trying to teach myself VBA during the short holiday break. For my first module, I want to create a module that does the following: Displays dialog box. Pro
Is there any way to automate Edge in IE mode using VBA without Selenium drivers. Will it work in same way as how it works in IE. We need to use the same code in
PowerPoint 2016 has a neat new feature where you can insert Zoom Slides/Sections. See here if you don't know what I'm talking about: https://support.office.com/
In Windows Explorer, if I right-click a file and choose Properties to get the file's Properties window, and then select the Details tab, there is a property lis
I have an image in my worksheet I want to fade out. I am tying to set different stages of transparency for the image: Set myPicture = ActiveSheet.Pictures.Inser
I have a data sheet "orders" which has data in the format order no Customer Sales Executive Order Status Order Date 211 nokia john cancelled 2
I have several script that have a part that is copying Charts and Pasting it in an area as Picture. Those scripts are working without any error when I look at t
I've been successfully using the Yahoo Finance API cookie/crumb technique to get historical stock quotes for many years. On April 28th, 2022, it broke, and exc
I am trying to select a worksheet every time when i open up a workbook using an inputbox in VBA. here is my code for opening a workbook but after i open up my w
I have a loop to check for incoming emails from Joe Doe with specific subject. That loop works and saves attachments from Joe Doe. If (Msg.SenderName = "Doe, J
I need to place a userform next to a selected cell. Here's my code. Excel 2013. In the userform module: Private rangePosition As Range 'Property passed to for
The problem: Control.HorizontalAnchor or Control.VerticalAnchor gets a value out of the accepted range. In the IDE window: Debug.Print Btn.VerticalAnchor -->
I have a VBA project where I need to create a userform on which there should be an attachment button to select multiple images and save them in a folder with a