Questions tagged as 'vba'

Tagged questions
1
answer

How do I make a list of clients appear in a search from the name in Excel? [closed]

I have a list of clients; I want to do a search where you enter part of the client's name and then all clients that have that name appear. Example: Customers' Rationale: João da Silva ME; Mariazinha Me; João Vitor ME; ... Search: John T...
asked by 05.10.2018 / 21:25
1
answer

Increment in String in VBA excel

A Strign in VBA excel has the following value: "T110A17014". I need to increment this string with each iteration. To increment only the last position the code below works! Now if we have this value: "T110A17099" and use the code below it will lo...
asked by 28.08.2018 / 07:47
2
answers

VBA - How to search for words from one list in another and point to "Found"

Good morning. I packed it. In plan1 column A I have a list of 20 different words. In plan2 Column C I have complex texts in every cell. I need to go through plan2 Column C looking for words contained in plan1 Column A if the wor...
asked by 19.07.2018 / 15:54
1
answer

Macro in Word to format WhatsApp conversations

Hello, I'm doing a macro to edit WhatsApp conversations. When you go to WhatsApp, open a conversation, touch the three dots in the upper right corner, touch "More," and then touch "Email," the conversation comes in a ".txt file ". I would...
asked by 13.07.2018 / 06:44
1
answer

Modify Last Selected Button

I have a UserForm containing several 1-20 selection buttons. When I press the Red Dye or Dye button, the last selected button should be dyed red or blue. Could someone help me work out this Sub?     
asked by 22.08.2018 / 14:45
1
answer

Copy data from one column (B) to another worksheet, if column (F) condition is met. excel

I have tried and continue to try various codes to automate the copying of data (column B, worksheet proposals) to another worksheet, also in column B, if column F of the "proposals" spreadsheet contains the terms "Accepts" or "Sent". Both wor...
asked by 16.05.2018 / 13:49
1
answer

Is there anything wrong with this code?

Function Check() Dim valorA, valorB, valorG, valor2 As String Dim rng As Range valorG = Cells(ActiveCell.Row, "G").Value valor2 = Cells("2", ActiveCell.Column).Value For Each rng In Range("A3:A321") Do While rng <> "" valor...
asked by 09.04.2018 / 02:33
1
answer

Error in searching in DataGridView

Hello, I have a Textbox where I insert a name automatically searches the DataGridView with data from the employees, for example if I type the letter "a" it will appear all the names beginning with the letter "a" but if the DataGridView has no nam...
asked by 26.03.2018 / 16:35
1
answer

How to manipulate IE objects that do not contain an ID? VBA Access

Good afternoon, I'm not able to manipulate (import value) objects (textbox) from an IE page, as these objects do not have ID. Here is the code I'm using Dim IE As InternetExplorer Dim Ulogin As Boolean, ieForm Dim NumProc As String: NumProc =...
asked by 26.03.2018 / 18:35
1
answer

VBA / Macro - Cleaning Data [closed]

Hello, I'm here here breaking my head on how to modify a spreadsheet through a macro. Can someone please help me? I have a worksheet (Plan1) that have the formatting A1: AF720. I need to create a macro so that it is split into several other s...
asked by 24.04.2018 / 14:03