Questions tagged as 'vba'

Tagged questions
1
answer

How to implement Factory default design in VBA?

I would like some methodology or example to try to simulate the application of the Factory project pattern in VBA.     
asked by 20.06.2018 / 17:49
1
answer

Multiple filters with VBA

Good afternoon party I need to filter on a worksheet column, collect a certain value, and delete the rest of the same column. I have this code but it only works for 1 tab. I need a cod for more than 10abas ... could anyone help me? follow the...
asked by 28.05.2018 / 19:26
1
answer

Call up a macro in different modules

Good morning, I created several macros, but I want to unify everything, the same are in different modules. How do I put them together and execute everything at once? Sub executar() MsgBox "Mensagem de aviso que ira iniciar"...
asked by 24.05.2018 / 14:44
1
answer

Problems in running VBA code

This code clicks on the 'Legislation' tab fills a field with a specific text (2nd For Each) and clicks the search button (3rd For Each). The problem is that when I run the code, it clicks on the tab and fills in the text, but it zeroes the field...
asked by 28.03.2018 / 16:47
1
answer

Update Selenium Frame VBA

Expensive, How can I do to update a frame with Selenium in VBA? Refresh frame is an option that exists when you right-click on a frame. I can not update the whole window, just the frame.     
asked by 16.03.2018 / 13:35
1
answer

EXPLORER HANDLING THROUGH VBA

Good morning, I'm starting to work with VBA so my question may be pretty basic, but my problem is this: When I run the code (which is below) it looks like an error alert in the 'For each' line    "Run-time error '438'. Object does not support...
asked by 19.03.2018 / 13:52
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