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
1 answer

How can I enumerate the loaded add-ins in Access?

If I have a database open, and I've used the Zoom functionality (Shift + F2) in a table field, then Access has opened the Utility.accda add-in (as evidenced by the appearance of Utility in the VBE). Some other actions will also open ACWZTOOL.ACCDE.…
ThunderFrame
  • 9,352
  • 2
  • 29
  • 60
0
votes
1 answer

Make a VB6- or VBA-IDE environments related reference in IDE Add-In?

I successfully created in VB6 the VB6_IDE_Add_In, that has references to Microsoft "Visual Basic 6.0 Extensibility". However, to use this add-in in VBA IDE (Excel, Access) I obliged to make a copy of VB6_IDE_Add_In project, rename it to…
user6698332
  • 407
  • 3
  • 14
0
votes
0 answers

VBA Excel - Executing a command in a Range - Interacting w/ other workbooks

I have been trying how to figure this out for awhile now. I locked my vba project, because I don't want most people to be able to altered the code. The problem is, I have code that modifies other modules based on user input, this obviously would…
Singularity20XX
  • 321
  • 5
  • 20
0
votes
1 answer

In Userform how to link the value of a textbox dynamically to that of another thing like Spinbutton or checkboxes

I am curious how to make the value of a text box dynamically change when you select a different option button or toggle with a spin button. What I have tried so far is Userform1.textbox1.value = spinbutton1 Is there a better way to do…
Zack Withrow
  • 125
  • 1
  • 2
  • 11
0
votes
0 answers

Saving Modules correctly using Access-Interop

Even though my last questions weren't accepted well, I will give it another try. I'm working on a program that is capable of controlling a lot of office-application behaviour by using the COM/Interop-Interface Microsoft provided for…
prizm1
  • 363
  • 1
  • 11
0
votes
1 answer

How can I get a variable information in VBE , While my mouse point out it?

How can I get a variable information in VBE , While my mouse point out it ?
Prectice
  • 1
  • 1
0
votes
1 answer

Outlook 2013 VBA VBE F8 Sometimes Doesn't Work

When debugging code in the Outlook 2013 VBA Visual Basic Editor, sometimes the function key F8 Step Into is totally ignored. The Debug Toolbar Step Into works just fine. When this occurs it seems to go on for many lines of code, and then sometimes…
Kenneth Berg
  • 77
  • 1
  • 1
  • 10
0
votes
1 answer

Get a list of the macros of a module in excel, and then call all those macros

Please help with the following: 1) A code that sets a list of all macros of "Module3", and place this list in "Sheet5", starting in cell "E14" below. 2) Then, the code should run all the listed macros I tried with a code that referred VBComponent,…
Flavinho
  • 19
  • 2
  • 6
0
votes
0 answers

Unlock password protected VBE project, run code then lock again

I am using the following code upon start-up to compile my workbook to prevent any Active-X related errors: Private Sub ThisWorkbook_Open() Set compileMe = objVBECommandBar.FindControl(Type:=msoControlButton, ID:=578) compileMe.Execute End…
Examorph
  • 143
  • 1
  • 1
  • 7
0
votes
1 answer

Where can I find a simple and useful list of VBA objects and methods for a beginner?

I tried pressing f2 to get the VBE thingo open and it just looks like jibberish to me. I need something nice and simple which gives me a heirachy of what key words to use and where to put the dots so that I can do what I need to do and start…
user3528592
  • 57
  • 8
0
votes
1 answer

Converting word dialog to VB

It has been a long time since doing any type of coding. I've been tasked to send a test page (looks like old TV test pattern page) to all of our printers prior to shift start. These pages will help our team determine if there is any physical…
Chris Simmonds
  • 1
0
votes
1 answer

VESA via IO/Port

How can i access vesa modes via IO/Port for x86 CPU? I already tried a code which works only on Bosch private static void SetVideoMode(ushort width, ushort height, ushort depth) { WriteCommand(0x4, 0x00); WriteCommand(0x1, width); …
amaneureka
  • 1,150
  • 11
  • 26
-1
votes
1 answer

Locked from viewing files not listed in VBE Project Explorer as before

After a fresh installation of Windows 11 I am unable to see some of my VB projects in the projects window. These projects were locked for viewing and had passwords set. I know the passwords. Before the refresh, I could see them listed and was able…
Miguel de las Nieves
  • 117
  • 8
-1
votes
1 answer

Comment block icon is not visible in excel vba

I tried searching in various forum but could't find the answer. I am unable to find the comment block option in excel vba.enter image description here
Alex Vincent
  • 1
  • 1
-1
votes
2 answers

VBA Security : my vbe password is well-set, but still can be hacked by a simple code

I have a xlsm workbook and with 2 sheets, I call it as workbook 1, sheet 1 is visible, sheet 2 is set as xlsheetveryhidden. And then vbe password setted. Now the situation should be no one can unhide sheet 2 manaually, right? Now I open another…
Yung Lin Ma
  • 121
  • 2
  • 14
1 2 3
…
14
15