Most voted "excel-vba" questions
VBA (Visual Basic for Applications) is the programming language of Excel and other Office programs. Use the Excel-Vba Tag when you have scripts problems of a Vbaproject in direct relation to the interface of Excel spreadsheets.
Learn more…335 questions
Sort by count of
-
2
votes0
answers20
viewsScritp VBA Identify Data Entry
Good afternoon, I have the code below in VBA that returns me the USB ports in use. However I need to know which one is sending me the data from the bar code reader, because I will use 8 readers in a…
-
1
votes1
answer415
viewsHow to execute a VBA command on a sheet with a specific name?
I have an Excel document with several sheets. In this document I need to execute a command on a specific sheet, that is by the sheet name. But if that sheet does not exist execute another command on…
-
1
votes2
answers1752
views -
1
votes2
answers3002
viewsHow to assign the formula of cell D2 to a variable?
CODE: Range("AB2").Select Dim tudo As String data_pasta = Format(Date, "/yy/mm/") tudo = "https://pagina.pt/wp-content/imagens" & data_pasta & **D2** ".png" ActiveCell.Value = tudo…
-
1
votes1
answer2071
viewsHow to search in a column by value =< 200 (run command)?
I intend to search row by row within the column P:P a number less than or equal to 200 and execute a command. If more than 200 execute another. The values are defined as 0.0. If .Value =< 200…
-
1
votes2
answers9649
viewsAutomatically fill cells in excel using VBA
Good afternoon community, I am trying to work with VBA in Excel in order to try to apply this knowledge in my master’s thesis, but I have some doubts. I am trying to create a VBA function that fills…
-
1
votes0
answers25
viewsBlocking of fmData Vba
I created a simple form that informs me date, date, OS and Type. When my user tries to change some he can’t because I stopped to change the data but when my client selects all the cells of the…
-
1
votes2
answers72
viewsMacro problem that performs dynamic sums and non-continuous intervals
I have a spreadsheet where column A has following values (1,2,4,6,8,10), and the fields with value 1 should be the sum of all groups 2 below it until the next value with field 1, and group 2 shall…
-
1
votes1
answer2090
viewsEdit data from a Dropdown List in Excel
I have a list of items in a dropdown in excel. These values must be selected by the user and from there, edit it as requested. However, I don’t know how to edit these dropdown values. Can anyone…
excel dropdown excel-vba dropdownlist excel-userformasked 6 years, 11 months ago Alexsander Caproni 289 -
1
votes1
answer1019
viewsHow to identify a specific date in vba?
I have a base with dates of several months and years, and a home screen where I update the submission date and enter the information. I made a code that will identify the month and year of the home…
-
1
votes1
answer18482
viewsCompare two columns in EXCEL and if they are equal return a certain value
I’m having a hard time generating a logical structure (If) to validate some data. It’s for a survey. follows the explanation: There are two columns (B and H). In the column B there are all Brazilian…
-
1
votes1
answer340
viewsSave Chart of a spreadsheet in a folder by VB
Hey there, guys. I’m a beginner in VB programming and I’m with a project, where I access a spreadsheet and insert data into it and this data is shown in graph. How do I save this graphic as an image…
-
1
votes1
answer677
viewsHow to set the filters in a Pivotchart through a macro in Excel?
I made a VBA form and wanted to click on a button the filter properties of the dynamic graph associated to a table in Excel if they changed.
-
1
votes1
answer1352
viewsDelete Certmgr certificate by command prompt
I need to delete certain certificates from the computer so that they do not disturb my a vba automation system, however I have not found anything that can give me a light how to do it by programming…
-
1
votes2
answers422
viewsLoop to Repeat Names
Dear community, I believe it is simple the most solution, I am trying to make the following rule of business: I have a list of names on a Plan1, I need the name of each of them to be repeated by 12x…
-
1
votes1
answer767
viewshow to make a graph in vba excel in the form of goals?
I need to make a graph where the bars change color depending on their value! example: less than one thousand red, between one thousand and two thousand yellow and above one thousand green follows…
-
1
votes1
answer347
viewsHow to separate Edit 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…
-
1
votes1
answer487
viewsUpdate Frame Selenium VBA
Expensive, How can I update a frame with Selenium in VBA? Updating frame is an option that exists when right-clicking on some frame. I can’t update the whole window, only the frame.…
-
1
votes0
answers442
viewsVBA Configuration of References
Good morning, it may be something really stupid, but I’m starting to work with VBA to search for data on the web and every time I start a new project I have to add the references "Microsoft HTML…
-
1
votes1
answer1517
viewsVBA - Popular array string and do not repeat values
I have an Excel Workbook x. This Workbook has 3 spreadsheets. The 1st is Animals still empty; the 2nd is Birds and we have repeated values and the 3rd is Mammals also with repeated values. How to…
-
1
votes3
answers8269
viewsHow to add character after last word written on line
Dear community, I have a doubt that I’ve tried everything, but I can’t solve. I have a list of former names; José Mario da Silva Mariana Cristina William Caio Jorge Luiz Campos de Silva Andrade In…
-
1
votes0
answers65
viewsMake clicks for interactive online chart
I need to select the information on the left side of the graph according to my need, but I cannot reference the information. I didn’t put any code because I tried it in various ways (according to…
-
1
votes1
answer1600
viewsIF condition - Show or Hide Textbox
Expensive, I have 4 optionButton (2 different groups), where 2 represent "Yes" and "No" for two different questions. What I want to do: When the user chooses the NO option in group1 and then chooses…
-
1
votes1
answer152
viewsVBA - Maximum character in dropdown-list
' Validação Motivo Columns(motivo).Select With Selection.Validation .Delete .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _ xlBetween, Formula1:= _…
-
1
votes1
answer980
viewsExcel VBA - Check file size and type
In my spreadsheet I have a button that displays the file selection box. After selecting an image, this is displayed in a specific cell. How do I check if the chosen file is really an image? and To…
-
1
votes4
answers6070
viewsExcel VBA - Runtime Error '13': Incompatible Types
I’m getting Error '13' Incompatible Types on the First If Line: 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,…
-
1
votes1
answer377
viewsFilter dynamic table (Power Pivot) by Listbox
This code: /a/309087/116347 Make the selection in Listabox ... and Filter activated by a button.. as described in the link... But if the Dynamic Table is created by Power Pivot .. This code does not…
-
1
votes1
answer915
viewsTranslate Captcha
I’m developing a routine that researches vehicle charges and restrictions in the DMV, and to download the document, I need to go through a Captcha validation, and it’s already taking my sleep away.…
-
1
votes1
answer620
viewsCode VBA button
Good, I created a file (database query) in which each number corresponds to a PDF (link). I tried to create a USERFORM to search the PDF through the number and so far it is working. I’d like to…
-
1
votes1
answer1729
viewsFind and Copy sheet line to form, change fields and write to the same sheet with new ID
My question is as follows: I developed a VBA form with 20 fields, which registers in the Bdados spreadsheet, also inserting an ID. What I want is to find and copy a record of the spreadsheet to the…
-
1
votes1
answer1216
viewsTo rename a folder added the current date to the name
I have a folder where I keep data that needs to be updated daily. To not miss the history copy this folder and paste elsewhere. But, after copying and pasting the folder, I need to rename it with…
-
1
votes1
answer445
viewsVBA - Error: The 'frames' method of the 'Jscripttypeinfo' object failed
I need to fill the 'Legislation' tab with the text "Energy Development Account" and do the research. But when executing the code appears the error quoted in the title referring to the line "obj =…
-
1
votes1
answer1450
viewsOpen Excel spreadsheet and copy the Data into VBS
Hello, I have a simple spreadsheet (3 cols and 2 Rows) and am trying to create a script to open it, copy your data and insert into another. Path =…
-
1
votes1
answer275
viewsProblems in VBA code execution
This code clicks on the 'Legislation' tab and fills a field with a given text (2º For Each) and clicks on the search button (3º For Each). The problem is that when I run the code, it clicks on the…
-
1
votes1
answer635
viewsError '70': Permission Denied
When I run the code below, the title error appears in the 'For Each' line. This is a block of the site itself or there is some error in the code? Declara função Sleep If VBA7 Then Public Declare…
-
1
votes1
answer313
viewsDoubt with the Sender command of VBA excel Outlook objects
I have an excel VBA code, which sends to some specific recipients some e-mail’s, but at first these email as they are being sent by my outlook are coming out with my name, but in Outlook we have the…
excel-vbaasked 6 years, 7 months ago Rogerio Jr. 11 -
1
votes1
answer4196
viewsCopy and Paste Special with VBA
I have a VBA script that copies a column (from an Excel spreadsheet) with formulas and pastes only the result (Paste Special). But I would like to automate this task, example: Whenever you add any…
-
1
votes0
answers718
viewsImport Table from Web Page to Excel
I want to take all the data from an internet table and put it in excel. I tried with the code below, but the following error appears in the line of 'For Each': "Runtime error '438': Object does not…
-
1
votes0
answers1135
viewsCheck network connection with Excel VBA
I have a macro that saves on the network three spreadsheets of a PDF file. Loop and verify which spreadsheets will be saved in PDF, and save correctly. Macro hangs or gives error when network is bad…
excel-vbaasked 6 years, 7 months ago Paulo Semblano 85 -
1
votes2
answers10196
viewsDelete table lines through VBA
I’m having a hard time deleting lines from a table, not just the content, but that doesn’t affect the worksheet lines. I recorded a macro that resulted in the following code:…
-
1
votes1
answer32
viewsVBA Excel Code
Fala Galera! I need to create a code that copies a horizontal list of a sheet and paste it into another sheet in vertical form. Each time the command is executed, it must skip the line to copy the…
excel-vbaasked 5 years, 6 months ago user149250 11 -
1
votes1
answer44
viewsSkip digits when running
I have a problem, I took right here a script to enter the ninth digit if the phone starts with 6,7,8,9.. Function ValidarCelular(Myrange As Range) As String On Error GoTo ErrHandler: Dim regEx As…
-
1
votes1
answer72
viewsSE function with 3 final values
---Rephrasing the question--- A formula expressing the following information: -When Column I and J is written "Letter N" will return in column C the writing "PSI" -When Column K and L is written…
-
1
votes1
answer279
viewsHow to update a website page after changing the value of a field by VBA
Good night. I wonder how I can update the page with the date I informed by VBA. I put the date but the page does not change. Since there’s no button, I don’t know what to do. Sub Links() Dim ie As…
-
1
votes1
answer1025
viewsHow to Load a listview with more than 30 columns?
I’m trying to carry a ListView with more than thirty columns using the following code: With ListV_P Sheets("BANCO").Select Dim UltimaLinha As Variant Dim Linha As String '.GetFirstVisible = True…
-
1
votes0
answers185
viewsSet Invokepattern problem = Button.Getcurrentpattern(Uia_invokepatternid)
I have a problem with the save button on IE11 - I changed the field to the language of the program (Portuguese). Sub DownloadFile(h As Long) Dim o As IUIAutomation Dim e As IUIAutomationElement Dim…
-
1
votes1
answer517
viewsCopy cells when identifying Worksheet_change change (Excel VB)
I am new in VB and I am trying to make an operation that copies some information from the spreadsheet "Control Backup Clients" to the spreadsheet "LOG". The process will be as follows: Excel when…
excel-vbaasked 6 years, 5 months ago Stephen Willians 82 -
1
votes1
answer526
viewsError: The Incompatible Types
I am running a PROCV in one column, looking for values of another. The code runs to a certain value and appears the error quoted. But there is no difference in the numbers, even I have already put…
-
1
votes1
answer2777
viewsConsolidate data from multiple tabs into one (same workbook)
I have 18 spreadsheets (tabs) with user data and I need to copy and paste the data into another spreadsheet (tab) of in the consolidated name. I need to copy the header only from the first sheet and…
-
1
votes1
answer587
viewsReplace VBA method
I would like to know how to use the method Replace with dynamic variables in VBA. My line is : Replace (Cells(endereco(linhaAtual).Row, 22), item.Value, "") In this case the variable where the…