VBA Userfrom problem - easy solve

[ExcelFailure]

Hi there,

Can anyone tell me what is wrong with this code? It is drawing it's data from a query table in a sheet called "sheet3". When i run the userform, the listbox just comes up as blank. Can anyone help?

Please Login or Register  to view this content.

Thanks

[Kyle123]

How are you loading the userform and what is the value of the ActiveCell? If it has a value, is it uppercase?

[Norie]

It's Userform_Initialize not Userform1_Initialize.

The latter will never run, so the listbox will never be populated.

[ExcelFailure]

Thanks for the reply.

Basically it's a load of numbers, up to 5 digits long. I am loading the userform from a form button, and then unloading it when I double-click an entry in the listbox. The entry I double-click then goes through to the Active Cell.

[Kyle123]

Ok, I think you want:

Please Login or Register  to view this content.

[ExcelFailure]

Excellent, that works. The only trouble is, I have a Vlookup working off that cell, and it doesn't work. The reason is because in the query table, the numbers are "numbers stored as text", whereas the numbers that the userform puts into the cell are just numbers. Therefore the Vlookup views them as something different, bringing through N/A instead of the stuff I need.

Any ideas?

[Kyle123]

I've changed my code to input the number as text

[ExcelFailure]

OK thanks Kyle. Your code has the same problem, in that the Listbox is blank. When I used my previous code and replaced Userform1_Initialize with Userform_Initialize, it worked fine. Is there anyway I can edit my previous code to enter a number stored as text? Or to somehow get your code working?

Thanks very much. Appreciate it.

[Kyle123]

Can you upload a small sample workbook? your code is horrifically slow , mine is much faster, so if you can upload some sample data I'll see if I can fix it

[ExcelFailure]

OK here goes Excel Forum.xlsm

[Kyle123]

Ah, I'd changed my code since that version, try it now...

[ExcelFailure]

Excellent - that has sorted it. Thanks very much for your time.