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

Sort by: Updated
Updated Created Answers
3 answers

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 0 Reputation points
answered 2026-05-06T07:14:13.4833333+00:00
Jack Dang (WICLOUD CORPORATION) 17,420 Reputation points Microsoft External Staff Moderator
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
answered 2026-05-06T03:51:23.9166667+00:00
Jack Dang (WICLOUD CORPORATION) 17,420 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) 3,465 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 430 Reputation points
accepted 2026-05-05T19:09:02.46+00:00
SteveD 430 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 430 Reputation points
accepted 2026-05-05T06:15:26.05+00:00
SteveD 430 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 430 Reputation points
accepted 2026-05-05T06:14:09.4666667+00:00
SteveD 430 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 430 Reputation points
commented 2026-05-05T05:11:58.42+00:00
Gade Harika (INFOSYS LIMITED) 2,765 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 430 Reputation points
edited the question 2026-05-05T04:53:00.67+00:00
simo-k 81,030 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 430 Reputation points
edited the question 2026-05-05T04:52:02.3633333+00:00
simo-k 81,030 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 430 Reputation points
edited the question 2026-05-05T04:48:55.5666667+00:00
simo-k 81,030 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 430 Reputation points
edited the question 2026-05-05T04:47:46.49+00:00
simo-k 81,030 Reputation points Volunteer Moderator
1 answer One of the answers was accepted by the question author.

Word Stop at the end of document

Hello from Steve Objective please to loop to end of document. Sub Word_to_Excel_Part_One() Selection.Find.ClearFormatting With Selection.Find .Text = "F90" .Replacement.Text = "" .Forward = True .Wrap =…

Developer technologies | Visual Basic for Applications
asked 2026-05-05T02:58:14.1033333+00:00
SteveD 430 Reputation points
edited the question 2026-05-05T04:46:58.36+00:00
simo-k 81,030 Reputation points Volunteer Moderator
2 answers

Office 365 Update version 2604

Anybody else having issues with the latest Update blocking exchanges between Excel and Outlook using the Outlook.MailItem, have rolled back to 2603 and the VBA MAcro is working perfectly again.

Developer technologies | Visual Basic for Applications
asked 2026-04-27T18:23:51.8833333+00:00
andy 5 Reputation points
commented 2026-05-05T03:59:05.3566667+00:00
Jack Dang (WICLOUD CORPORATION) 17,420 Reputation points Microsoft External Staff Moderator
2 answers

Excel Update Broke PivotCache VBA Functionality — Request for Fix or Escalation

Since a recent Microsoft 365 Excel update ~January 24/25, multiple VBA procedures that interact with PivotCaches and update PivotTables have stopped functioning across our organization. These macros have worked reliably for years and stopped functioning…

Developer technologies | Visual Basic for Applications
asked 2026-01-28T19:16:45.0766667+00:00
Murray, ThomasJ (Penske) 15 Reputation points
edited an answer 2026-05-03T07:09:12.4066667+00:00
ychi-7143 0 Reputation points
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-01T04:28:00.09+00:00
DJ 0 Reputation points
2 answers One of the answers was accepted by the question author.

Word finding X at the beginning of numerals

Hello from Steve Is it possible please using the below [0-9XL]{5} to also find X at the beginning. For example X9937 Sub Test () Selection.Find.ClearFormatting With Selection.Find .Text = "[0-9XL]{5}" .Replacement.Text =…

Developer technologies | Visual Basic for Applications
asked 2026-04-20T04:03:02.13+00:00
SteveD 430 Reputation points
accepted 2026-05-01T01:44:37.6366667+00:00
SteveD 430 Reputation points
2 answers One of the answers was accepted by the question author.

Using VBA to select text.

Hello from Steve Is this possible please to select text 5PBPX using VBA Mod moved from : Microsoft 365 and Office | Word | For home | Windows

Developer technologies | Visual Basic for Applications
asked 2026-04-20T21:09:48.78+00:00
SteveD 430 Reputation points
accepted 2026-05-01T01:30:29.02+00:00
SteveD 430 Reputation points
1 answer One of the answers was accepted by the question author.

In Excel, I am in need of having more than one dropdown list in a worksheet, and I must be able to make multiple selections in each one.

I am familiar with VBA code and the Data Validation features built into Excel, but I cannot find a way to apply the VBA code to more than one dropdown list. I note that there is no dependency between each of the dropdown lists. In other words, the…

Developer technologies | Visual Basic for Applications
asked 2026-04-29T16:06:10.9133333+00:00
Fernando Castro 20 Reputation points
commented 2026-04-30T20:21:43.27+00:00
Fernando Castro 20 Reputation points
2 answers

Rename Module

I want to rename a module in my VB project in Excel

Developer technologies | Visual Basic for Applications
asked 2026-04-23T12:21:20.83+00:00
Donnie Urbano 0 Reputation points
commented 2026-04-29T02:33:30.55+00:00
Nancy Vo (WICLOUD CORPORATION) 3,465 Reputation points Microsoft External Staff Moderator
2 answers

Outlook, Character Counter, VBA

Good afternoon. I'm familiar with the character counter in Word. I checked the customize ribbon tool, and do not see character counter in outlook. At this point, I'd like to do a VBA tool to count characters/spaces in my emails. It's part of a…

Outlook | Windows | Classic Outlook for Windows | For business
Developer technologies | Visual Basic for Applications
asked 2022-01-28T00:53:44.547+00:00
Steve B 1 Reputation point
answered 2026-04-28T13:54:53.9666667+00:00
umer 0 Reputation points