Search results

Hello everyone i recently got sent the following code Sub ENTRADAS_SAIDAS() Application.ScreenUpdating = False 'Beginning Range("A1").Select Rows("2:2").Select ActiveWindow.FreezePanes = True ActiveWindow.Zoom = 85 ActiveWindow.DisplayGridlines = False...

Hello everyone I've been recently using this code to get information from some of the databases at the company im interning at. This is the code im currently using: Private Sub Worksheet_Change(ByVal Target As Range) Dim userInput As String Dim conn As Object Dim rs As Object...

Hello everyone Im currently writing the code below (there's more stuff upwards and down but its not relevant to this section of code) but now i've encountered an issue i don't know how to fix i want to make a piece of code that analyzes from I3- AL and finds me the max and min value in each row...

Hello everyone I am in need of assistance in making a macro for CATIA V5 i do not know almost anything about this program but i was asked to make a macro in VBA that when the user runs it will insert the biggest possible sphere inside of the model that was opened,regardless of what model it was...

Hello everyone,i've found myself with an issue that i have no idea on how to resolve I have this file that is protected and people are not supposed to be delete,rewrite stuff on it,etc... The thing is that i have filters on the first row and even though the sheet is protected and i don't want...

Hello everyone I am writing here because im in need of help when it comes to putting information from another workbook on the list box The code below works but what is really screwing me over is the way that the information is being sent to the list box...

Hello everyone,im not sure if this is the appropriate place to post this but thought i should give it a try. Im currently trying to add the CATIA libraries to my vba editor when i open CatiaV5,however the "References" button in "Tools" section is greyed out and i cannot select it. I've been...

Hello everyone I have made the code found below which exports all the data found in the specified range,however now i want to make it so that when filters are selected it will only export the filtered data and not everything but i do not know how to do it Here's the code i wrote : Private Sub...

Hello everyone I have this code right here and i want to add another something else to it but i have no clue how to Private Sub CommandButton1_Click() Dim repeticoes As Integer repeticoes = Me.ComboBox1.value Dim sourceSheet As Worksheet Dim targetSheet As Worksheet Dim...

Hey everyone,first off im not sure if im allowed to post this here since it has more to do with power automate than excel itself but since i really dont know where to ask this i thought i should try it here. Im developing an interface in excel and now i thought of adding a feature to it...

Hello everyone I have a question regarding the resolution and zoom of a monitor. I am currently doing an Internship in a company and they have asked me to develop an interface in VBA that will be used in the Tear Down area of the company. Currently the interface is almost finished,however i am...

Hello everyone I recently made the code below which reads the values inside certain columns and verifies if they are all on the same row and increments if the combination is the same as the one defined But now i want to add another feature to it and im not sure how to go about doing it which is...

Hello everyone I am using the date picker developed by Trevor Eyre and i would like to make it so that the user CANNOT pick any date that is after today's date. How can i achieve this? Thank you

Hello everyone I would like to know if its possible to make a graph in excel that displays the original graph and it also displays changes that have happened in its life cycle Below i put an image i made in paint to kind of give a better idea of what i mean The red lines are supposed to...

Hello everyone I would like to know if it is possible to transport info inside of a QR code to a excel spreadsheet when said code is scanned For example if the QR code belonged to a production piece, and inside the QR Code there was information like its model,production date, the type of piece...

Hello everyone,im new to coding vba and im in need of assistance. I want to make a code to be used in excel that makes 2 of my 4 text boxes have a data format like this dd/mm/yyyy and also a character limit Like i said made a code to implement 4 textboxes on the worksheet but i really have no...

Hello everyone,im new to coding vba and im in need of assistance. I want to make a code to be used in excel that makes 2 of my 4 text boxes have a data format like this dd/mm/yyyy and also a character limit Like i said made a code to implement 4 textboxes on the worksheet but i really have no...

Hello everyone,i am new in vba and i would really appreciate some help when it comes to comboboxes. i've been able to code multiple comboboxes into the sheet but i want some of them to only be active after the user has selected items in the first 2 comboboxes what im trying to say is that i want...