Most voted "vba" questions
Visual Basic for Applications (VBA) is an event-oriented programming language with limited object support, used to write macros, available for the entire Office suite.
Learn more…792 questions
Sort by count of
-
-1
votes1
answer318
viewsUsing Formular1c1
Hi, I’d like to ask you a question. My code is responsible for reading a column, if the value found is different from the previous one, it adds a row, paints a specific color and in the reference…
-
-1
votes1
answer274
viewsClick on Button using Selenium Basic with VBA
I’m trying to do an automated data search on a page of my work, and I can’t get past the login part, I can enter Login and Password, but all attempts to access the "Sign in" button are in vain. I’m…
-
-1
votes1
answer145
viewsRead string from one column and return values in another in vba
Hello, I don’t know much about VBA and wanted to know if someone could help me. I would like to know how I can take a string from a column(e.g., A), read its data and return it in a new column. In…
-
-1
votes1
answer25
viewsCode with Repetition vba
The code below does not execute on the following lines: Sub concatena() linha = 13 Do While Cells(linha, 2) <> "" Dim Data As String Data = Cells(linha + 1, 2) Range("q13").Select…
vbaasked 4 years, 7 months ago Dione Oliveira 1 -
-1
votes1
answer85
viewsI am trying to fill out a form in vba and will not pq?
someone knows how to fill a google Forms with vba , I got a few lines but it does not fill everything ,I can fill, no inspect elements appears filled but does not fill in the page Public Sub…
-
-1
votes1
answer100
viewsError in macro execution in Libreoffice
Good morning. I am trying to run the following macro in Libreoffice Calc: Rem Attribute VBA_ModuleType=VBAModule Option VBASupport 1 Sub busca_cep() Range("B3:D3").ClearContents Set ie =…
-
-1
votes1
answer121
viewsProcess automation - Excel - VBA
I am trying to automate a process of my service. However while running the code it says that "A variável do objeto ou a variável do bloco 'With' não foi definida". What I’d like him to do is: That…
-
-1
votes2
answers440
viewsVBA reverses day with month in variables of type Date
Context: I have the following code that receives from the user a date: dataAtualDefault = Day(Date) & "/" & Month(Date) & "/" & Year(Date) dataInsercao = Application.InputBox("Data…
-
-1
votes1
answer668
viewsCondition in VBA if Date reported in Textbox is Higher or Lower
I have a macro for the Date that the user entered in Textbox, for minor that the date of a cell of a given row, I will make a change in the information of a column of this row. Sub test() Dim data…
-
-1
votes2
answers234
viewsCalling module inside another module in VBA Excel
I am having some problems to import one module inside another in my VBA code. Basically, I have a work order spreadsheet where I have a macro button in the range of options that I have customized in…
-
-1
votes1
answer38
viewsDoubt in the execution sequence of the vba code
Hello I’m new around here, I have two codes, one that searches the image by code, which runs instantly simulating a procv. And a macro that is executed in the change of the cell, to erase the first…
vbaasked 4 years ago Eder Oliveira 1 -
-1
votes1
answer25
viewsDsoma using form as source
Halp! I need a text field in my form to show the sum of a given field, where the form is the source using a criterion. I can get Dsoma to run with the code below. However, as the source is the…
-
-1
votes1
answer31
viewsBecause VBA returns #value error
Hello I have the following vba code which is a function that takes three parameters and calculates the functions Bult-in trend and rquad and depending on the result it returns trend or the average…
-
-1
votes1
answer92
viewsMacro to copy and put using VBA Excel
I am learning VBA to streamline my service in the company, but I am stuck in the following part: I was developing a macro that in theory would make the following path: 1° Move mouse to A2 cell 2°…
-
-1
votes1
answer63
viewsVBA Outlook - Operation Failed
I made a macro in Outlook 2016 that runs as soon as a new email arrives. But sometimes the screen appears below at the time the email arrives: And if I ask the person to send a new email exactly…
-
-1
votes2
answers28
viewsCan I make the document generated in the VBA code below be saved in the source file folder or that it asks to save in a specific location?
I am creating a macro in Excel that selects a text and pastes in another tab of the spreadsheet and generates a . pdf automatically. I want to try to make the user on another computer save this file…
-
-1
votes1
answer26
viewsCopy table data sequentially with VBA
Good morning! I really need help. I’ve been doing an indicator for meeting minutes. Throughout these meetings the worker writes the minutes in the inclusive excel table problems or improvement…
-
-1
votes1
answer18
viewsMsgbox when he can’t find the search doesn’t show up
Msgbox in bold does not work. Or when it works it does not take the data located. sub MSIAPE() Application.Screenupdating = False Dim MSIAPE As String Dim Celula As Range Dim Valor Dim Assunto As…
-
-1
votes1
answer33
viewsSend Emails with VBA attachment
I declared a variable to go from line to line with a repeat loop For to write the emails. Works all neat until you get to the append part of the file, it shows the error image below. I have tried to…
-
-1
votes1
answer26
views -
-1
votes0
answers27
viewsSelect WEB combobox with VBA
I have a code in VBA that should insert data on a site, I can insert the text, but there is a macro behind this code that when clicking on the text it opens more text boxes. What code should I enter…
-
-1
votes1
answer58
viewsExcel Spreadsheet Macro - VBA - Application definition or object definition error (Completed)
I am creating a macro by Activex Command Button, where it will first select specific cells, each column at a time(AT2:AT15, BI2:BI15, BX2:BX15) and sort them from A to Z. After, in these same cells,…
-
-2
votes1
answer1375
viewsHow to convert a project from VB6 (.vbp) to VB.NET (.vbproj)?
I decompiled an application in VB, only it wasn’t . NET, it was VB6. I would like to know how to convert as I already used Vbto Converter and it crashed into one of the files. I am waiting quickly…
-
-2
votes1
answer52
viewssearch in two worksheets with a form in vba
good afternoon people! my problem and the following: I have a form with 2 textbox one for students' names and another for the classroom and a spreadsheet with two tabs with the same names…
-
-2
votes1
answer670
viewsHow to add a Textbox dynamically using VB
How to add a Textbox dynamically, whenever the Userform (List Data Combination or Validation Box) is equal to "Outro (Especificar)", using VB ? I’m lost, I’m new to making macros and forms, using…
-
-2
votes1
answer492
viewsIs it possible to add a conditional to a combobox options? VBA
0 I am developing a form by VBA Userform and would like to generate a conditional on it. I got two Combobox. The first allows choosing between only two cases, A and B. I would like the second to…
-
-2
votes1
answer40
viewsHow to modify this programming to accept letters and numbers?
Private Sub TNumero_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) If (KeyAscii < 44 Or KeyAscii > 57) Then If KeyAscii <> 8 Then If KeyAscii <> 13 Then KeyAscii = 0 MsgBox "É…
-
-2
votes1
answer63
viewsMacro does not send emails
My macro does not send emails... it has the following options, open Outlook and do not send email, or send... but it just opens and does not send.. **' VERIFICAR SE DEVE ENVIAR OU APENAS EXIBIR O…
-
-2
votes1
answer41
viewsHow do I write this formula in . formula?
How I write the formula below in . formula in vba? =SE(J5="OK";"Realizado";SE(E(J5="NOK";I5>0);"Não realizado";SE( E(J5="NOK";I5<0); "Não realizado")
vbaasked 4 years, 10 months ago lucassantos 1 -
-2
votes1
answer333
viewsVBA Automation Development - Loop Error Handling
I am developing an automation in VBA that accesses a certain site and takes some information from it, however I’m having a problem in this. The site (Santander - Benner) is very badly done, many…
-
-2
votes1
answer1247
viewsShare workbook with VBA
I need to share a workbook on the network, but when running the code the file goes to the folder C:\Documents\. What would be the solution to this problem? Private Sub btExecuta_Click() Dim…
-
-2
votes1
answer2820
viewsControl new Google Chrome tab with Selenium VBA
I’m writing a code to liquidate some operations on a website. Directly from excel, through VBA, using the SELENIUM library, I wrote a code to log in and fill in fields with information directly from…
-
-2
votes1
answer20
viewsFractional to decimal conversion in VBA
Good morning, I need to run a program that converts a fractional decimal to binary. If I don’t have an exact representation, I must enter a number of significant digits. However, I’m not able to…
-
-3
votes2
answers9083
viewsVBA function to make text uppercase
Good afternoon. How to capitalize the spans of just a few cells of a form mounted on an excel sheet? Numeric and e-mail field cells should not be altered. I only found formulas and functions for…
-
-3
votes2
answers61
viewsIs there any way similar to the python . format method for VBA in Excel?
In python using the . format for this: users = ['profile1', 'profile2'] print("www.instagram.com/f{users[0]}/") Would soon come out: www.instagram.com/profile1/ Is there any similar method in vba?…
-
-3
votes0
answers22
viewsProblem with IE interaction in Vba, I can’t save
I’m new around here! I’m having a difficulty with save button, on windows screen, I’m doing an IE interaction in vba, enter a particular site, I dowload the file, I click save as, it goes to the…
-
-3
votes2
answers82
viewsDoubts in the combobox
I have two combobox, the first is the managers and the second I have the coordinators. MANAGER - FABIO - ADRIANA - LEANDRO COORDINATORS - TEREZA - GERALDO - GABRIELE - JOICE - VALDIR -ROSE - KATIA…
-
-3
votes1
answer45
viewshow to print table in two columns?
I have a table with more lines that fit on an A4 page, but if divided into two can be printed on one page, with two columns. I’ve checked other sites and got help, but it hasn’t. I attach the code I…
-
-3
votes1
answer143
viewsMerge multiple excel sheets into one
Hey there, guys. So, I have a folder on my computer where several spreadsheets are played and I need the spreadsheet1.xlsm, worksheet2.xlsm, worksheet3.xlsm... but they are together from other…
-
-3
votes1
answer25
viewsAssign formula to a cell in VBA - Appears a @
I am learning VBA and in a sub where I try to assign the command below: =PROCX([@[Empresa Emitente]];FORNECEDORES[Empresa Emitente];FORNECEDORES[DEPART];"";0;1) Sub EXTRAIR_DEPART_UPDATE() Dim…
-
-3
votes1
answer60
viewsFor if it doesn’t work
The code needs to test a two-sentence list. If he finds this phrase, he copies it and pastes it into the cell on the left, until he finds the next sentence. Everything works fine in the first For…
-
-3
votes0
answers23
viewsSimplify Conditional VBA Code in MS Access
I am new in MS Access and VBA, but I have been doing well with my needs. I made a code to click a button on a form that checks if the required fields are filled and runs Word Mailmerge. However, the…