Posts by Hudson Komuro • 301 points
9 posts
-
1
votes1
answer492
viewsA: Is it possible to add a conditional to a combobox options? VBA
Ola Leandro follows the example. But I would like to warn you that this is a simple problem and ask you to take a little more time looking for the solution. It is very likely that this…
-
0
votes2
answers107
viewsA: I have a password in excel and want to change it in vba
In case you are trying to create your own login system in the spreadsheet has a code that may help you that I use. Create an object of type Class and paste the information below: Private Const…
-
1
votes1
answer155
viewsA: Add Item and Index to combobox
In this line: cmb_funcionario.AddItem (rs("nome_Funcionario"),rs("id_funcionario")) Remove the parentheses, Window adc. the comma but placed inside the parentheses making the Additem method…
-
1
votes1
answer2198
viewsA: VBA Code: Block specified cells without protecting the entire spreadsheet
Follow the code with improvements: The rules are simple, in the code where this: vStrLocalsProibidos = "A3,A5" Voce must declare all places where Voce wishes not to have permission. Interspersed…
excel-vbaanswered Hudson Komuro 301 -
1
votes1
answer1097
viewsA: Error pasting data in Excel with VBS
About your code above, as I mentioned before is a particularly common problemVoce needs to specify where Voce wants events/properties to occur. In case the problem seems to me that Excel does not…
-
2
votes1
answer983
viewsA: The Value method of the Range object failed
I am not a fan of using "Active" family commands. Because of this type of problem that may or may not occur. Do If Not (IsEmpty(ActiveCell)) Then ActiveCell.Offset(1, 0).Select End If Loop Until…
-
0
votes1
answer40
viewsA: Aggregating row-by-row information in excel column
As the danieltakeshi mentioned above, more information is needed for a more accurate answer. But follow a code I made that can help with what you need: Sub TrasporRangeSelection() Dim vShtFonte As…
-
3
votes1
answer1450
viewsA: Open Excel spreadsheet and copy the Data into VBS
Try this: Path = "C:\Users\user_name\Documents\excell\planilha1.xlsx" Set objexl = CreateObject("Excel.application") objexl.Visible = True Set objwkb = objexl.Workbooks.Open(Path) Set objsht =…
-
2
votes2
answers119
viewsA: MACRO to insert image with respect to drop-down list
Solution without macro Within what you’ve already built what you need to do is create a [Name Defined] formula and then link to the camera. Follow the steps: Log in to [Name Manager] In name manager…