Get instant live expert help on I need help with vba sub or function not defined
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
Im getting an error on this code when trying to filter on VBA userform using listbox: .List = Application.Index(vData, _ Evaluate("Row(1:" & lMatches & ")"), _ Evaluate("Column(1:" & UBound(vData, 2) & ")")) Im getting error : "Application-defined or object-defined error."
Solved by Z. H. in 25 mins
I created a user-defined function (VBA) to make some calcs. Once I got the results, I saved it, then came back to keep working on it and the cells where I used the VBA are showing #VALUE!
Solved by M. S. in 21 mins
i'm having issues with the vba private sub code for tableupdate
Solved by T. H. in 28 mins
I need help with VBA Code. Private Sub OptionButton2_click() If OptionButton2.Value = True Then Range("B4").Value = "Alaska Airlines" End Sub
Solved by D. C. in 15 mins
Private Sub CommandButton1_Click() If TextBox1.Value = "" Or TextBox2.Value = "" Or TextBox3 = "" Then If MsgBox("Form is not complete. Do you want t ocontinue?", vbQuestion + vbYesNo) <> vbYes Then Exit Sub End If End If ActiveCell = TextBox1.Value ActiveCell.Offset(0, 1) = TextBox2.Value ActiveCell.Offset(0, 2) = TextBox3.Value ActiveCell.Offset(1, 0).Select Call resetForm End Sub Sub resetForm() TextBox1.Value = "" TextBox2.Value = "" TextBox3.Value = "" UserForm1.TextBox1.SetFocus End Sub Private Sub CommandButton2_Click() Unload Me End Sub Private Sub Label4_Click() End Sub
Solved by F. S. in 12 mins