I created a code to pass data from one excel file to another (it is a little confusing project because I am in a company), I believe that the code is correct in general but when I run the program it gives an error called "Object Required" in the variable " k ", can someone help me?
I need to use the "range" parameter to select a specific cell, it happens that when I "run" the program it gives an error and says "The specified dimension is not valid for the current graph"
If Range("H(CStr(k))").Value = "" Then...
I am trying to create a macro that passes values between 2 different excel files, I tried to create a counter whenever the values are inserted in the spreadsheets, the program does the same for all the spreadsheets available in these files, in case the cell where the value will be inserted the...
I created a code to open the most recent file in a specific folder and copy the value if a specific cell to another in a different excel file, the program executes everything, including I receive the value "msgbox" but the values are not written on the second sheet " EEC QEC.xlsx ", could...
I want to make a macro that just inserts values in cells where the name of the worksheets is different from "Potable C1", "Potable C2", "Potable C3.1", "Potable C3.2", the code is not working because it is writing in all spreadsheets, can someone help me?
Dim sh As Worksheet
Dim counter As...
I have 3 columns
A - Equivalent to "Machine Name"
B - Equivalent to "OT Number"
C - Equivalent to "Responsible Technician"
I would like to know if it is possible to create a procedure that when the user inserts the "OT Number" the procedure looks in column B if there is already an "OT...
I have a form called "Miter_2_Correc", and I don't know why vba won't let me open it, can someone help me?
Private Sub bt_calculate_Click()
Private Sub CheckEmpty()
If Not IsNumeric(tb_x1.Value) Or tb_x1.Text = "" Or Trim(tb_x1.Text) = "" Then...
Good afternoon friends, is there any way to write a value in a specific cell on each sheet of the excel workbook using "Foreach" or in some other way?
Example: Write the number 3 in cell A3 of each sheet of the current workbook
I am trying to open the most recent file in a specific folder but when I run the program an error appears and says that the folder does not exist (but it does exist), can someone help me?
Private Sub WriteValues()
Hello guys, i have a problem in my procedure, everything that happens before trying to execute the procedure is read by the program,
but when we call the procedure it doesn't just work in the specific form, can someone help me?
This codes works:
Private Sub bt_calculate_Click()...
Dim oPL As Double, o709 As Double, o710 As Double, o713 As Double
Application.ScreenUpdating = False
Sheets("Calculation_Sheet").Visible = True
Note: P666, P709, P710 and P713 are global variables...
Private Sub UserForm_Initialize()
lb_hello.Caption = msg
lb_tec.Caption = Tec
Dim mHour As Integer
Dim msg As String
mHour = hour(Now)
If mHour < 12 Then
msg = "Good Morning"
ElseIf mHour < 18 Then
msg = "Good Afternoon"
I'm trying to select a textbox from my form in excel with the command #set focus "but apparently it gives me an error, can someone help me?
Private Sub cmd_Recheck1_Click()
A0r = in_A0r.Value
A90r = in_A90r.Value
A_90r = in_A_90r.Value
A1 = 0
A2 = A90r - A0r...
Since I added the time format the code stopped working, is there any way to include the time in the file name?
Dim FilePath As String
Select Case MachineName
Case "A4", "A8.1", "A8.2", "A8.3", "A12.1", "A12.2", "A12.3", "A20.1", "A20.2"
Hello! EDIT: Wrong title, sorry
For this problem of mine, I know what I need to do, but I'm not really sure where and how to implement it properly. So:
If the checkbox is selected, and the first combobox is selected, the options for the first combobox will be allowed to be selected. Then, if...
I have come to the conclusion there appears to be two distinct styles of programming in VBA.
1. Those with no prior experience of programming.
2. Others who are already conversant with Java, C#, etc.
I have seen VBA code such as:
Function MyFunc (somearg As Burger) As McDonalds
Hi. I read through Chip Pearson's Programming the VBA Editor and his examples are working for me. What I want to do is programmatically control the font in the VBE code modules without using the Font Dialog because that dialog does not exist on the Mac. After checking the Object browser, it...