object required

  1. M

    Object Required Error

    I'm struggling on figuring out why this is giving me an object required error. Private Sub CommandButton2_Click()Dim ws As Worksheet Dim wb As Workbook Dim Answer As String Dim MyNote As String 'Place your text here MyNote = "Do any of your Providers have more than one specialty?" Set wb...
  2. Henkvdm

    Object Required: ' ActiveWorksheet" -

    My issue: The Script I use worked perfectly until now. The last time I ran it was last month "March 2018". The script itself is very simple. I open an Excel Workbook ( only one), execute the script from SAP SCM. The script reads one MARKET at a time and then runs trough a list of steps. The...
  3. A

    Run-time error 424: Object Required

    Hello, I am an excel beginner trying to make a UserForm for data entry. I made the UserForm and had it working, then accidentally saved the file as the wrong format and had to make a brand new one. I was able to copy the code and add it into my new VBA with all the same box names, but now when...
  4. P

    Error: Object required - when testing if statement

    Hello Guys, I am getting ## Run-time error '424': Object required ## when executing the code below: Private Sub CommandButton2_Click() 'Application.ScreenUpdating = False Dim xlWB As Workbook Dim xlWS As Worksheet Set xlApp = New Excel.Application pathfile = "Tracker.xlsx" Set...
  5. S

    Object Required Error Message Help

    So I am trying to create a macro that reads the value in my Worksheets('Main Page").Range("B13") and then goes and searches through the rest of my sheets and will delete that entire row, in which the value is found. I am receiving an error that says "Object Required". Any help would be great...
  6. K

    Check Box Value Error "object Required" Error 424

    This is the First Macro i've ever tried to create. There is two but they are both giving the same error. Any help is appreciated!!! Sub L2LTrue() If L2LCheckBox.Value = True Then 'L2L True Macro Range("E20").Select ActiveCell.FormulaR1C1 = "=R[38]C[5]-R[39]C[1]-R[-12]C[-3]"...
  7. D

    Userform Multipage Show method 'object required' error

    Hi guys, I'm quite new VBA coding, and particularly to coding for UserForms. I'm trying to make a UserForm tool to enter information into a database. I have created a number of UserForms which I want to link with buttons such as Next or OK. The .Show method works fine for most UserForms I have...
  8. S

    Copy/paste without clipboard "Object required" ?

    Windows 7 excel 2007 Im real new at VBA (but do know some PHP if that helps lol) ANYWAY a website had a way to copy and past without using the clipboard link here: "Optimize Slow VBA Code. Speed Up Efficient VBA Code/Macros" Sub Testing() Sheet1.Range("A1").Copy Destination:=Sheet2.Range("B1")...
  9. M

    object required

    Hi, Im new to vba. Literally started learning the language 3 days ago. I have created a textbox within a userform so that my users can input a date. But i keep getting "object required." please help. here is my code. Dim Final_Date_of_Service As Date Private Sub...
  10. A

    VBA to copy Cell.Formula to cell comment

    Hi everyone, I have had a shot at some code that will check if a cell in the selected range has a formula and if so add this formula as a text string in the same cell's comments. Public Sub CellFormulaToCellComment() Dim CellInRange As Range 'Dim CellComment as String For Each CellInRange...
  11. dmqueen

    VBA Object Required Error

    I finally got my code to compile, but can't run it due to an 'Object Required' Error. Runtime 424 Error from the worksheet button. I think it's because I need to us a SET statement when assigning a value to an object, but since I'm not using an array I'm not sure where it needs it! code below...
  12. dmqueen

    VBA Invalid Qualifier Error

    I'm eceiving an Invalid Qualifier Error for LastPartNo in Sub InputPart, even though I have clearly defined it as an Integer before I tried to use it. I attempted dding a Temp Str type as a go between in case of a type mismatch. Still no luck. Ay help would be much apreciated! :) lSub...
  13. P

    xyPlot automated series addition

    Hi all, I'm currently making an excel workbook where a user inputs a range of data which gets processed and reorganised into a table like the one below found in the "Intermediate" sheet in the workbook. There can be anything from 1 series to dozens, even hundreds. <tbody> Name Y1 Y2 X1 X2...
  14. R

    Object Required calling function on another form

    I am having issues with this code calling the public function EditEntry on frmRunEntry Private Sub CommandButton1_Click() Dim Response As Long Dim RowNum As Variant 'Get the record ID from the user Response = InputBox("Please enter the ID number") 'Test the user input...
  15. T

    WriteLine error

    Morning all, The code snippet below is the subject of my question. If r = 7 Then analyte = "Horizon Depth to Top" If Cells(r, K) = 6 Then Err = Err + 1 stream.WriteLine analyte & " is missing in cell " & KOL & r & ", please...
  16. 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 =...
  17. D

    Compile Error: Object required that I can't fix

    I am having trouble with the following code where I get a Compile Error: Object required error on the first set command. I'm obviously missing something right in front of me, but I can't spot it. Why doesn't it like hHeader? Thanks for looking at this. [code] Sub delHead() Dim sh As...
  18. I

    Button to MsgBox help plz!

    Hey, I have designed a button to run a macro which deletes old information when pressed. I wanted to have a vbYesNo MsgBox popup to ask the user if the are sure they wish to delete data. This macro seems to work fine and completes its task but once it is finished I am getting "Object...
  19. A

    Runtime error 424, Object required - while populating ComboBoxes

    Hello Everyone, I have 2 Activex ComboBoxes on a sheet and I am trying to populate the range in the 2nd combobox based on the value in the first combobox. Here is my code. But whenever I run it, I get the following error: "Runtime error 424, Object required" .. Please Help! Note: Linked...
  20. T

    424 Error - Object Required

    Hi, these procedures belong to a rather long process, so I've pulled out only what I think is applicable. The first two procedures work fine. The second two procedures should work in the same way, only they don't. Instead, I receive a 424 on line 1 of Sub TransferAssociate(MyCell). So far...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    • Replies: 44
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    • Replies: 35
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    • Replies: 28
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    • Replies: 24
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    • Replies: 23
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    • Replies: 23
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top