Userform Listbox to Activesheet.Range(Activecell.address).Value Error

Hello Everyone,
so I've Been Working on a project using a userform listbox to pull data from the web, then you select the data and it enters it into the activecell starting at cells(0, 0) in theory.
Ok a little bit of Workbook insight to help with functionality:

1 sheet1 - double click on cell range A3-A2000 will add title to Userform1.tbsearch (film title)

2 click search button will populate lbsearch (search results) with list of movies

3 click getData (Get Movie Data) will populate DataResults (results) with movie info

4 (this is where its broken) doubleclick movieinfo (getData textbox) should populate active
cell on sheet1 offsetting to each column of same row with data from DataResults ListBox..
but errors out on list index..

WorkBook: MoviesV4.xlsm

this is the code:

Please Login or Register  to view this content.

i had it working when i separated the data into two userforms, but thought that to be inefficient but it did at least work.
any help here will be absolutely appreciated

Why not populate the worksheet from the results listbox?

Thanks Again Norie,
So I put in the new For Statement, and again it errors on me,
Debug 2.png

Please Login or Register  to view this content.

It worked twice, then just continued to error out

Its probably me I'm certain. as for using the second search string to populate the Movie info, the reason behind that is cause the search from movie title doesn't have enough Data, and the results are varied, where as the second search string id specific to the Movie ID number, bringing back only that movies results, and has all the infomation i could need.
i just realised when i use my radio button to do a search, it errors at htis line

Please Login or Register  to view this content.

but it seems to be random.. thats i guess a different topic though..
-Daniel

Norie

The userform will be used when movie info is incorrect. The Module APIrun will gather the bulk of info. this worksheet is only to workout the bugs, and correct the code, the final worksheet has a control sheet for displaying the selected data, running the movie, keeping up with organizing, ETC

API # is a Key

The Search results List Box uses the Web Address of

HTML Code: 

and the "strMovie" Variant (Movie Title) has to be the text movie title i.e. Fight Club

HTML Code: 

it also returns a range of movie titles with the same text to select the corrected one from



Where as the results List Box uses

HTML Code: 

and the "strMovie" Variant (Movie ID#) has to be the the Movie ID Number i.e. 550

HTML Code: 

and it only returns the movie info for specified ID #, plus it has info such as director, official site, trailer, poster, etc.. i just don't know how to pull the extra info yet