Questions tagged as 'excel-vba'

Tagged questions
1
answer

VBA - Max characters in the dropdown-list

' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _ "TESTE1;TESTE2;TESTE3;TESTE4;TESTE5;TESTE6;TESTE7;TESTE8;TES...
asked by 30.11.2017 / 18:10
1
answer

Translate Captcha

I am developing a routine that searches the debits and restrictions of vehicles in Detran, and to download the document, I need to undergo a Captcha validation, and this is already making me sleepy. I would like to know if anyone has managed to...
asked by 29.12.2017 / 13:10
1
answer

Find and Copy Sheet Row to Form, Change Fields, and Write to Same Worksheet with New ID

My question is this: I have developed a 20-field VBA form, which registers in the BDados worksheet, also inserting an ID. What I want is to find and Copy a record from the worksheet to the form, filling in all its fields after changing some of t...
asked by 20.01.2018 / 12:53
2
answers

Checking and filling Excel cells

I have the following spreadsheet as picture below, I would like to create a VBA to check if the content inserted in the cell range of that worksheet exists in the list of the second image below, if it exists, fill in the cell of the content of i...
asked by 05.09.2017 / 21:45
1
answer

How to separate edital String in Excel

I need to separate this type of String (Example): 1 Estruturas lógicas. 2 Lógica de argumentação: analogias, inferências, deduções e conclusões. 3 Lógica sentencial (ou proposicional). 3.1 Proposições simples e compostas. 3.2 Tabelasverdade. 3...
asked by 20.09.2017 / 20:13
1
answer

Rename PDF file [closed]

Good Afternoon Community, I'm trying to create a macro that renames 125 PDF files that are in a specific folder C: ... I want it to replace the name that is in my column B ... Type get the PDFs in the folder then rename them accordingly my sp...
asked by 27.07.2017 / 18:55
1
answer

Filtering Power Pivot Table by ListBox

This code: link Make the selection in the ListBox ... and Filter driven by a button .. as described in the link ... But if the PivotTable is created by Power Pivot .. This code does not apply ... You can do this same job in this creat...
asked by 07.08.2018 / 21:47
1
answer

VBA Excel - Index Match with two conditions

I have a spreadsheet with multiple tabs. On the first tab I have the following table: Intab2,typetheclientandtype,andIwanttoreturntheID.ForthisIamusingthefollowingcodeinVBA:tipo=ActiveCell.Offset(0,-1).Valuecliente=Range("D5").Value ActiveCell....
asked by 18.07.2018 / 20:50
1
answer

How to update the page of a site after changing the value of a field by VBA

Good evening. I would like to know how I can update the page with the date that I reported by VBA. I put the date but the page does not change. Since you do not have a button, I do not know what to do. Sub Links() Dim ie A...
asked by 11.05.2018 / 05:20
2
answers

Excel VBA - Run-time error '13': Incompatible Types

I'm getting the error '13' Incompatible types, in the line of the first If: Count = 0 For x = 1 To LastRow Step 1 If Cells(x, 8).Value = "Materiais" Or Cells(x, 8).Value = "Imobilizado" Then If Cells(x, 11).Value = "NÃO CATALOGO" T...
asked by 11.05.2018 / 19:49