Posts by Thiago Andrade • 19 points
5 posts
-
0
votes1
answer126
viewsA: How to put a code when you add a commandbutton?
My suggested code: Sub CriarBotao() Sheets(ActiveSheet.Name).Select 'Criado o botão ActiveSheet.Buttons.Add(Left:=200, Top:=100, Width:=100, Height:=35).Select Selection.Name = "BoutonTest"…
-
0
votes2
answers551
viewsA: Excel with slow macro
If your spreadsheet has many calculations add at the beginning of the code: Application.Calculation = xlCalculationManual And in the end: Application.Calculation = xlCalculationAutomatic…
-
-1
votes1
answer58
viewsA: Removal of repeated values between two tables with VBA
I would try to use: Application.ScreenUpdate = False Application.Calculation = xlCalculationManual At the beginning of the code and: Application.ScreenUpdate = True Application.Calculation =…
-
0
votes2
answers239
viewsA: Activecell.Formula compatibles types
Activecell.Formula should only be used to place a formula in the cell, for example: ActiveCell.Formula = "=IF(A1=B5;True;False)" Remembering that the formula should always be written in English…
-
2
votes1
answer566
viewsQ: Position userform on the same monitor excel is on
Good afternoon, I am creating a Dashboard in which when running Excel a userform is opened, maximized and Excel is hidden. My code works perfectly for a PC with only one monitor. When using a PC…