Questions tagged as 'excel-vba'

Tagged questions
1
answer

I have a password in excel and I want to change it in vba

If Me.boxPassword.Value = "12345" Then Unload Me Sheets("Configuração").Visible = True Sheets("Configuração").Select Else Me.Hide Retry = MsgBox("Passe incorreta, Tentar outra vez?", vbYesNo, "Retry?") Select Case Retry...
asked by 22.10.2018 / 17:24
1
answer

Use VBA to delete rows with criteria determined by a cell

I need a Vba to do the following action: As soon as it is activated, read a specific cell and erase lines from another flap taking into account the specific cell as a criterion. Example: In Sheet1 I have two products: Blue Shirt A Blue Shirt...
asked by 19.10.2018 / 21:36
1
answer

Excel VBA changes the date format to mm / dd / yyyy

I'm developing a spreadsheet in Excel using VBA , which will function as a "micro-system" of registration. I'm having the following problem: Every time I type the date in the cell Cad_0 , for example, Excel changes the form...
asked by 09.10.2018 / 16:23
1
answer

How to fetch info from excel sheet to do drop down in Visual Basic

I have a dropdown with information I already have in a excel sheet in Visual Basic, how do I go get that same information? And already make sure there is no repeated information? Example: colunaA a a a b b b b c c d e e And t...
asked by 20.09.2018 / 15:35
1
answer

MessageBox in VBA in Excel

Hi, I'm working on a PivotTable in Excel and I would like it when I typed the text store 10, it would display a warning that this store is unavailable, I know I need to call a messagebox however I have no idea what other structure need to use, c...
asked by 23.08.2018 / 20:27
1
answer

Application definition or object definition error

Hello. I'm trying to format a table to base a graph, however I'm getting the following error message: "run-time error '1004': application-defined or object-defined error" I'm using the following macro. Does something know the reason for the e...
asked by 17.08.2018 / 23:58
1
answer

Block printing via menu "Print" with macro

I wonder if there is any way to block the printing of a worksheet from the File-Print (Ctrl + P) menu or the printer icon through a macro. Well, I made a macro that when you push a button it will do a behavior in the worksheet and have it printe...
asked by 18.08.2018 / 01:55
0
answers

Create charts with data from a different worksheet and varying number of columns

I need to generate a chart for each row in a database. This database varies both in number of columns and in number of rows, and is in a different spreadsheet, Groove Matrix 1. Whenever I run my code is giving an error in SetSourceData, and I ca...
asked by 03.08.2018 / 03:25
1
answer

VBA Module that stores data from one cell and moves it to another cell and moves to the cell below

Good evening people, I created a folder with macro where I have two spreadsheets, Query and games. In the games spreadsheet I put game names and their respective values in real, already in the query I created a list to do the autocomplete with c...
asked by 08.08.2018 / 22:54
0
answers

How do I log into a site with VBA?

Good morning everyone. I'm having trouble creating a VBA macro that logs into the site. I'm trying on a test site link . So far I only managed to open the site with a button command in excel, but I need the same, login. Can you help me? Foll...
asked by 12.07.2018 / 17:00