Questions tagged as 'vba'

Tagged questions
1
answer

Create image in another form

I have the following project: WhenIclickthebuttonitworksperfectly,noproblem,butIwantedtheQRCodetobegeneratedinSheet2forexample.BelowthemacrocodeSubGenQRCode(ByValdataAsString,ByValcolorAsString,ByValbgcolorAsString,ByValsizeAsInteger)OnError...
asked by 01.09.2017 / 13:19
1
answer

Search in column P for a value or and calculate this value in cell U?

From now on I want to thank @Leandro Felipe Moreira for the help with the following code: Sub teste() rng = Columns(16).End(xlDown).Row MsgBox rng For i = 1 To rng If Cells(i, 16).Value > "0" And Cells(i, 16).Value <= "100" Then...
asked by 05.06.2017 / 20:57
1
answer

VBA macro for automatically inserting images based on a code column

Good afternoon, I have a spreadsheet, which has a column with the code of the photos and the other column next to it with spaces to insert the images. I would like to know if there is any way to elaborate a macro, in which it recognizes the c...
asked by 30.03.2017 / 18:58
1
answer

Cell selection

I need to select the line with the value of combobox 1 and the date of combobox 3 to select the desired line to delete. This is the problem I have to solve. Can someone help me? This is the code I have to select the cell of combobox1: Pr...
asked by 25.05.2017 / 17:04
1
answer

Consolidate macros

I need to create a macro that allows me to choose all .xml files and import them into excel. At this point the process is as follows: - I open the first one manually and then call the macro that imports all the others selected. I would like to k...
asked by 26.08.2016 / 21:46
1
answer

How to remove a Label that was dynamically created in VBA?

The code below, sent by Luiz Vieira, creates Labels dynamically and a click-handling function for each Label. I would like to know how to use the Click event to remove the Labels that were created dynamically. Creating Labels: Dim Labe...
asked by 21.06.2016 / 14:18
0
answers

How to inherit a form in VBA?

I need to inherit a form in a VBA project to use as a basis for other forms. For example, a form called " Table " contains a list of two columns and buttons for ' Edit ', ' Include ' and ' Delete ' items; and whenever you make use of tables...
asked by 15.05.2016 / 19:54
1
answer

Capture event click dynamic checkbox [duplicate]

I created a CheckBox list as each category is inserted into the database. However, I'm not able to capture the click event of these dynamically created CheckBoxes. Does anyone know where the error is? Public Sub CarregarCheckBoxCategoria(Cat...
asked by 29.06.2016 / 04:19
1
answer

Message "Compile error" (Loop without Do)

I do not understand why I've put Do Until! Private Sub cmdPequisar_Click() 'Verificar se foi digitado um nome na primeira caixa de texto If txtCPF.Text = "" Then MsgBox "Digite o CPF de um cliente" txtCPF.SetFo...
asked by 28.06.2016 / 21:11
0
answers

Zip Code Search [closed]

I am developing a solution and there is a need to add zip code search. In return I would like to get the address based on the informed CEP. I started writing the code below but I stopped it. Sub lsPesquisaCEP(ByVal sCEP As String) On Er...
asked by 07.08.2018 / 20:20