Posts by Iago Gonalves • 9 points
5 posts
-
0
votes0
answers7
viewsQ: How to remove a specific item from an array in vba?
In my code I have an array, and when performing a validation (the ranges cannot be greater than 6) I would need to exclude from the array the items that do not meet this validation. If tempos(t)…
-
0
votes0
answers27
viewsQ: How to troubleshoot incompatible types error in vba?
I am trying to go through a list of filtered results in VBA and found the following syntax, however when running appears "Incompatible types" loc13 = Workbooks("Histórico…
-
0
votes0
answers48
viewsQ: How can I reference filtered results from a list in VBA?
I am currently working on a code where I have to filter a certain list and go through the filtered data with a FOR and also perform some comparisons with IF. Follows the code Sub compararValores()…
-
0
votes1
answer32
viewsQ: How to reference properties of a userForm to a sub in excel?
I created a form in vba (excel) and in this form contains a checkbox, I would like to trigger a given command if the checkbox is marked, however the code to be triggered is in a module sub separate…
-
0
votes0
answers12
viewsQ: How to select the lowest value in a given vba range?
Good afternoon, I am having a problem in a part of the code in which I need to select the lowest value of a given range. I need to select because I will have to use offset to find out the value…