Questions tagged as 'vba'

Tagged questions
1
answer

Button that counts and adds data Excel VBA

I have to make a form that when I press a button I add a product to a table for a purchase ticket For that use the following code Private Sub AMERICANO_Click() Worksheets("Ticket_print").Activate Dim L As Variant Dim MyCount As Long L = Hoja2...
asked by 09.06.2017 / 08:47
2
answers

Excel Conditional Format

Good morning, I am creating a spreadsheet with a form to be able to document the status of an order. Depending on the status, the cells from A to N have to change color, additionally for certain status such as "CI ERROR / TICKET", the color of t...
asked by 13.10.2016 / 04:50
3
answers

Use the variable of another Sub VBA

I have a problem wanting to use the variable "name" of another subroutine. I want it to be able to edit a graph. In this case, the first subroutine generates the graph and gives it the name. In the second subroutine, I want to edit it but I can...
asked by 30.06.2016 / 19:28
1
answer

If string value in array then ... vba

I am working with a macro and what I want to do is compare the values of a column against the values in an array and if it finds it delete the entire row, what is not the instruction to find the value, my code: Dim i, c, last_row As Integer Di...
asked by 20.06.2016 / 23:17
1
answer

Visual Basic Excel - Create Folders using 2 columns

I am new to Visual Basic 6 and I have a problem. I need to create folders using two columns, that is, in each folder I have to appear the contents of A1 and F1 separated by a low script, for example, and so on. Searching forums and YouTube...
asked by 09.12.2018 / 22:30
0
answers

Assign random values in a specific rage [closed]

I have declared 15 variables (from "A" to "P"), I need to randomly assign values from 1 to 15. In what way could it be achieved?     
asked by 22.12.2018 / 02:22
0
answers

Send data in WS SOAP Service with VBA Excel

I'm trying to make a macro in VBA in excel to send a request through a Web Service SOAP service, I managed to create it with the following code confirming that it actually works: Sub erp_automatico() Dim sURL As String Dim sEnv As String Dim x...
asked by 08.11.2018 / 04:25
1
answer

Count different variants of a value in a VBA recordset - Access

I have a Recordset in VBA , I want to count how many variants there are of a value. That is, what in a query SQL would be:    SELECT COUNT (tag)       FROM table       GROUP BY tag Table would be the Recordse...
asked by 16.05.2018 / 10:45
0
answers

Deserialize Json string to Visual Basic class

I have had problems creating a class like this for this JSON string. I ask for your help with this serialization and deserialization of JSON because I searched but I still get an error when deserializar. JSON: { "Local": "1", "CodPr...
asked by 18.05.2018 / 01:35
1
answer

Help to export this data

Hello, I wish you a good day, the thing is this ... I currently have this code for a button Private Sub btnfiltrar_Click() On Error GoTo ErroresIf Me.txtfiltro.Value = "" Or Me.txtfiltro.Value = " " Then Me.ltbdatos.Clear Else Me.ltbdatos....
asked by 22.02.2018 / 15:17