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

Sort by: Updated
Updated Created Answers
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) 7,500 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 240 Reputation points
commented 2026-06-23T08:39:12.16+00:00
Nancy Vo (WICLOUD CORPORATION) 7,500 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) 2,820 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) 7,500 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) 7,425 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Excel VBA Like Operator Question

To the Community: Need a little clarification on the VBA "Like" Operator for the below snippet. From reading the language reference, I do not understand why statements "#1. - #4." below returns FALSE when variable "a"…

Developer technologies | Visual Basic for Applications
asked 2026-05-24T23:09:24.2766667+00:00
KF4UYC 40 Reputation points
commented 2026-05-26T02:38:02.7466667+00:00
Nancy Vo (WICLOUD CORPORATION) 7,500 Reputation points Microsoft External Staff Moderator
2 answers One of the answers was accepted by the question author.

Cannot set FontName and/or FontSize in an Excel Comment with Visual Basic for Applications

Dear Team, I have Microsoft 365 Personal License I am using macOS Tahoe 26.5, Microsoft® Excel for Mac, Version 16.109.1 (26051717) In a Visual Basic for Applications I am trying to put the font name and text size in a comment block. Translating the code…

Developer technologies | Visual Basic for Applications
asked 2026-05-22T15:52:17.31+00:00
John Wismeijer 30 Reputation points
commented 2026-05-25T09:51:25.4066667+00:00
John Wismeijer 30 Reputation points
2 answers One of the answers was accepted by the question author.

I cannot get VBA in Excel to make the Userform Calculator i created to perform operations on numbers with decimals right

Private Sub cmbdecimal_Click() If InStr(txtDisplay.Text, ".") = 0 Then txtDisplay.Text = txtDisplay.Text + "." End If End Sub ^This is the code i used on the command button for "." I can type a decimal, but the answer the…

Developer technologies | Visual Basic for Applications
asked 2026-05-10T08:01:25.4+00:00
Joshua Mcdowall 20 Reputation points
accepted 2026-05-15T05:20:56.4066667+00:00
Joshua Mcdowall 20 Reputation points
4 answers

marcros in excel has been blocked please help

Dear Team, I cannot disable my marcros in excel has been blocked and i can't disable this and unblock option is also not showing therefore i can't use my vba excel project please help for disable my macro setting so that i can use my vba in excel

Developer technologies | Visual Basic for Applications
asked 2026-05-07T09:50:28.61+00:00
r 5 Reputation points
commented 2026-05-14T13:17:27.4433333+00:00
Varsha Dundigalla(INFOSYS LIMITED) 5,185 Reputation points Microsoft External Staff
4 answers

please fix the issue

this error was showing

Developer technologies | Visual Basic for Applications
asked 2026-05-07T10:07:12.66+00:00
r 5 Reputation points
commented 2026-05-14T06:49:01.7233333+00:00
Jack Dang (WICLOUD CORPORATION) 18,975 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Update of another workbook with a vba macro

Since last version of excel it is impossible from a workbook to open another one ,make changes and save them and then close the workbook. The process works, but when the workbook is closed the version before changes is back again (file with the initial…

Developer technologies | Visual Basic for Applications
asked 2026-05-05T23:13:01.4266667+00:00
Jacques Abel 20 Reputation points
commented 2026-05-13T11:03:25.56+00:00
Jacques Abel 20 Reputation points
3 answers

How to access Properties of objects in Excel VBA

Things seem to have changed in VBA since I last wrote any code. I am designing a small project for home use, using Excel and VBA. I find I can add controls to a userform but I cannot change their properties at design time. For example, I have a…

Developer technologies | Visual Basic for Applications
asked 2026-05-05T12:50:37.8666667+00:00
Alan Sears 0 Reputation points
commented 2026-05-11T06:25:37.67+00:00
Jack Dang (WICLOUD CORPORATION) 18,975 Reputation points Microsoft External Staff Moderator
2 answers

How can I read an excel sheet from AccessCan I

Can I open and read an excel sheet from a VB procedure in Access

Developer technologies | Visual Basic for Applications
asked 2026-04-30T14:02:34.5833333+00:00
Jackie Beedie 0 Reputation points
commented 2026-05-07T08:04:16.6033333+00:00
Jack Dang (WICLOUD CORPORATION) 18,975 Reputation points Microsoft External Staff Moderator
2 answers

Application.Wait

give me an example of Application.Wait in VBA code.

Developer technologies | Visual Basic for Applications
asked 2026-04-30T14:32:24.8266667+00:00
Randy Avery 0 Reputation points
commented 2026-05-06T02:34:12.3533333+00:00
Nancy Vo (WICLOUD CORPORATION) 7,500 Reputation points Microsoft External Staff Moderator
1 answer One of the answers was accepted by the question author.

Word Complete the whole Document

Hello from Steve Can the below script please to the whole document as it stops after finding the first instance. Sub Horse_Above_10() With Selection.Find .ClearFormatting .Text = "\) [0-9]{2,} [A-Z]" ' wildcard pattern …

Developer technologies | Visual Basic for Applications
asked 2026-04-27T21:45:52.61+00:00
SteveD 585 Reputation points
accepted 2026-05-05T19:09:02.46+00:00
SteveD 585 Reputation points