Best answeres tagged with vba

1

answer

When to use Dim and when to use Set?

What are the differences between Dim and Set ? When to use each? Context 1 Dim minhaString as String minhaString = "Olá!" Context 2 Set minhaString = "Olá!"

asked by 20.12.2016 / 23:59

1

answer

V9 VBA - How do I get the login name? [closed]

I do not know if the question has already been asked, but in VBA is there any function that returns me the username initialized on the platform?

asked by 31.12.2018 / 13:46

2

answers

How to expand range of numbers with data?

As I would in excel to expand a huge list with data to instead of grouping value data, it would show the content in total. Example: I would like to turn this: Inthis: Remembering it will be a huge list of values. So something autom...

asked by 14.09.2017 / 18:26

3

answers

Can you have automatic recalculation of Excel trigger a routine in VBA?

I have a graphic scheme in Excel that is done by means of conditional formatting (see figure below), that is, in colored cells there is no content, only the background colors are changed based in values from other cells. Thedashedbluelinei...

asked by 18.04.2017 / 23:20

3

answers

How to use a Command Button inserted in the Spreadsheet in VBA code?

I have a command button that I inserted into a worksheet, and I wanted to know which function I have to assign in the vba code, to know when a user clicks it!

asked by 10.02.2016 / 19:07

1

answer

Command for Fill Effect in Excel VBA

Friends, I'm using the hint, described in the "Excel Guru" script in Creating Interactive Maps in Excel: Sub ColorirMapa() Dim Microareas As Range Dim Celula As String For Each Microareas In Range (“Microareas”) Celula = Cells (Microareas....

asked by 03.11.2014 / 21:36

1

answer

CEP Search via VBA Programming

I am developing a solution and there is a need to add zip code search. In return I would like to get the address based on the CEP informed. I want to use this search to fill in the auto-address after I enter the zip code. I started writing th...

asked by 07.08.2018 / 21:04

1

answer

How can I drill down to the invoice editor in SPRING

Good evening. Following my previous question about the drill-down for the STP module, I would like help to be able to drill-down to a sales invoice in ERP PRIMAVERA 9. I could not find any help from PKB.

asked by 21.02.2018 / 00:06

2

answers

Get values from an excel sheet and display in a popup

asked by 13.11.2017 / 16:50

3

answers

how to close Word opened by VBA

For each Execution of the DeleteSel function, a "WINWORD" is opened in memory, even with the Close command and / or Quit it does not close. Sub DeleteSel(msg As Outlook.MailItem) Dim objDoc As Object Dim objBkm As Object Set objDoc = CreateOb...

asked by 24.01.2018 / 12:49

Questions tagged as 'vba'