Questions tagged as 'vba'

Tagged questions
0
answers

Fill textbox for textbox

I'm creating a project in VBA because I'm new to programming and I'm having trouble with part of the project. I have 3 textbox, two are user and password, the other I will load the users separated by comma or by comma, no matter what. I ne...
asked by 01.02.2017 / 12:48
1
answer

fmBackStyleTransparent does not work in Excel VBA

I have a VBA issue with Excel , and so I looked at other users as well and have no answer so far, like this link. BackStyle property = fmBackStyleTransparent does not work It happens that the property no longer works in the current, o...
asked by 28.10.2016 / 03:02
1
answer

How do I paste text into the same Excel column?

I copy data from a PDF and I would like each line to be pasted all into the same "A" column, because then I have a macro that does all the splitting work into columns that works fine. On my computer, Excel sticks to a single column as soon as...
asked by 26.09.2016 / 21:03
1
answer

How do I sum all the numbers in each row and column? [duplicate]

I'm trying to sum all the numbers in each row and column. I tried to do as below, but it is not working. ranger .ClearContents For n = 1 To 10 For Z = 1 To 10 Cells(Z, n) = Int(100 * Rnd()) k = Cells(n, Z) If Int(k / 2) - k / 2 = 0 T...
asked by 20.07.2016 / 16:42
1
answer

vba PasteSpecial does not work

I'm cropping the values from one worksheet to another. The clipping is done without problems, the data is going to the clipboard, but I am not able to paste. Code Private Sub CommandButton1_Click() Dim raizen As String Dim contador As Int...
asked by 16.08.2016 / 13:20
1
answer

Failed to generate TXT file by routine for printing in VBA / Excel

The form below is the code in VBA (Excel) below. ThiscodereferstoprintinganExcelspreadsheetofname" Printing " as shown in the figure below. By the parameters passed in each button, all the data that appears in this worksheet will be printe...
asked by 26.06.2016 / 03:24
0
answers

Run-time error: "9", subscript out of range

My code is all there, but I can not find the error. Private Sub CommandButton1_Click() filtro_normal End Sub Private Sub CommandButton1_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single) Plan2.Ran...
asked by 07.04.2016 / 14:44
1
answer

Color Palette (VBA / Excel), right-click event for Frame objects

I could not find reference to the event that is triggered by the right mouse button in a Frame object. With the left mouse button event I select the desired color, this is working, but with the right button I would define the custom colors dynam...
asked by 08.12.2015 / 19:53
0
answers

Text CheckBox "Yes" and not "True"

Good afternoon, I'm producing a form and I need to know how I do it so that when the CheckBox is selected it will deliver the text "Yes" and not "True" (my excel is in Portuguese). I think this is a simple solution but I do not know how to co...
asked by 05.10.2015 / 21:38
1
answer

checkbox query

Can someone please help me? How do I get a value other than true or false in the checkbox? Example: I click on the "test" checkbox. I do not want the word "test" to appear, not true. Thanks!     
asked by 27.07.2015 / 19:40