getting an error called Object required

[baig123]

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

Please Login or Register  to view this content.

[Norie]

Where do you get the error?

[baig123]

Please Login or Register  to view this content.

ListBox1.text

[Norie]

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.

[baig123]

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

[Norie]

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?

[baig123]

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

[Norie]

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.