Questions tagged as 'vba'

Tagged questions
2
answers

AutoFill - How to select the second line

Dear, I have the following problem: I'm filling a cell with one formula and need to be duplicated for the other cells. So I'm using the code Selection.AutoFill Destination:=Range("C2:C329") Problem: Whenever I run this function, I mak...
asked by 09.10.2017 / 16:36
2
answers

Excel / VBA file more than doubles for no apparent reason when it is saved

I'm working with Excel and using some of the VBA programming features via modules (without using forms), and a problem has occurred, the file currently has 8MB and I continually save with another name, at a minimum, indicating new release...
asked by 05.04.2017 / 15:08
2
answers

Optimization in VBA code?

I have two spreadsheets, both have the same header, with 77 columns. For test I put 4 rows with data filled in one of the tables. In the table with the data filled in, I have the button with the macro, to copy this data to the worksheet that has...
asked by 22.02.2017 / 19:08
2
answers

Spreadsheet to discover city from zip code list

Good morning! I'm trying to create a VBA adapted to a spreadsheet I downloaded on the internet that separates all the values from a zip code. I would like to get the city and paste next to the zip code in the spreadsheet. I tried for mysel...
asked by 14.09.2017 / 15:20
1
answer

fmBackStyleTransparent does not work in Excel VBA

I have a VBA issue with Excel , and so I looked at other users as well and have no answer so far, like this link. BackStyle property = fmBackStyleTransparent does not work It happens that the property no longer works in the current, o...
asked by 28.10.2016 / 03:02
1
answer

Verify module name via VBA

Hello, I need to check the name of a module to change it later. The name of the module changes a lot, depending on each document, and can not run all possible names, as it would take a long time. For this I need a code that reads the modul...
asked by 12.06.2017 / 16:10
1
answer

Errors in using the Application.VBE object inside VBA

In support of this, " How do I inherit a form in VBA? " >, I followed the guidelines and examples from support.microsoft.com/en-us/kb/204330 with the purpose of generating forms dynamically. The code below refers to a form with two buttons...
asked by 16.05.2016 / 14:36
1
answer

How to use the name of a cell in the Excel worksheet in VBA, so that it does not indicate row and column?

How to use the name of an Excel spreadsheet cell in VBA, not to indicate row and column? For example, I gave the name "CustomerName" to cell B20, when I use this name in VBA to put in the label (label1.caption = CustomerName), it accepts and...
asked by 23.11.2015 / 22:19
1
answer

MACRO in Excel - print with sequential numbers

I have a macro from a few years ago that still works, when I click to print the production orders of my company, I put the start and end number, and the macro prints the OPs with the numbers in order, follows the macro : Sub PrintJobs() Dim i...
asked by 12.11.2015 / 13:55
1
answer

Force numerical format / language for the document

Where I work, it is very common to have problems with excel macros, which generate tables and graphs, depending on the language and version of Excel the client is using. How to force a language (for example English) and consequent numerical f...
asked by 06.04.2015 / 17:00