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

Sort by: Updated
2 answers

Address in, GPS coordinates returned; GPS coordinates in, address returned

I am looking for Visual Basic code or a Visual Studio control that can accept a world-wide mailing address as input, and return GPS coordinates. I am looking for Visual Basic code or a Visual Studio control that can accept GPS coordinates as input, and…

Developer technologies | Visual Basic for Applications
asked 2026-08-27T16:16:52.89+00:00
Ronald Chandler 41 Reputation points
commented 2026-08-31T19:22:46.3033333+00:00
Ronald Chandler 41 Reputation points
5 answers One of the answers was accepted by the question author.

VBA Excel - Getting the ActiveWorkbooks.Name that is having spaces

Hi, I have an Excel file (Archives_Years.xlsm) with a few sheets by years that I want to fill with some content of other files (excel or text files) that I am opening one by one in Excel (I have to adapt the VBA code depending of the file). In my…

Developer technologies | Visual Basic for Applications
asked 2026-08-27T02:14:03.8+00:00
IsabelleCharest-5234 40 Reputation points
accepted 2026-08-29T00:31:54.5333333+00:00
IsabelleCharest-5234 40 Reputation points
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) 735 Reputation points Microsoft External Staff Moderator
3 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 0 Reputation points
answered 2026-08-24T00:34:15.72+00:00
Alan McNutt 0 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,535 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,355 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,980 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,155 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,155 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,155 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 300 Reputation points
commented 2026-06-23T08:39:12.16+00:00
Nancy Vo (WICLOUD CORPORATION) 8,155 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,155 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