Developer technologies Visual Basic for Applications

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…

asked

Murray, ThomasJ (Penske) 15

edited an answer

ychi-7143 0

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

asked

Jackie Beedie 0

commented

DJ 0

2 answers

Application.Wait

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

asked

Randy Avery 0

edited an answer

Nancy Vo (WICLOUD CORPORATION) 3,385 Microsoft External Staff Moderator

2 answers

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 =…

asked

SteveD 310

accepted

SteveD 310

2 answers

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

asked

SteveD 310

accepted

SteveD 310

1 answer

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…

asked

Fernando Castro 20

commented

Fernando Castro 20

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.

asked

andy 0

edited a comment

Hornblower409 8,195

2 answers

Rename Module

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

asked

Donnie Urbano 0

commented

Nancy Vo (WICLOUD CORPORATION) 3,385 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…

asked

Steve B 1

answered

umer 0

2 answers

vba: I would like to add bold attribute to certain words (names) in an array

Hello from Steve I would like to please add bold text Sub Rename_Trainers() Dim FindArray As Variant Dim ReplArray As Variant Dim i As Long FindArray = Array("RICHARDSON NORV", "D & B WEATHERLE", "THURLOW O'MALLE",…

asked

SteveD 310

recommended

Dustin-TP 5 Microsoft External Staff Moderator

2 answers

vba: Compile Error: Expected variable or procedure, not module

Hello from Steve Compile error: Expected variable or procedure, not module Sub AddZeroBeforeThreeDigits() With Selection.Find .ClearFormatting .Replacement.ClearFormatting ' Find any 3-digit number as a group .Text =…

asked

SteveD 310

commented

SteveD 310

2 answers

Worksheet protection for users

I want to protect worksheets for users and grand vba all rights to adjust cells and add and delete listrows on tables

asked

Carlusha99 0

commented

Jack Dang (WICLOUD CORPORATION) 17,170 Microsoft External Staff Moderator

2 answers

Word Find second occurrence

Hello from Steve I have two "Word Files: opened Window 1 and Window 2 Objective please is to find second occurrence and selecting the text to copy using the below script Window 1 7 PLATINUM NORWAY Now find using the below script to find it in Window…

asked

SteveD 310

commented

SteveD 310

3 answers

Word How to loop

Hello from Steve How do I put in the below Script please Sub Scratched() Selection.Find.ClearFormatting With Selection.Find .Text = "Scratched" .Replacement.Text = "" .Forward = True .Wrap = wdFindStop …

asked

SteveD 310

commented

Nancy Vo (WICLOUD CORPORATION) 3,385 Microsoft External Staff Moderator

3 answers

Excel Row Height

Hello from Steve I would like please only Row 1 to Row 300 to have row height adjusted. Sub RowHeight() Cells.Select Selection.RowHeight = 20.25 End Sub Mod moved from : Microsoft 365 and Office | Excel | For home | Windows

asked

SteveD 310

commented

SteveD 310

2 answers

Word dollar blue no hightlight

Hello from Steve I need the below please dollar blue no hightlight Sub Dollar_Dollar_Blue_No_Highlight2() Selection.Find.ClearFormatting Selection.Find.Font.Size = 12 With Selection.Find .Text = "$" .Replacement.Text =…

asked

SteveD 310

commented

SteveD 310

2 answers

Word Color Red and Highlight Yellow

Hello from Steve I would like to please have the below script Color Red and Highlight Yellow Sub Dollar_Colour_Red_Bold() Options.DefaultHighlightColorIndex = wdYellow With Selection.Find .ClearFormatting .Font.Size = 12 .Text =…

asked

SteveD 310

commented

SteveD 310

2 answers

vba: Find and replace only one.

Hello from Steve Find and replace on a single find. VBA Sub AddZeroBeforeThreeDigits() With Selection.Find .ClearFormatting .Replacement.ClearFormatting ' Find any 3-digit number as a group .Text =…

asked

SteveD 310

commented

Taki Ly (WICLOUD CORPORATION) 1,020 Microsoft External Staff Moderator

2 answers

trying to open a document in Word VBA using Document.Open command, command failed

got runtime error 4198, command failed; filename and path much less that 219 character limit

asked

Edward Evans 40

commented

Leon Tran (WICLOUD CORPORATION) 1,740 Microsoft External Staff Moderator

1 answer

Word if not found then

Hello from Steve Objective if not found then move to next Sub Moving_Numerals() Application.ScreenUpdating = False Do Selection.Find.ClearFormatting Selection.Find.Font.Size = 12 With Selection.Find .Text = "|" .Replacement.Text =…

asked

SteveD 310

commented

Surya Amrutha Vaishnavi Lanka (INFOSYS LIMITED) 2,115 Microsoft External Staff

Developer technologies | Visual Basic for Applications

Filter

Content

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

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

How can I read an excel sheet from AccessCan I

Application.Wait

Word finding X at the beginning of numerals

Using VBA to select text.

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.

Office 365 Update version 2604

Rename Module

Outlook, Character Counter, VBA

vba: I would like to add bold attribute to certain words (names) in an array

vba: Compile Error: Expected variable or procedure, not module

Worksheet protection for users

Word Find second occurrence

Word How to loop

Excel Row Height

Word dollar blue no hightlight

Word Color Red and Highlight Yellow

vba: Find and replace only one.

trying to open a document in Word VBA using Document.Open command, command failed

Word if not found then