Listbox1 content doesn't appears

Hello,

I need some help with my code in VBA.
I use a listbox1 to bring values from some table. The search identify the values but doesn't show them inside the listbox.

When I use another code to send this data inside this listbox to another cells, also doesn't appear anything

There's an image attached

[IMG]

Please Login or Register  to view this content.

You may have to supply a sample, there's no way to test this code without the workbook.


One thing is

Formula:

Please Login or Register  to view this content.

Would come out as
Cad_0 is there really a range called Cad_0?

Anyway supply a sample .

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

The problem is that you have misspelled variables in preenchersearchall.

In that part of the code you are using both linhalistbox and linhalistbox1.

Try this, and try adding Option Explicit at the top of all the modules to help avoid such a problem in the future.

Please Login or Register  to view this content.