Macro code to show userform bringing runtime error 1004

Hello,

I have the following code in a standard module:

Please Login or Register  to view this content.

The userform code is as follows:

Please Login or Register  to view this content.

However I am getting a runtime error 1004 which says application-defined or object-defined error.

Can anyone help please?

Open the VBE (Alt + F11) and click on the line of code "Private Sub UserForm_Initialize"
Then by tapping the F8 button to step through the code line by line, tell us which one it errors out on.

Or, attach the workbook so we can see.

BSB

Thank you - it errors when I try to move on from the Set rRng line

Any ideas?

Have you checked (and double checked) all names used ?(Sheetname, tablename, headername)
Because I just setup a table and it works just fine as you wrote it.

Sorry, it was a very stupid mistake on my part. Thanks for pointing me in the right direction

Just further to this, my code is now:

Please Login or Register  to view this content.

When I press the CommandButton3 it doesn't search in the table for the value of textbox1 and put the results in the listbox as it should. If I press the button with nothing in the textbox it comes up with all the entries in the table. If I put any text string in the textbox it comes up with nothing in the listbox?

Can anyone help?

Please post sample workbook which represents actual situation so we have some testing material.