Questions tagged as 'excel-vba'

Tagged questions
1
answer

How to add content to the Excel VBA ListBox

Hello, I have a question in a code for Excel VBA. I want the code to search the worksheet for the same number that was typed in TextBox , after finding it, sends the information from the entire spreadsheet to ListBox . Since the code...
asked by 15.07.2018 / 03:37
1
answer

Running time error '91' The object variable or the with block variable has not been defined

I do not know how to work very well with excel, I have to make a graph using buttons and gave this error Sub logs_acumulador() ' ' logs_acumulador Macro ' ' ActiveChart.SetSourceData Source:=Range( _ "db_performance.producao[[#All...
asked by 02.04.2018 / 14:56
1
answer

Access Site By Loggin

I am not able to access this site below because I can not find a way to enter the Login and password in VBA. Would anyone know how to access these fields   link I tried to access looking for frames, but still could not access     
asked by 26.10.2017 / 20:48
1
answer

AutoFilter Excel VBA

I have a problem, when trying to make an autofilter in vba it is trying to filter the values I chose but it does not filter value, I searched a lot and found no explanation. The code is as follows: Dim nomeArquivo As String Dim gd As I...
asked by 19.09.2017 / 20:52
2
answers

Excel 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 worksheet to another, it should be something very simple, but it gives compilation error. Sorry if I u...
asked by 11.09.2017 / 23:40
2
answers

How to concatenate or use commercial & date & text?

I'm using the following code to display only the day and the month. Range("AB2").Select ActiveCell.Value = "=Now()" ActiveCell.NumberFormat = "yy/mm" ultima_linha = Range("A" & Rows.Count).End(xlUp).Row Range("AB2").AutoFill Destination:=R...
asked by 30.05.2017 / 18:43
1
answer

Count the number of selected items in a ListBox

I have a ListBox1 list in a userform configured for multiple item selection. Is there a function, statement or way to return the number of selected items?     
asked by 27.04.2017 / 20:21
1
answer

VBA Code: Block specified cells without protecting the entire worksheet

Good afternoon Can you help me with the formula below? I need to include more columns and other specific cells .. but I do not want to block everything. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Column = 1 Th...
asked by 05.12.2018 / 18:31
1
answer

How to remove brackets from some subfolders I have using an excel macro?

I have a folder called "Franchised" where there are numerous sub-folders with the names of the franchisees. Within the folder of each franchisee there are some subfolders whose names contain brackets. I want to program a macro to remove the b...
asked by 13.11.2018 / 11:34
1
answer

Open Excel worksheet and copy data into VBS

Hello, I have a simple spreadsheet (3 cols and 2 rows) and I'm trying to create a script to open it, copy its data and insert it into another one. Path = "C:\Users\user_name\Documents\excell\planilha1.xlsx" Set objexl = CreateObject("Excel.app...
asked by 29.11.2018 / 18:17