Questions tagged as 'excel'

Tagged questions
1
answer

How to "concatenate" multiple values entered by a user into the table in a Msg box?

I'll try to summarize what I'm trying to do: I made a userform so that my user inserts data that will feed a table, it can put "n" information and the table will be formed according to the volume of data that it populates. After that, when...
asked by 03.05.2018 / 21:37
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
1
answer

Data manipulation in excel

I need to get the data generated from a proc save to some variable and make a UPDATE into a worksheet that already exists on a fixed path in the system. Is it possible to do this process via code? Ex. The procedure returned this...
asked by 04.10.2017 / 18:06
1
answer

Formula Excel with incorrect result

I have the following formula: =SE(1,5*Q2>F8<2*Q2;"RUIM";"BOM") In Q2 I have 44 and in F8 I have 70 and my result gives BOM . Where is the error?     
asked by 07.11.2017 / 18:02
1
answer

How to get the value of a cell with dynamic reference

For example: In cell A1 it will contain a number, which will be the line to be considered. In cell A2 I need a function to display the value of a cell as it is typed in A1 , something of type =B"A1" . As an exa...
asked by 16.04.2017 / 00:45
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

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