Questions tagged as 'vba'

Tagged questions
2
answers

Search for registration using vba an Access form

again bothering, I'm learning a bit of vba, with macros in acces, what I try to do is that when entering the ID this make the corresponding query and show one of the fields in another text box, attached the image of the form and the code Howe...
asked by 17.12.2016 / 16:37
2
answers

Access images form

I have a field in an Access table of type Attachments where I store several images for the same record. I need to present in a form all the images associated with a record, in such a way that 4 or 5 images can be visualized at the same time, tha...
asked by 08.11.2016 / 13:13
2
answers

Function = TEXT (cell; "hh: mm") Excel Visual basic

Dear, I need to make a macro emulating the function = TEXT () of EXCEL in vb. The idea is that by having cells with hours (7:55) the function vb transforms me to 07:55. Usually for this I use = TEXT (cell, "hh: mm"), this transforms it. I nee...
asked by 06.07.2016 / 23:51
0
answers

When I want to update an issue of the jira with visual basic my excel crashea

introducir el código aquí sFechainicio = 2018 - 6 - 5             sFechafin = 2018 - 6 - 5             sLabel="a"             sName="randomname"             sProject="updatetest"             sComponent="SPR"             sSummary="qqq"         ...
asked by 02.01.2019 / 09:32
1
answer

Pass item from a Listbox to a Label

I have a program that has a Listbox1 on Form1, and I want that when I press the Modify button, the form is closed and the Id item goes to a Label1 on Form2. I tried using the Userform_Load but I do not know how to assign the selected row of L...
asked by 27.12.2018 / 18:55
0
answers

Send a Listbox data from one form to a Textbox from another form

I have managed to pass a selected data from Listbox1 of a Form1 to a Textbox1 of a Form2 with the following code: Private Sub btnModificar_Click() If Me.Listbox1.ListIndex < 0 Then MsgBox "No se ha elegido ningún registro", Else Dim...
asked by 27.12.2018 / 22:34
0
answers

Excel Macros - SubIndice out of range

I am developing a Macros in Excel that takes web addresses from a range of defined cells and makes a query, but when I take the address and make the query it shows me an error message    "Subscript out of range". This is the code I am wor...
asked by 26.12.2018 / 21:46
0
answers

Extract data from SAP to Excel. Error 619

I have recorded a sequence in SAP, and I have passed the code to the Excel developer. In that sequence, the only thing I intend to do is to open a query about it when opening the Excel workbook. I do not have the loop implemented to get all the...
asked by 27.11.2018 / 10:33
1
answer

VBA I have trouble calling a range that is on another page of my book

I wanted to do it in the following way: Selection.FormulaR1C1 = Application.Goto (ActiveWorkbook.Sheets ("TRANSFERS"). Range ("RangePara")) What I want is that the selection that I currently have is with the values of the dynamic range t...
asked by 23.11.2018 / 17:39
1
answer

Problem with IIf and '['] '

In a text box of a form, you can enter a code only with normal characters or characters followed by another code in brackets: [xxxxxxx]. Depending on the type of entry, you must return one chain or another. If the chain has brackets, they are...
asked by 16.11.2018 / 10:47