1,651 questions with Developer technologies | Visual Basic for Applications tags

Sort by: Updated
2 answers

Run time error 9, Subscript out of range eroor is showing while using Excel VBA

Run time error 9, Subscript out of range error is showing while using Excel VBA, When i am using Excel VBA and write coding for run a macro and when i run the code this error is showing, I tried every thing to solve this, but not working, I am unable to…

Developer technologies | Visual Basic for Applications
asked 2026-08-19T04:43:10.06+00:00
sachin kumar 5 Reputation points
commented 2026-08-26T02:33:29.9366667+00:00
Tony Thach (WICLOUD CORPORATION) 560 Reputation points Microsoft External Staff Moderator
2 answers

Visual Basic in Excel Instruction and function manual

I am having trouble finding basic information on instructions with detailed syntactical rules and similarly a list of functions in Visual Basic. EG... where do I find the exact syntax for dimensioning an array and declaring a range of cells as an…

Developer technologies | Visual Basic for Applications
asked 2026-08-24T00:24:50.74+00:00
Alan McNutt 5 Reputation points
commented 2026-08-24T00:34:15.72+00:00
Alan McNutt 5 Reputation points
3 answers

VBA control on worksheet calculations

I woud like to have VBA control over when a work sheet is calculated

Developer technologies | Visual Basic for Applications
asked 2026-08-09T11:35:45.31+00:00
Heinrich Morf 0 Reputation points
commented 2026-08-17T03:19:47.1066667+00:00
Taki Ly (WICLOUD CORPORATION) 4,275 Reputation points Microsoft External Staff Moderator
1 answer

Need to figure out how to create drop down list in Powerpoint using developer option

I've watched the few videos and read articles I can find on this topic but still cannot figure out how to create a drop down list in powerpoint, using developer option. When I get to the point of entering my data in the code field: End…

Developer technologies | Visual Basic for Applications
asked 2026-08-02T23:40:17.5466667+00:00
Bridget Shoulders 0 Reputation points
commented 2026-08-10T03:05:40.37+00:00
Danny Nguyen (WICLOUD CORPORATION) 8,450 Reputation points Microsoft External Staff Moderator
4 answers

VBA trying to launch Outlook 2016

My VBA Excel code is set to send an email, but rather than using the existing Outlook on my laptop is trying to launch and install Outlook 2016

Developer technologies | Visual Basic for Applications
asked 2026-07-31T15:21:20.67+00:00
Marty Sheehan 0 Reputation points
commented 2026-08-10T01:38:27.8633333+00:00
Jay Pham (WICLOUD CORPORATION) 4,350 Reputation points Microsoft External Staff Moderator
5 answers One of the answers was accepted by the question author.

VBA Developer Mode?

Hi Community.  DPA here.  See attached screenshot. I need pointed in the right direction.  I don’t know how to get started in VBA Developer mode in Outlook.  I have read through both the “Visual Basic Guide” and the “Office VBA Reference/Outlook” in…

Developer technologies | Visual Basic for Applications
asked 2026-07-28T11:44:44.43+00:00
DPA 25 Reputation points
commented 2026-08-05T14:04:35.6866667+00:00
Julie Huynh 2,900 Reputation points Independent Advisor
3 answers

conversione di Private Declare Function ShowWindow in PtrSafe

come converto questa funzione di Acces da Private Declare Function ShowWindow Lib "user32" _ (ByVal hWnd As Long, ByVal nCmdShow As Long) As Long in PtrSafe?

Developer technologies | Visual Basic for Applications
asked 2026-07-25T09:41:05.51+00:00
Stefano Colombo 0 Reputation points
commented 2026-08-03T02:19:30.1533333+00:00
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator
2 answers

RamOptimizerWinUI\RamOptimizerWinUI\Form1.Designer.vb(23)

how do I resolve error code BC30002 in ram optimizer/winUI?

Developer technologies | Visual Basic for Applications
asked 2026-07-24T12:43:16.0033333+00:00
Tommy Hale 5 Reputation points
commented 2026-08-03T02:15:12.0133333+00:00
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Unexpected Error when Dereferencing a Byte Array in VBScript

So, I am writing a VBS script that at some point needs to read a file byte by byte and do some computations on each byte. So, I use the following code to read each byte: Set Stream = CreateObject("ADODB.Stream") Stream.Type = 1 ' aka.…

Developer technologies | Visual Basic for Applications
asked 2026-07-28T20:12:15.5733333+00:00
Billy Gayts 20 Reputation points
commented 2026-07-30T16:37:40.98+00:00
buttler boos 0 Reputation points
30 answers

Search for subform record based on text box

I am trying to bring up a form record based on text entered in a text box. The form "Furnace + Header Data Form" is a parent form, with 2 subforms called "Header Data Form" and "Surrogate Data Form". This question is in…

Microsoft 365 and Office | Access | Development
Developer technologies | Visual Basic for Applications
asked 2022-12-12T18:31:50.943+00:00
carmens 6 Reputation points
answered 2026-07-24T19:39:24.4133333+00:00
unshackled 0 Reputation points
3 answers One of the answers was accepted by the question author.

how to input data from a spreadsheet into a macro

What's the simplest way to pass a number (such as a month number) in a cell of my EXCEL spreadsheet into a macro? I have Excel 24, not 365.

Developer technologies | Visual Basic for Applications
asked 2026-07-03T15:30:56.5633333+00:00
David Hill 100 Reputation points
accepted 2026-07-09T13:03:54.89+00:00
David Hill 100 Reputation points
3 answers

download VBA library

Need to download VBA Library to work with macros in excel.

Developer technologies | Visual Basic for Applications
asked 2026-06-19T18:17:54.72+00:00
Roz Bauer 0 Reputation points
commented 2026-06-29T02:31:06.67+00:00
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator
2 answers

Having a VBA problem when writing an EXCEL macro

Tell me how I can send you an EXCEL file which details the gist of my problem.

Developer technologies | Visual Basic for Applications
asked 2026-06-13T14:42:56.2566667+00:00
David Hill 100 Reputation points
answered 2026-06-25T13:59:43.0966667+00:00
ReHaN AhMaD 0 Reputation points
2 answers

KB5094123 update causes RDS.DataSpace Optional parameter to reset to default value after COM+ function call

After installing Windows Server 2019 KB5094123 (June 2026 Patch Tuesday), we are experiencing an issue where Optional parameters passed to a COM+ DLL via RDS.DataSpace are being reset to their default values after an internal sub-function call…

Developer technologies | Visual Basic for Applications
asked 2026-06-23T04:00:47.93+00:00
홍준호 0 Reputation points
answered 2026-06-23T09:27:42.6866667+00:00
Varsha Dundigalla(INFOSYS LIMITED) 5,185 Reputation points Microsoft External Staff
5 answers One of the answers was accepted by the question author.

Want: cross hair highlit in my excel sheet

Hello - I want to install or cretate VBA for cross hair highlit in my excel sheet. please provide me the ways to do that i can see cross hair highlights when i open my ecel sheet.

Developer technologies | Visual Basic for Applications
asked 2026-06-22T14:32:04.58+00:00
Chaturvedi, Santosh 280 Reputation points
commented 2026-06-23T08:39:12.16+00:00
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator
3 answers

Edit/Customize Birthday Report

Is it possible to edit/customize reports? For example, telephone numbers are not listed on the birthday report.

Developer technologies | Visual Basic for Applications
asked 2026-06-12T16:09:12.79+00:00
Shelby Heard 0 Reputation points
commented 2026-06-22T04:21:27.9066667+00:00
Taki Ly (WICLOUD CORPORATION) 4,275 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Excel vba public variable not storing in do loop after update

For the below VBA code. We've been using this code for several years. Presently, the (below) code is not storing the Mrow data or (it forgets the value of the SEC-ID line) as soon as the code executes it leaves the SEC-ID line and the variable is…

Developer technologies | Visual Basic for Applications
asked 2026-06-18T13:42:59.2766667+00:00
Domenic Moscato 25 Reputation points
commented 2026-06-22T02:32:36.7366667+00:00
Nancy Vo (WICLOUD CORPORATION) 8,075 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Change color of Hebrew cantillation characters

Word options (Advanced) allow me to change color of all diacritics. I would like to change all diacritics to green and then change cantillation marks to red. Cantillation marks are Hex 0591-05AE, or Dec 1425-1454. I wonder if this can be done by ctrl-H,…

Developer technologies | Visual Basic for Applications
asked 2026-06-02T21:42:52.3833333+00:00
joe lewis 40 Reputation points
answered 2026-06-09T13:24:08.3866667+00:00
joe lewis 40 Reputation points
2 answers

How to fix Run-time error '424;: Object required

Sub SaveC11s() Dim objAttachment As Outlook.Attachment Dim saveFolder As String Dim targetSubjectKeyword As String ' CONFIGURATION: Set your target folder path and subject keyword saveFolder = "\ComptonJenn\Downloads\Current Month…

Developer technologies | Visual Basic for Applications
asked 2026-06-01T13:24:57.1366667+00:00
Jenn C 0 Reputation points
commented 2026-06-09T09:03:31.9966667+00:00
Jack Dang (WICLOUD CORPORATION) 18,975 Reputation points Microsoft External Staff Moderator
2 answers

Run-time error "53" window pop out when I use WORD

Why is there a window pop out saying Visual Basic for Application, Run-time error "53" when I open WORD.Ru

Developer technologies | Visual Basic for Applications
asked 2026-05-31T22:45:38.9733333+00:00
Carol Carol 5 Reputation points
commented 2026-06-08T02:55:23.2133333+00:00
Danny Nguyen (WICLOUD CORPORATION) 8,450 Reputation points Microsoft External Staff Moderator