Questions tagged as 'vba'

Tagged questions
1
answer

Access 2010 VBA - Error "The types do not match" in IF

In a VBA code of a button of an Access form, I have the following code: The result is an error like this: What is owed and how to solve it?     
asked by 09.07.2018 / 12:05
0
answers

perform a filter and execute it according to a button

How can I make a filter that, according to the press of a button, shows me the results as shown in the image according to the range "ai1: al217" ?, but I would like it not to be filtered in the 4-digit numbers with the x     
asked by 29.06.2018 / 00:19
1
answer

Error 91excel vba

I have developed a macro excel in the book "A", I execute it calling it from another book the "B". In the book "B" I copy an excel sheet "data" that is generated in an Excel export process of a book "C" that contains the "data" sheet. If in the...
asked by 26.06.2018 / 22:27
1
answer

delete repeated words in 2 different cells

I'm stuck making a sheet in which I want to delete a series of words that I have in 2 different cells. En la celda A1 tendría GLUTEN, SOJA, En la celda A2 tendría SOJA, GLUTEN, SESAMO, PESCADO, I would like to get in a 3rd cell, A3: SÉSA...
asked by 26.06.2018 / 13:05
1
answer

Using an OR within an IF MAcros

I have the following code: For i = 1 To j If Sheets("Detalle sin TDC vista").Range("H" & i) = "Tarjeta" or Sheets("Detalle sin TDC vista").Range("H" & i) = "test" Then Rows(i).EntireRow.Delete End If Next...
asked by 15.06.2018 / 23:32
1
answer

Looking for a TextBox within a table in VBA - Word?

I have a table of a single column, in some rows I have some textbox assigned to a macro that works perfectly. But I need to check the number of the row in which the TextBox are located. Would it be possible? Thank you for your attention. G...
asked by 18.06.2018 / 12:23
1
answer

Concatenate within Range Object

I'm trying to concatenate a variable to a range. Dim i As Integer i = 1 If Range("H+i") = "Validacion Expediente" Then MsgBox ("y") Else MsgBox ("N") this in order to know if the cells that are in column H h...
asked by 15.06.2018 / 17:11
1
answer

Redim Arrangement VBA

I have a small problem that I hope can guide me, it turns out that I have to store an array and for each data I'm going to store, verify if it has not been previously entered, the difficulty I have is that I define an array of 10 elements. , but...
asked by 19.06.2018 / 19:00
0
answers

Assign name to column excel in VB

Hello Developers, I have a problem that I am creating an excel book with its respective sheet name etc I want to change the value to the column to put names I have tried with many methods but I do not know how Dim xlWorkSheet As Excel.Works...
asked by 13.06.2018 / 19:24
0
answers

Check values of a cell and insert data according to that value

I'm doing a quote in excel with vba. I have a concern with the following: I need by means of a macro, get me to verify the value of a cell or cells (depending on how many data have been inserted) and then rectify that value in another sheet of t...
asked by 31.05.2018 / 06:30