Word Edit visual basic - get to the Visual Basic Editor without going through a bunch of mouse clicks and menus

Question

Hello from Steve

Objective edit visual basic

Is this possible please.

Open using the macro icon in this case Right_Single then change ELLERSLIE to TIMARU

From

.ClearFormatting: .Text = "ELLERSLIE": .Wrap = wdFindStop

To

.ClearFormatting: .Text = "TIMARU": .Wrap = wdFindStop

Answer 1

Hello from Steve

In word is there a script that will open visual basic.

Hello Steve,

      ShowVisualBasicEditor = True

Will open/show the visual basic editor.

I am unsure why you would want this.

In the user interface, Alt+F11 will do the same thing. (Some computers also need the Fn key.)

Function Keys in Word 97-2024 (365)

Answer 2

Hello Charles

This is what I was after Alt+F11

I just could not think.

Thankyou

All the Best

Steve ****

Answer 3

Ctrl+H opens the Replace dialog, just .as it does in Word.

Answer 4

Hello Charles

Thank you

When I want to do an edit in visual basic I first use view, Macros and view Macros

I then select Right_Single and then edit, using Ctl H to bring up the Replace dialog box

I then type ELLERSLIE in Find What and I then type in TIMARU in the Replace with

Objective is for VBA to open the replace dialog box.

To do this I want to use the macro icon in this case Right_Single

which in turn will open the Right_Single, at this point I need vba to open replace dialog box,

for me to type ELLESLIE and TIMARU.

Hopefully this time it is understandable.

All the Best

Steve

Answer 5

Hi Steve,

I am unsure of your question.

In the Visual Basic editor, it is possible to use Replace to replace "ELLERSLIE" with "TIMARU"