424

  1. ACommandLineKindaGuy

    Object required (Error 424)

    This is weird: I have 4 command buttons (CommandButton1 thru CommandButton4) and 1 text box (TextBox1). I get a 424 Error whenever I try to set a TextBox1 property such as TextBox1.Left I ran a short sub to grab all the shape names in the active worksheet: For Each Sh In ActiveSheet.Shapes...
  2. S

    Error 424: Looping using For - Next

    Hi, New to VBA here, getting error 424 object not found with this code after running, it runs only once perfectly but stops after 1 iteration. Consider "yyy" as all different variables (code I am using is below). Any help would be appreciated :) :) <tbody> Sub DeleteSpecifcColumn() Set...
  3. B

    Finding all pivottables in a workbook using for each loop - 424 error

    Hi all, I'm new here, so forgive me if any formatting isn't right the first time! I hope you guys can help me out with the following issue: I'm trying to find all pivottables in a workbook using the following code. The goal is to instruct the found pivottables further on, but first I need to...
  4. D

    Run time error 424

    I have a very basic code to copy "non-blank" data from one sheet and paste to another. The code is not complete yet - I am running in debug mode I get the above error. My code is as below. Sub SampleFind() Dim StrWord As String Dim Quantity As String Dim i As Long Call nrows For j = 2 To 2...
  5. N

    VBA, InputBox, Run-time error '424': Object required

    Hey guys, I'm having an issue with my InputBox command, I have underlined the part that's returning the error. .... SelectHeading: On Error Resume Next 'Need to let the user select the proper heading. Dim rng As Range Set rng = Nothing Set rng =...
  6. Hadouken

    pop up calender vba

    Okay so its the vfirst time ive tried using developer tools but its been to no avail. I created a calender using the following code Private Sub Calendar1_Click() ActiveCell.Value = Calender1.Value Unload Me End Sub Private Sub cmdClose_Click() Unload Me End Sub Private Sub...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top