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

Sort by: Updated
Updated Created Answers
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-04T10:55:15.45+00:00
Danny Nguyen (WICLOUD CORPORATION) 6,945 Reputation points Microsoft External Staff Moderator
2 answers

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 20 Reputation points
commented 2026-06-04T07:49:40.5966667+00:00
Jack Dang (WICLOUD CORPORATION) 18,800 Reputation points Microsoft External Staff Moderator
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
answered 2026-06-02T03:40:14.9833333+00:00
Jack Dang (WICLOUD CORPORATION) 18,800 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) 5,015 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,025 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,800 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,800 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,800 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) 5,015 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 515 Reputation points
accepted 2026-05-05T19:09:02.46+00:00
SteveD 515 Reputation points
2 answers One of the answers was accepted by the question author.

Word find 12 Font only it is also finding Font 10.5

Ho from Steve Can the below script please find 12 Font. Not Font 10.5 Sub Horse_Above_10() With Selection.Find .ClearFormatting .Font.Size = 12 .Text = "\) [0-9]{2,} [A-Z]" .Replacement.Text = "" .Forward =…

Developer technologies | Visual Basic for Applications
asked 2026-04-27T21:22:15.1833333+00:00
SteveD 515 Reputation points
accepted 2026-05-05T06:15:26.05+00:00
SteveD 515 Reputation points
1 answer One of the answers was accepted by the question author.

Word Move to next

Hello from Steve ) 10 G ) 11 G Objective find the next What is happening is that it is going back to the beginning What is required please for the script to find the next please Sub…

Developer technologies | Visual Basic for Applications
asked 2026-04-27T20:56:27.62+00:00
SteveD 515 Reputation points
accepted 2026-05-05T06:14:09.4666667+00:00
SteveD 515 Reputation points
1 answer One of the answers was accepted by the question author.

Word find text in window2

Hello from Steve What is required please for the below script to function. Find text in window2 Sub Testing2() Dim i As Integer Dim blnFound As Boolean Selection.Find.ClearFormatting With Selection.Find .Text = "[0-9]{1,}…

Developer technologies | Visual Basic for Applications
asked 2026-04-29T21:49:56.0466667+00:00
SteveD 515 Reputation points
commented 2026-05-05T05:11:58.42+00:00
Gade Harika (INFOSYS LIMITED) 2,850 Reputation points Microsoft External Staff
1 answer One of the answers was accepted by the question author.

Word activates Macro

Hello from Steve Objective please is to Activate Second Selection and Activate Third selection using a single macro Meaning push the macro for Top Selection then I will place the cursor for the second selection and push the single macro to actitivate…

Developer technologies | Visual Basic for Applications
asked 2026-04-26T23:04:25.3066667+00:00
SteveD 515 Reputation points
edited the question 2026-05-05T04:53:00.67+00:00
simo-k 83,725 Reputation points Volunteer Moderator
2 answers

Word Re-set after the 3rd

Hello from Steve Can the below be re-set after the third selection I do more than one in the same document. When I go to use it the second time in the same document it puts in the third selection' I need it to restart by putting in the first selection…

Developer technologies | Visual Basic for Applications
asked 2026-04-27T00:35:40.78+00:00
SteveD 515 Reputation points
edited the question 2026-05-05T04:52:02.3633333+00:00
simo-k 83,725 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Word 8 REVISION find in second window 8 36951 REVISION

Hello from Steve Objective Window 1 has 8 REVISION Window 2 has 8 36951 REVISION Is it possible please from Window 1 8 REVISION to find in Window 2 8 36951 REVISION Sub Testing2() Dim i As Integer Dim blnFound As Boolean Dim strText As…

Developer technologies | Visual Basic for Applications
asked 2026-04-29T22:08:43.05+00:00
SteveD 515 Reputation points
edited the question 2026-05-05T04:48:55.5666667+00:00
simo-k 83,725 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

"Word" Needs to stop at the end of the document

Hello from Steve Objective needs to stop at the end of the document Sub Word_to_Excel_Part_One() Dim rng As range Set rng = ActiveDocument.Content With rng.Find .ClearFormatting .Text = "F90" .Replacement.Text = "" …

Developer technologies | Visual Basic for Applications
asked 2026-05-05T03:20:36.7933333+00:00
SteveD 515 Reputation points
edited the question 2026-05-05T04:47:46.49+00:00
simo-k 83,725 Reputation points Volunteer Moderator