Questions tagged as 'vba'

Tagged questions
2
answers

USERFORM: What is the difference between the Initialize and Activate routines?

What's the difference between using Initialize and Activate as a userForm's boot routine? Private Sub UserForm_Initialize() Private Sub UserForm_Activate()
asked by 27.04.2017 / 19:23
2
answers

Performance Excel VBA vs. Multhreads Calculation

I have a excel spreadsheet of 5M, but with many formulas and more than 7000 lines of code VBA . I would like to receive information on what I can do to improve performance. I would also like to know if it makes a difference to use all the core...
asked by 20.10.2015 / 04:22
2
answers

Enter a password in the VBA Project via module or SendKeys

Hello, I have a matrix spreadsheet that will go into thousands of smaller spreadsheets, save it to another extension, put a code inside it and want it to block the vba project from these smaller worksheets, I'm trying to use SendKeys for this, bu...
asked by 06.04.2017 / 16:18
1
answer

"Trace" in (VBA / Excel), how do I get the name of a subroutine?

How do I get the name of a subroutine (VBA / Excel) within itself to use in a "Trace" type code? ( See basic code in the UPDATE block after the sample code ) The idea is to use something like "ME.Name", which takes the name of the project....
asked by 25.11.2015 / 23:56
1
answer

Copy a range of Excel cells to an "image" object by VBA

I need to copy a strip from an Excel spreadsheet that contains a graphic layout made with borders around some cells, with some background colors and text, and visualize this layout in a VBA image. With the code below the cell range that makes...
asked by 01.02.2016 / 20:21
1
answer

Error putting other parameters in the Shell () function

I am trying to use the Shell() function of Vba in office 2010 , however it is returning me the following error:    Compile error       Expected Error: = My code looks like this: Dim programa As String: programa = "c...
asked by 10.06.2015 / 15:45
1
answer

Is there a way to remove the close forms button in VBA / Excel?

I want to get the close button of some forms in VBA / Excel. For example, I'm customizing the presentation of some messages to differentiate from VBA options that are unattractive. In addition to using different images, colors and fonts, i...
asked by 23.08.2016 / 01:22
2
answers

Error canceling file import in Excel

I'm building a Macro to import a file into Excel. At some point, when the file's location is requested, if the Worksheet user cancels the import option, the following error message is returned:    Excel can not find the text file to r...
asked by 13.01.2015 / 17:26
1
answer

Do you have a macro to create another macro?

I have a spreadsheet of analysts, however, when the analyst changes or some new one comes in I need to copy everything just like the other analysts just changing the name of it. I would like to know if there is a possibility of creating a macro...
asked by 29.06.2015 / 15:19
1
answer

Concatenate address in Excel VBA Range Object

I need to concatenate an address in the Range Object of Excel and I can not. The value is an integer variable. Here's the line of code: Range("O10").Formula = "=SUM(O12:O" & "valor)"     
asked by 10.02.2015 / 12:14