Questions tagged as 'vba'

Tagged questions
1
answer

Importing data from a web page to Excel via VBA

It's the following: I found the code on the internet that works perfectly with what it's indicating, but I need to adapt it to a project and I'm not getting it. In short, the macro accesses the link page, verifies the member search form, us...
asked by 26.12.2015 / 22:52
1
answer

Bug in code, function repeats call when open excel file

Following this question: link Code: Function PrinciQualidade14(LNumber As Integer) As String If LNumber < 15 And LNumber > 0 Then InsertPictureInRange LNumber, Application.ActiveCell Else Debug.Print "Numero incorre...
asked by 12.02.2016 / 17:51
2
answers

How to show 2 rows in ListBox

It's a simple question, but I researched and could not find something specific to my case. The code below corresponds to searching for data in a table, but when there is more than 1 corresponding value, it replaces the last found value. What I w...
asked by 17.10.2018 / 21:06
2
answers

How to get a difference between two dates?

Let's say I have an initial date equal to 30/01/2014 10:00 and an end date equal to 02/02/2014 10:00 . I wonder if it's possible to get a grid containing these results: If possible, I would like to know how.     
asked by 21.02.2014 / 02:09
1
answer

A Macro to run all Modules?

I have several modules and within these modules I have several subroutines with some functions on separate sheets. I want to run the macros separately! That is, start the next sub routine after finishing the previous subroutine. EXAMPLE OF ON...
asked by 07.06.2017 / 12:51
1
answer

How to handle the unusual closure of a ComboBox list in VBA?

I'm creating an important effect for a particular ComboBox presentation. The text of this ComboBox is originally centralized , and when you open your list, I make the text left aligned for items in your list to appear < strong> left-alig...
asked by 20.05.2016 / 06:46
1
answer

How to "Copy and Paste" a form in VBA?

I have a form ready that I want to take advantage of everything I did for him but in another form, it would be the case to do something similar to "Copy and Paste", how can I do it?     
asked by 15.05.2016 / 23:16
1
answer

Create add-on that associates number with an image

I need to create an add-in that associates a number with an image. Example: =getImageQualidade(1) 'e nessa célula ficava a imagem. I already know how to create / implement a basic add-in in Excel link Now my problem is in the code....
asked by 09.02.2016 / 14:50
1
answer

Copy and paste cell when changed

I'm starting to use VBA with the office package, as I still know little I'm having trouble getting this functionality. I was trying to do something simple and needed help to understand how it works: I need if one cell changes, its contents...
asked by 06.11.2017 / 14:57
1
answer

Range.Paste Runtime error when pasting web data

Hello. I am extracting some data from an html table from an ERP which due to limitations lead me to this. Anyway, the problem consists of, when copying the table and try to paste it with range.paste or special past error. The complete code:...
asked by 04.02.2016 / 20:48