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
-1
votes
2 answers

Excel VBA compare data to column

I am new to excel VBA code. If someone could help me with it, I need it for an assignment. I have this data in Excel: What I want to do is: if the guardian is 'mother' than in the column of guardian edu it should display mother's education. If the…
arp
  • 1
-1
votes
1 answer

Access VB Editor - How to Hide When Updating Module?

I'd like to avoid having the VBE display for users. Here's the scenario: Access 2010 *.accdb which is used throughout the organization. When the user opens the database application, one of the modules is refreshed and resaved based on information in…
NWdev
  • 483
  • 1
  • 6
  • 19
-1
votes
2 answers

Why do I need to have the VBA editor open to load data into a Userform?

I have an Excel file in which a VBA macro loads data into a Userform. It will sometimes crash and close Excel if I run it without the editor open. How to fix my file so I don't need to first open the editor? Sample code from the macro: Public Sub…
offcenter35
  • 145
  • 2
  • 11
-1
votes
2 answers

Excel vba delete sub code

Regarding VBE. If a worksheet does not exist it will create it and add a commandbutton at Sheet1. It will also add the appr. code for the private sub commandbutton1_click. This works all fine. This is part of the existing code that will add a new…
ni_hao
  • 404
  • 2
  • 5
  • 16
-1
votes
1 answer

Split a single Excel row into multiple based on columns

I need to create multiple Excel rows based off of a single row. For example, I currently have a single row for each personnel and there are dozens of columns that are "grouped" so to speak. So say column K is its own group, then columns M, N, O…
treefiddy1031
  • 1
-2
votes
1 answer

linking two optionbuttons with single combo box for different rowsource

I have three sheets "display", "whole_list", "loose_list". I just draws one combo box and 2 optionbutton in display sheet. I have 200 item list in whole_list and loose_list. I wish to do that when I click on the optionbutton1 combo box will show me…
mohammad Ilyas
  • 5
  • 5
-2
votes
1 answer

VBE.h bunch of questions

I have this project that I need to configure some stuff about the graphics card and it is given a vbe.h file that I have no idea how use it. #ifndef __VBE_H #define __VBE_H #include /** @defgroup vbe vbe * @{ * * Functions related…
Verance
  • 137
  • 2
  • 13
1 2 3
…
14
15