Skip to main content
229 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
1 vote
2 answers
251 views

I have a procedure to create a new worksheet. The name of the worksheet differs based on language localisation selected, so I found it convenient to work with the worksheet codename. Codename is ...
Eleshar's user avatar
  • 547
0 votes
0 answers
71 views

I am running macro-enabled Excel file in one of the server computers in my organization. When I try to use the Find option in VBA developer window, it does not work. For example, when I use Ctrl+F or ...
hbstha123's user avatar
  • 1,820
1 vote
2 answers
170 views

Please run the following code for testing needs. Public Sub Macro1() 'Delete all charts For i = ActiveSheet.Shapes.Count To 1 Step -1 If ActiveSheet.Shapes(i).Type = msoChart ...
Kram Kramer's user avatar
  • 121
0 votes
0 answers
121 views

When I try to open the VBA editor in Excel (365), the window opens up and no button is clickable, there is just a huge font text in the middle (not readable) - it seems like the text is in Spanish or ...
levi's user avatar
  • 41
3 votes
0 answers
1k views

On a pretty regular basis, the VBA Editor breaks somehow, so that I can't step into code (either by pressing F8 or clicking on either the 'Step Into' button or the 'Run to Cursor' button in the "...
Tim Kipp's user avatar
  • 31
0 votes
2 answers
162 views

All language settings (Windows 10, Office 2021) are set to French. MsgBox does not display the accents. In the VB Editor: At run time: In the Project Object list: Where is the setting if existing? ...
Jean-Paul's user avatar
  • 11
1 vote
1 answer
65 views

The macro below exports data to separate files (a single table / single worksheet to one workbook). I am attempting to add code to the worksheet to highlight updates made by users to the values in the ...
cdfj's user avatar
  • 167
0 votes
1 answer
104 views

I created a simple tool that extracts an Excel file into a folder and, conversely, gets this folder and regenerates the Excel file. This tool also extracts the VBA code to text files in order to make ...
Paulo Santos's user avatar
  • 11.7k
0 votes
0 answers
44 views

I am trying to insert below data into access Table thorough vbe but only one record insert in table Sample file as below: {"GenericCorporateAlertRequest":\[{"Alert Sequence No":&...
Surendra's user avatar
  • 1
1 vote
1 answer
86 views

I am doing a tracker where I have two main tabs - "Home" and "MasterFile". "Home" is the tab sheet where they will place the date today in cell B2 (since every month we ...
jen 's user avatar
  • 37
0 votes
0 answers
92 views

Excel VBA was working then the VBE started to have the following issue: When I type it reformats automatically causing the code to be formatted incorrectly. Example: I type: Range("a2") ...
WWTF's user avatar
  • 11
1 vote
2 answers
232 views

I've lately been observing that Access and VBE hang for 5-10 minutes when opening a form in Design View. During this time, the application shows as not responding in Task Manager. This does not occur ...
ebsf's user avatar
  • 211
0 votes
1 answer
61 views

Im doing a worksheet in VBA where i need to reference a cell from another worksheet to get a value, is there a better way to do then doing one by one as i am doing in the code bellow. Sub cotações() '...
Rike's user avatar
  • 1
0 votes
2 answers
494 views

I have multiple Excel files to change automatically one of their module's code. As each VBA project is protected, I need to unprotect each one. Further information: https://www.mrexcel.com/board/...
Marctrix's user avatar
  • 11
1 vote
0 answers
223 views

I found this problem when I want to open an Excel document sent by my co-worker, the file has a macro in it but I can't find a way to enable it. When I click to enable macros this always happens and ...
Devis's user avatar
  • 11
0 votes
1 answer
825 views

In Excel, the VBA editor uses German instead of English and I have tried various things to try and change it, such as repairing Office 365 and checking the default language settings, without success. ...
Jeff Broome's user avatar
  • 1
0 votes
1 answer
689 views

I have Three buttons on a User form Run, Pause, Reset. Reset Button ends the code execution, Pause button Breaks/pause the code execution using STOP Command, Run button should restart the execution. ...
Karan Talwar's user avatar
  • 3
1 vote
1 answer
328 views

I have been using the vbeditor for many years but suddenly I can no longer "drag & drop" the current line execution arrow like before. I can't interact with it at all. I can't pull it up ...
HelpSeeker's user avatar
  • 11
0 votes
1 answer
157 views

I am a C++ developer trying to convert something to VBA to replace a call to a legacy ActiveX control. We have over 100 spreadsheets that rely on an ActiveX control written about 20 years ago. The ...
Spencer's user avatar
  • 1
0 votes
1 answer
330 views

I have been having tons of trouble with one macro-enabled file in particular. I have numerous Subroutines, all of which are Public and do not require arguments. These macros do not appear in the macro-...
DRC's user avatar
  • 33
1 vote
0 answers
199 views

I am working on a retro computer project that needs somewhat high resolution video output (at least 800x600 16 bit color). All retro computers (by this I mean anything before 80286) I am aware of use ...
Stan K's user avatar
  • 11
0 votes
1 answer
95 views

I'm getting "Object variable or with block variable not set" (Error 91) on the below mentioned line. Set cmd = ActiveWorkbook.VBProject.VBComponents("UserForm1").Designer.Controls....
KoolGuy90's user avatar
  • 11
0 votes
1 answer
108 views

I have been trying to understand all of the properties that I see listed in the Locals window in VBE. Why do some objects have infinitely nested, identical properties? The Range object has a Cells ...
J71's user avatar
  • 1
3 votes
2 answers
214 views

I have a macro that adds a very long formula to one of the cells. Is there a way to break up this formula in the VBA editor to make it easier to view and edit. Sheet3.Select Dim lastrow As Long ...
sixSeven's user avatar
  • 33
0 votes
0 answers
31 views

Compiler says than Componente.SaveAs object doesn't support this property or method. Microsoft Help: https://learn.microsoft.com/en-us/office/vba/language/reference/user-interface-help/saveas-method-...
elreymon's user avatar
  • 1
0 votes
1 answer
62 views

Does VBE Intellisense allows us to choose an Excel constant (xl...) from its dropdown list? For example, regarding the code below, when I type r., I can choose Cells from a drop-down list. Then, ...
sergio trajano's user avatar
  • 321
1 vote
0 answers
79 views

I realized that VBA Editor (Excel 2019 VBE) change case of variables when you have different variables (different scope) but same name with different case. For example, we have the code below, which ...
sergio trajano's user avatar
  • 321
0 votes
0 answers
179 views

I'm trying to put foreign language (Myanmar/Burmese) in email body. The word turned into gibberish characters when it is sent, showing "???????". Is there a step I'm missing or a workaround? ...
WaeYan2993's user avatar
  • 1
0 votes
1 answer
3k views

What is VBAProject? Is VBAProject my Program.xlsm file because if I replace with that I get the same error. I tried adding to find the name: Dim myString As String myString = ThisWorkbook.VBProject....
Joe Campanini's user avatar
  • 11
1 vote
2 answers
412 views

Following Outlook VBA code is triggering only when the Visual Basic Editor is open. I tried other events. All are working when VBA editor screen is open. Private Sub Application_NewMail() Dim ...
Rupesh Kumar's user avatar
  • 11
0 votes
0 answers
179 views

My company uses a PowerPoint presentation that has linked Excel charts (namely, linked binary worksheet objects). Each month, the name of the workbook changes (from Feb to Mar, for instance) and the ...
C111's user avatar
  • 1
0 votes
1 answer
245 views

One of my Excel VBA programs has a worksheet name in Hungarian that contains a letter not found in English or other Latin-character languages. Please note I am not referring to “Hungarian Notation” ...
Soproni's user avatar
  • 5
3 votes
2 answers
166 views

What is a good practice of getting the named ranges of my sheet from VBE Intellisense? I have created a workaround of getting the named range from the class module of a sheet, but I think is is too ...
sergio trajano's user avatar
  • 321
0 votes
2 answers
254 views

I'm making a VSTO Addin for PowerPoint in C#, which adds a better project explorer. I've been making it in a userform, however it would be better if the window would be part of the VBE editor (aka ...
Daniel Clímaco's user avatar
  • 95
0 votes
1 answer
4k views

I can't set Sheet.Name property in Japanese. Event file name also displays in maybe Chinese? All display well in Excel. How can I set up the VBA editor to work with Japanese? I changed region to ...
dellos's user avatar
  • 367
3 votes
2 answers
931 views

I was trying to create an Excel button in a sheet from a C# code, using a C# event hander for the button, so I don't have to involve VBA and text scripts; and I found this great solution from @ Dummy ...
Daniel Möller's user avatar
  • 86.8k
2 votes
3 answers
988 views

I am trying to create a VBA function that parses VBA code. I'm at the stage where I'm trying to put in an array variable all the instructions present on a line of code. For example the following code ...
ODEXT's user avatar
  • 35
1 vote
1 answer
2k views

I have working code where the only issue is that it opens the Visual Basic editor while it's running, closes it, then reopens it when it's finished. I believe this is because I am creating workbooks, ...
Deinceps's user avatar
  • 31
0 votes
3 answers
157 views

Normally when using the VBA editor, code autosuggests from available methods.properties for whatever object being referenced. I'm trying to pull data from an Excel sheet into a Word document using a ...
KingFate's user avatar
  • 3
-1 votes
1 answer
100 views

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 ...
Miguel de las Nieves's user avatar
  • 117
0 votes
1 answer
93 views

Translate formula quotation marks incl. replacements into VBA-readable formulae I was inspired to write this post by the recent question of formula substitution using a constant. At the same time, the ...
T.M.'s user avatar
  • 10.1k
0 votes
0 answers
888 views

Using Excel 365. I accidentally clicked to hide a module. (right-click module >> select Hide) All this appears to do is close the Project Explorer and Properties Explorer Windows I clicked View ...
Winston Snyder's user avatar
  • 67
5 votes
3 answers
1k views

I would like to go through and find all of the "End" statements in my code but skipping all of the "End x" statements like "End If", "End Sub", "End ...
ScottC's user avatar
  • 51
1 vote
1 answer
184 views

I know how to change the EDITOR code window font but cannot find a way to change the font in the other windows. I don't want to change the screen resolution as I usually have other apps open as well. ...
user2979974's user avatar
  • 23
0 votes
0 answers
78 views

I have a strange behaviour, with both Excel 2010 and Excel 2019 (both in Windows 10 64 bit). I have a file with lots of VBA code and a certain Sub that creates a new sheet and copies data from two ...
Dolphin975's user avatar
  • 335
1 vote
1 answer
119 views

How does one set the default directory for the VBA Editor? This ought to be obvious in any application, not to mention an obligatory feature, but I can't figure it out. Having to navigate up and over ...
ebsf's user avatar
  • 211
0 votes
1 answer
150 views

I want to replace certain elements in the code with others. For example : C.Offset(0, 1).Value = 0 to C.Offset(0, 28).Value = 5 With the help of VbaEditor I can find the number of rows and columns of ...
maxim465's user avatar
  • 195
1 vote
1 answer
389 views

I've written code to change the contents of a cell in multiple protected workbooks looking up the value to be inserted from a table in my worksheet. The issue I have is that when I select a file in ...
Matt Drake's user avatar
  • 156
1 vote
0 answers
999 views

While I am writing my own OS, this question comes to my mind! Is it Possible to write own video drivers like VGA, VESA ( In BIOS ) and GOP, UGA ( In UEFI ) ,if yes then how?
Vapour Dev's user avatar
  • 90
1 vote
1 answer
505 views

Currently im working with excel vba. I'm asking myself if there is a possibility to count the variables declared in a user defined Type as shown below. Public Type NameOfType a as string b as ...
McFly's user avatar
  • 25

1
2 3 4 5