Questions tagged as 'vba'

Tagged questions
2
answers

Split a worksheet into several worksheets

I have a spreadsheet with 5000 rows that needs to be split into spreadsheets with 790 rows at the most. How can I do this ??     
asked by 26.05.2017 / 04:20
1
answer

Is it possible to edit data in the ListBox? [closed]

Double-clicking the row to be edited from the ListBox opens the UserForm with the data of the selected row. I can not make the changes to be modified in the ListBox and the Spreadsheet. Code when starting the UserForm: Private Sub UserForm_Ini...
asked by 12.07.2016 / 18:52
1
answer

Migration from ATP to STP

Does anyone have an example to register a process and an intervention in the technical services module? I'm trying to migrate a project from technical assists but I can not see Sub Regista() Dim teste As AtpBEProcesso Dim objPedido...
asked by 19.09.2018 / 13:34
1
answer

Copy, Paste paste vba

Good evening, I need to filter the data in column B that contains "Cell 01"  I have some comments to make in the project. I need to copy the entire worksheet and paste it into a new file. 2- Keep the formulas in it. What can I use? F...
asked by 24.05.2018 / 19:20
1
answer

Error: Incompatible Types

I'm running a PROCV on one column, looking for values from another. The code runs up to a certain value and the error quoted appears. But there is no difference in the numbers, I have already put all values as the first one to test and continue...
asked by 12.06.2018 / 18:20
2
answers

USERFORM: I can not remove items from my ListBox (Error 80004005)

I have a ListBox in a UserForm that "rebuilds" based on a TextBox that I use as a filter. The idea is to bring all the items to the list with RowSource and remove all items that do not contain text from the TextBox. However, when testing the sys...
asked by 11.04.2017 / 21:43
2
answers

How to create objects dynamically based on vector? (VBA / Excel)

I created two Labels dynamically based on a vector according to the code below, however, in the form only the last Label created (NewLabel1) remains, both the first (NewLabel0) and the Label that I used the base for the creation of the other two...
asked by 17.03.2016 / 02:57
2
answers

How to transform a DLL created in C # to VB6?

I've created a pretty basic C # DLL, just to test. It looks like this: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Runtime.InteropServices; namespace CriarD...
asked by 31.01.2014 / 01:59
2
answers

MACRO to insert image in relation to the drop-down list

Good morning, I have a question that I do not know if it is light or not: I have a field (the large rectangle) of which I want to insert an image into it, depending on the drop-down list selected. For example: When I select in the drop-...
asked by 23.11.2018 / 11:43
2
answers

VBA - Read a .TXT file and manipulate its lines

I'm trying to make a Query generator using Excel (VBA), but I'm not able to manipulate some data inside a .sql file. Eg: Select * From Tabela t Where t.id = 1 <PROP> Whenever he finds a line that is written PROP he should swap for...
asked by 01.10.2018 / 17:55