Stack Overflow
Stack Overflow

Questions tagged [vbe]

Visual Basic Editor is the built in IDE for writing VBA. It is hosted by various MS Office programs. Use this tag for general questions about the IDE or the Microsoft VBA Extensibility Library (VBIDE) which allows automation of the Visual Basic for Applications Editor.

Visual Basic Editor is the built in IDE for writing VBA. It is hosted by various MS Office programs. Use this tag for general questions about the IDE or the Microsoft VBA Extensibility Library (VBIDE) which allows automation of the Visual Basic for Applications Editor.

VBE has three key elements: Code window (on the right); Projects window (top left), and Properties window (bottom left). Example for Excel:

VBE example

Others may be added, for example for Watches.

217 questions
0
votes
2 answers

Editor shows unseen question marks

On my Worksheet cell I see text I want, but in the editor it shows question marks.
Assaf
  • 89
  • 2
  • 8
0
votes
1 answer

VBE Add-In - How to do a "Save All"

Im writing an AddIn in C# for the VBA-Development-Environment (VBE) in ms-access. (See also here: Build add-in for VBA IDE using VB.NET ). The VDE does not save its code moduls when starting an VBA-Program. As Im implementing a "Start…
Gener4tor
  • 414
  • 3
  • 12
  • 40
0
votes
2 answers

Intellisense in VBE not fully functioning for objects

I've seen in online tutorials Intellisense works the magic: while you key in the object name, it auto complete it for you. Why my VBE doesn't? It works on properties and methods, but not objects. I'm using Office 2010, maybe the feature is not…
Jing Wang
  • 23
  • 4
0
votes
1 answer

Error while populating a dependent dropdown list in Word

I used this code: Sub PopulateddState() Select Case ActiveDocument.FormFields("ddRegion").Result Case "North" With ActiveDocument.FormFields …
Arin Kulshi
  • 3
  • 1
  • 2
0
votes
2 answers

Delete a Module in Outlook Project

Can I delete an Outlook VBA Module? I have tried the below code: Dim vbMod As Object Set vbMod = Application.VBE.ActiveVBProject.VBComponents vbMod.Remove VBComponent:=vbMod.Item("Module2") But getting an error: 438 Error, Object doesn't support…
Koushik Padmanaban
  • 1
  • 1
0
votes
2 answers

Excel events ignored / no longer being caught i.e. Worksheet_Change not being entered on change

I am working on a complex spreadsheet based solution. Occasionally a user will experience a problem where the events in the sheet seem to no longer be caught by Excel. I cannot replicate this behaviour at present, but I have visted the PC in…
FinancialRadDeveloper
  • 984
  • 4
  • 13
  • 28
0
votes
1 answer

Updating a macro to be identical across all worksheets (or making the code more global?)

I have a workbook with a few dozen worksheets, which is growing. I might also end up with copies of this workbook pretty soon. Each sheet is based on the same worksheet template, which includes a macro on its Worksheet_Change event for…
Gee
  • 59
  • 2
  • 9
0
votes
0 answers

Rubberduck: not available in VBE, but loaded in Add-In-Manager

maybe similar to Can not see the add in after installing rubberduck?, but the answer there (the default installing instructions) does not work for me. After Admin-Installing Rubberduck 2.1.0 or also tried with 2.1.1.2450-pre I cannot see the…
MI285
  • 21
  • 5
0
votes
1 answer

CodeModule.Find Method changes value of variables (Find Method VBA Add-In Object Model)

I am trying to search the current VBProject for instances of procedure names. To do this, I am using the CodeModule.Find method (details here), which asks for: A search term (I am supplying a string variable) the start line (I am supplying a long…
mattbierwirth
  • 77
  • 1
  • 7
0
votes
3 answers

How do I reset my Visual Basic Editor Layout?

Something has gone terribly wrong with my VBE layout. I originally closed my Project explorer and was trying to figure out how to restore it when I made some changes under the window tab of the ribbon. I've restored the Project explorer but I…
W.Harr
  • 303
  • 1
  • 4
  • 15
0
votes
0 answers

Failed to clone remote repository

I can not clone and get a 403 error code. The user name and password I entered are the ones I use to login to GitHub and are correct. Please advise, thank you.
David
  • 23
  • 2
  • 6
0
votes
0 answers

Rubberduck VBA: Commit Failed

I added the files to commit, and clicked in Commit->Go, but I get the following error: Commit Failed: Configuration value 'user.name' is missing or invalid Is something I did wrong? Do I need to create a config file to add the user name? Thanks
tdmsoares
  • 533
  • 7
  • 24
0
votes
0 answers

Write to Excel ActiveX TextBox C#

I have a C# program, and I want to write C# textbox string to excel ActiveX TextBox. I can open a sample xlsx, write to cells, export as pdf... But cant write to textbox. I have found another question here, which could be the soultion (Reach…
donmichael
  • 68
  • 6
0
votes
0 answers

How to display debug message rather than error message?

My VBA editor used to show a debug message when an error occurred. When I use VBA on another computer it only pops up an error message. How can I set the debug message box to appear again?
pexpex223
  • 371
  • 4
  • 10
  • 25
0
votes
2 answers

Combining macros in Excel

I'm trying to combine/nest 3 different functions in Excel VBE: open, loop, and click. I have them written out separately, but am unsure of how to combine them. I've tried the "call macro" function but got a compile error returned to me. The goal is…
Kera Mogilevsky
  • 1
1 2 3
…
14 15