Questions tagged as 'vba'

Tagged questions
1
answer

Extract data between specific lines of txt to worksheet in VBA

I am creating a code that will automate the reports at work from a button. The measuring equipment gives me a file in .MMF or .TXT, and there is an important part that I am breaking my head to be able to solve and I am a few days without advanci...
asked by 20.02.2018 / 16:54
1
answer

Limit characters and type of characters

I need some help. I have a worksheet like this: AndIwanttolimitamountofcharactersandtypeInthesegmentcolumnIwanttolimititto6charactersifitislessthan6ormorethan6.Returnsthemsg"Character limit not reached" In the date column I want to lim...
asked by 09.11.2017 / 17:04
1
answer

Get last column Access

I'm developing a small application that inserts data into a database in access. I am trying to insert the data however I wanted to get the last value of the inserted ID (automatic number) for a msgbox. provider = "Provider=Microsoft.ACE.OLEDB....
asked by 07.02.2018 / 09:34
1
answer

VBA + Excel. Error in code (Incompatible argument type Byref) in Function

The following code: Sub segundograu() Dim a, b, c, delta, raiz1, raiz2 As Double a = Range("B3").Value b = Range("E3").Value c = Range("H3").Value delta = b ^ 2 - 4 * a * c Range("E5").Value = delta If delta >= 0 Then raiz1 = x1(a, b, c)...
asked by 30.09.2017 / 11:56
1
answer

How to change a cell from "General" to "Number" and add comma?

I'm learning VBA and I had a hard time translating a column that has values formatted as "General" for number, moreover, I need those values to be expressed with a comma. Current values (sample): I know there is a simpler way to do t...
asked by 29.09.2017 / 16:10
1
answer

ComboBox does not update and accepts wrong values

Well, I have this code for a combobox, and I have two problems. First: I can not get the combobox to just accept the list values Second: Listing only has value PrivateSubTempCombo_Change()DimvAsVariant,iAsLongWithMe.TempComboIf.Value&...
asked by 13.07.2017 / 18:34
1
answer

Naming a cell

Good Night, I'm making a rule in vba that will rotate to all rows in the worksheet. So I created a variable, cells (l, 3)="ID", but when I call this variable in the formulas it is returning the word ID instead of the value in the cell (L, 3)....
asked by 01.03.2017 / 05:50
1
answer

Excel VBA check the contents of two cells

Good morning. I'm trying to create some modules in excel to help me at work, and one of the modules I created exchanges all the accented letters and special characters of a cell with unaccented letters and substitutes for the special characte...
asked by 13.03.2017 / 12:47
1
answer

Turn multiple columns into one

Hello, I do not program VBA and I am not able to make a code that would do the following: |A |B |C | ---------- |1 |6 |11| |2 |7 |12| |3 |8 |13| |4 |9 |14| |5 |10|15| My table has several columns like these up there, I would like you to h...
asked by 22.09.2016 / 17:31
1
answer

How to import data from the internet to excel vba

I'm trying to download a site's table: " link , and I've already" got it ". But there's a problem with my code. I want the user to set the team. This is done by selecting in a combo box on the site, well, I even change the combo box data, howeve...
asked by 31.12.2016 / 21:59