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
-
1
votes0
answers170
viewsQuestions about objects in vba Excel
I am working now with vba, however it is a language that I had little contact in graduation, I would like to ask a question. When a macro in an excel file calls another excel file that also has…
-
1
votes1
answer279
views -
1
votes1
answer879
viewsVBA Excel - Index Match with two conditions
I have a spreadsheet with several tabs. In the first tab I have the following table: In tab 2 type the client and the type, and I wish to return the ID. For this I am using the following code in…
-
1
votes1
answer238
viewsVBA-Excel: Range of a cell contained in a variable
I need to take the contents of cells identified in a variable. It is possible? Code: VTI40 = "J44" VTF40 = "J47" VTI39 = "H44" VTF39 = "H47" QtdVal = Range("B60").Value QtdInv = 40 - QtdVal For i =…
excel-vbaasked 4 years, 3 months ago Antonio Octávio de Oliveira 11 -
1
votes1
answer41
viewsVBA formulas with @
When you write the formula of a function by VBA, and add some excel formula, it increments a @ before the formula automatically. For example: Selection = "=SOMA(A1)" In the spreadsheet formula bar…
-
1
votes1
answer131
viewsLimit Formulaarray
Range("B11").Select Dim Rmts As String Dim Busca As String Rmts = "C:\Users\Treinamento\Desktop\Trabalho em vba\BC\[Relacionamentos.xlsx]Matriz_Trein_Obrigatórios" Busca =…
-
1
votes2
answers3166
viewsVBA - Read a file. TXT and manipulate its lines
I’m trying to make a Query generator using Excel (VBA), but I’m not able to manipulate some data inside a file . sql. Ex.: Select * From Tabela t Where t.id = 1 <PROP> Every time he finds a…
-
1
votes2
answers2022
viewsAdd paragraph in vba
I have several cells I want to concatenate to send an email through excel Turns out every cell I wish I had line breaks but I’m not getting I’ve used Wraptext and Chr() but it’s not working, someone…
-
1
votes1
answer26
viewsFiitro - Excel VBA
I’m trying to create reports. I’ve never done this before because then any and all help is very welcome. My table starts in column "A" and goes to column "BL". There are 64 columns. I want to filter…
-
1
votes2
answers87
viewsDelete rows that in the column contain a certain value
Hello everyone I’m trying to find a quick way to the following process, my base has 68000 lines all filled, and as time goes by it increases, in my column G has the names of the cities, I made a…
-
1
votes0
answers86
viewsRecurring errors generating a word file from fields of an excel spreadsheet (VBA)
Good afternoon, I never programmed in VBA but I found myself in a need where I am needing to generate a word document from some cells of a spreadsheet in excel, after searching several websites on…
-
1
votes1
answer1097
viewsError pasting data in Excel with VBS
I have a simple spreadsheet in Excel(3 cols and 2 lines) and am trying to create a script to open it, copy your data and insert them into other spreadsheet with the same structure using a form.…
-
1
votes0
answers35
viewsHow to find cursor in Textbox?
Hello! I need to know the position of the cursor in the Textbox when the user type a character (add a word at this position if the character is within the conditions applied in the rest of the…
-
1
votes1
answer30
viewsReplace word set in Excel
I have an Excel spreadsheet with some columns, for example: Fruta | Veículo | Profissões -------------------------- Banana Carro Médico Pera Moto Programador Maça Barco Engenheiro Morango Avião…
-
1
votes2
answers6120
viewsExtract SAP data through Excel
Hello! I’m trying to integrate Excel with SAP via VBA. I would like to run the transaction "MB51" with some parameters like date, deposit and movement and bring the data obtained to the Excel…
-
1
votes1
answer299
viewsVBA - Open an explorer page, do a search in google images, give scrolldown to the bottom of the page and use the console
I’m developing a VBA module to open google images, search "cement", scroll the page down to the end and then use the console to input some scripts into javscript. The Code so far is as follows:: Sub…
-
1
votes1
answer252
viewsRecord data in cell of a vba excel table
I have a userform to record a data in the table Tabelaviagens. In the form I select the trip in the combobox and to register the data I use event in the button approve. However the code is not…
excel-vbaasked 5 years, 8 months ago Jarbas Martinho 13 -
1
votes1
answer254
viewsSimple Quotes in Access
I have an Excel macro that reads the cell’s contents and saves it in an Access type database, when I try to insert a string that has simple quotes in the middle of the string and the following…
-
1
votes1
answer2720
viewsVBA - How to send specific cells of a spreadsheet in the body of an email
Hello, I’m trying to make an application for my work in VBA, however I’m having difficulty sending only some cells in the body of an email directly via outlook. Private Sub CommandButton1_Click()…
-
1
votes1
answer81
viewsVBA Add "-" every two characters to form MAC Address
I would like to form a MAC address from the data collected from a barcode reader. I need every two characters to be added one "-". Entry text: A9B8C7D6E5F4 Output text: A9-B8-C7-D6-E5-F4 So far I…
-
1
votes1
answer124
viewsI need to compare the value of the last filled cell with the antepenultimate
ola thank you for your attention. I need to compare the value of the last filled cell with the antepenultimate. if the value is different I want to continue with the current value if seje = place…
-
1
votes1
answer177
viewsApply button - Visible cells
I have a form where there is a Listview, and textbox for data input and already by login I can filter a column, to appear only the fields I want. Where is the problem? the intention is, I click on…
-
1
votes2
answers608
viewsAlgorithm that performs the combination of elements of a vector in VBA?
I need to take a vector in vba with any N elements and perform the combination of such elements. The idea is to have a function that takes 2 arguments. The vector with the elements to be combined…
-
1
votes1
answer418
viewsgetElement does not declare the object (VBA) . IE
I need a little help in a code, VBA interaction in IE, use a page to extract daily reports, and currently this page has undergone a version update, my codes are almost all worked however the code…
-
1
votes1
answer1287
viewsCorrect formatting for excel vba time
Good afternoon! I’m finding a problem that I thought was basic but that I couldn’t solve. I have a Userform (Entradas) to register entries. These entries are played to my spreadsheet in Excel. In my…
-
1
votes1
answer284
viewsRuntime error 13. Incompatible types
I was building a simple listing, and came across the 'Runtime Error 13. Incompatible Types'. When I Clear it tells me that the error is in the two lines of code of my 'If', referring to the dates.…
-
1
votes1
answer29
viewsVBA error while deleting tab
My dear good day! I need your help with the code below. Sub atualizar() Application.DisplayAlerts = False Sheets("Reembolso").Delete Application.DisplayAlerts = True Sheets("Modelo").Copy…
-
1
votes0
answers55
viewsCut a number of characters inside a VBA cell
I have a VBA doubt! Using a VBA code I imported data from a spreadsheet in excel to another spreadsheet. However, in column A, starting with cell A2 the copied information is in the following format…
-
1
votes1
answer40
viewsVBA Script Help for excel
I am developing a script for Excel, which copies specific fields from one sheet, and pastes into another, takes the name of the A9 cell and saves a file with the data copied with the name of the A9…
-
1
votes1
answer26
viewsHow to transform multiple columns into 2 columns with vba?
I have a spreadsheet with the following information. I want to create a new sheet with some columns of this sheet and transform the columns Nominal, Humidity, Primeira_delivery, Degree Drink,…
-
1
votes1
answer29
viewsHow can I analyze several distinct elements in excel using 3 logics for the same column?
So, guys, I have to sort out an excel table of investments, but I have no idea how to do that. They are 2 logic for a column where appears the (Difference of a product purchased the previous day…
-
1
votes0
answers37
viewsHow to copy current email texts in Outlook to cells in Excel using VBA?
Good afternoon to you all. I want to create a macro in Excel that copies specific data from a selected email in Outlook, pasting them into respective columns of a spreadsheet, creating a database.…
-
1
votes1
answer55
viewsProblems with web automation in VBA - Radio Button
Hi, I’m new around here, I am facing a problem with my VBA code, I am trying an interaction using the internet explore, I need you to do the following steps access the site:…
-
0
votes1
answer1926
viewsCount the number of selected items in a Listbox
I have a list ListBox1 in a userform configured for multiple item selection. There is some function, statement, or way to return the number of selected items?
-
0
votes1
answer3790
viewsCheck if a Listbox item has been selected
I have a list ListBox1 q a check box ChckBox1 in a Userform. I want to activate or inactivate the checkbox (CheckBox1.Enabled = True/False if an item in the list is selected. The check-box is…
-
0
votes2
answers5617
viewsExcel VBA delete Listbox item
I’m having a hard time deleting an item from a listbox. The code works like this: will have the listbox with the list, and when the user wants to delete some item, he clicks on a button that opens…
-
0
votes1
answer908
viewsSet the color of a series on a new chart in the worksheet
In Vbaproject I have a row that selects a certain series from the chart Sub MudaCor() ActiveChart.SeriesCollection(n).Select End Sub Being "n" the serial number I need to select. the series colors…
-
0
votes2
answers1832
viewsHow to concatenate or use & commercial with date and text?
I am using the following code to present only the day and month. Range("AB2").Select ActiveCell.Value = "=Now()" ActiveCell.NumberFormat = "yy/mm" ultima_linha = Range("A" &…
-
0
votes1
answer63
viewsHow to convert multiple sheets . XLSL to . CSV of a book and export individually to the desktop?
I intend to store multiple sheets on the desktop by their name. And that they are converted from . xlsx to . csv (separated by comma).
-
0
votes1
answer62
viewsHow to convert Pounds to Euros VBA?
CONVERSION: The conversion will be in Pounds x 1.17 = Value in Euros. To add a percentage the formula will be Pounds x 1.17 x (1 + percentage). METHOD APPLIED: Replacement of the £200 column.50 to…
-
0
votes1
answer107
viewsVBA - Paste Reports into a Determined Sheet
I am mounting a macro that opens a specific report copy the data and paste into another spreadsheet in a given sheet. But I’m having a hard time at the part where I can stick it to the other…
-
0
votes2
answers938
viewsExcel form - incompatible types
I know this should be a simple question to answer, but I’m starting to program in VBA now. The code below should transfer the data from one spreadsheet to another, should be something very simple,…
-
0
votes1
answer288
viewsReset the counter every time you change line
I have the following problem: I have two counters within my code, but I want every time I change to the next line the countLinha1 (second counter) is zeroed and starts counting again, remembering…
-
0
votes1
answer3006
viewsVBA x IE - collect data from a table
I am programming in VBA a collection of information on the website of the central bank. It turns out that the page does not fully load and when the macro ends only a few records were loaded into the…
-
0
votes1
answer53
viewsHow to pick up the strings by picking up the line and changing the column
Set rgFound = Range("B1:B1000").Find(Sheets("FormAluguer").Range("E10")) If rgFound Is Nothing Then resposta = MsgBox("Não encontrado.", vbYesNo + vbExclamation, "stock incorrecto") Else Dim mrange…
-
0
votes1
answer41
viewsField of view of surveillance cameras in Excel
Good afternoon Commonwealth, I have a question about Excel, where I do not know if it is possible to make such a request. My goal is to take a plant and through a Solver, put surveillance cameras at…
-
0
votes0
answers299
viewsError while trying to open an Excel file
I am trying to open a document in excel via vbScript. I am not succeeding in running, the following error is generated, without description: -2147417851 The problem occurs when executing the…
-
0
votes1
answer1279
viewsExcel stops working when I use Workbook.close to close another spreadsheet
Thank you in advance those who try to help me. I have a somewhat complex programming where I use a file to initialize 2 macros in other files. When closing the files, I open a txt file in excel,…
-
0
votes1
answer516
viewsAccess Site By Loggin
I am not able to access this site below because I can not locate by VBA a way to enter the Login and password. Would anyone know how to access these fields https://www.newspace.com.br/pan/ I tried…
-
0
votes1
answer607
viewsHow to run macro with locked project?
Hello, I have a spreadsheet whose project has a password, however I want the macros to work and if the user tries to enter the macros he will have to put the password (I put in the project). I put a…