+ Reply to Thread
Results 1 to 8 of 8

getting an error called Object required

  1. #1
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    getting an error called Object required

    here i am trying to list the batch names of min but showing an error

    Please Login or Register  to view this content.

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: getting an error called Object required

    Where do you get the error?
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: getting an error called Object required

    Please Login or Register  to view this content.
    ListBox1.text

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: getting an error called Object required

    Firstly, do you have a listbox named ListBox1?

    Secondly, what's the ("tblprod_agr_001","tblprod_agr_002") part here?

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: getting an error called Object required

    i have a sheet it having lots of data

    whenever i run macro it

    i will get 2 options --->Access data
    Updating data

    if i click update data it display the list of batch where i have to update data

    that why i have used listbox1.

    it is possible to generate like this

    can i used listbox or combo box as an

  6. #6
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: getting an error called Object required

    As an ???

    Listbox1.Text will only return a string, so I have no idea what you are trying to do with the part in brackets that follows it.

    PS If you remove the part in brackets do you still get the error?

  7. #7
    Forum Contributor
    Join Date
    03-01-2014
    Location
    Mysore
    MS-Off Ver
    Excel 2007
    Posts
    379

    Re: getting an error called Object required

    what i was saying if i run macro

    i will get an options like this 1. Access data
    2. Update data

    if i click update data--->itshould display me an option which list of batches like this
    1.tblprod_agr_001
    2.tblprod_agr_002

    i have to select the batch name to update the data

    it is possible
    Last edited by baig123; 08-08-2014 at 06:32 AM. Reason: paragraph

  8. #8
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,620

    Re: getting an error called Object required

    I'm really not following, what does the listbox list?

    Also, what is the part in brackets supposed to be/do?

    If the listbox lists the values in brackets you don't need that part in the brackets.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simple Calendar pop up macro --> error Run-time error '424': Object required
    By am_hawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-11-2013, 10:38 AM
  2. [SOLVED] Object Required Error
    By Steve0492 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-14-2012, 06:36 PM
  3. Replies: 3
    Last Post: 03-29-2012, 01:58 PM
  4. Name.Object (Error Object Required)
    By dssrun209 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-12-2010, 01:38 PM
  5. Error 424 Object Required Error when Using AddItem to ListBox Generated in Code
    By jclark419 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-01-2010, 12:47 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1