Questions tagged as 'vba'

Tagged questions
0
answers

Data validation (Lists) in VBA

I put them a bit in context. As an example: I have a table with data and in column A there are a number of countries but in some cells those countries can come empty (and the entry of data must be filled with a list validation) and in column...
asked by 28.03.2018 / 17:44
0
answers

Object word and vb6

I need to create a word document from vb6. I do not use the library reference office 11.0, so create objects. I have achieved the functionality, but I need the last paragraph to be centered horizontally, I have not found the form ... Dim...
asked by 13.03.2018 / 20:44
0
answers

Why does not the DoEvents record the keys correctly? VBA

my code is this: Public x As Integer Public y As Integer Public ax As Integer Public ay As Integer Public xpie(3) As Integer Public ypie(3) As Integer 'funciones Function selectxy(x, y) selectxy = Cells(y, x) End Function 'metodos Sub inOpen...
asked by 07.03.2018 / 23:22
0
answers

Print from VB6 to Word placing background image

I have to touch up something very old, I simply need to print on the screen the birthdays of employees with a balloon fund and those things, an image that occupies the entire fund (100%). In principle, the idea is just to send the file by mail....
asked by 07.03.2018 / 14:31
1
answer

How to export a data matrix?

What I need to do is something complex so I will try to explain myself as best as possible ... It turns out that I have this form In this form, the user must first select a chapter, then a subchapter and finally an item, as soon as t...
asked by 05.03.2018 / 14:16
0
answers

Polynomials in visusla basic

How to generate a code that captures a polynomial in a texbox, no matter the size, then enter a variable and evaluate it, example: polynomial 4x ^ 2 + 5x-3; = > 4 (variable) ^ 2 + 5 (variable) -3 = variableresult     
asked by 02.03.2018 / 18:20
0
answers

How do I assign values from one arrangement to another?

I want to make a function that gives me back a specific position of an array of a smaller length with respect to another one in VBA - Excel, all my values are multiples of 28 and I had this idea in mind: Public Function arreglo_corto(rango As...
asked by 17.02.2018 / 00:21
0
answers

how can I improve this excel code

Sub Buscar_Numeros() 'Por.Dante Amor Application.ScreenUpdating = False Set h1 = Sheets("numeros") Set h2 = Sheets("formato") ' uc = h1.Cells(2, Columns.Count).End(xlToLeft).Column For j = Columns("F").Column To uc S...
asked by 15.02.2018 / 14:27
1
answer

counting problem in excel

experts I have a problem with this macro, I execute it but the result in each cell is one of more, how can I improve it in all the orange columns the macro ends its count until the last blank cell of the columns "a; d" and I want it to end its c...
asked by 15.02.2018 / 15:30
2
answers

Create ComboBox in Excel cells with VBA (not with UserForm)

I have a question, I'm a bit of a rookie with Visual Basic for Excel but I've done something, but now I have a question. First I want to create a Select or Drop-down List or ComboBox (as you want to call it) but I do not want to do it with Us...
asked by 10.02.2018 / 02:08