Userform code and add and remove entries on sheet

[Nitefox]

Im using a 'Users' userform which loads when the workbook opens, for users to login with a username and password. Im having problems with the code to create a new user (entering the username and password data into the sheet), and deleting users (finding the username in the range, and deleting the row). I feel both of these codes used to work fine, but I have been working tweaking it, and working on other code in the form and now I can't get them to work.

This is the Command Button code for creating a new user. It doesn't produce any errors, but nothing is getting added to the sheet:

Please Login or Register  to view this content.

This is the Command Button code for deleting a user. It produces Run-time error '13', Type Missmatch:

Please Login or Register  to view this content.

I have also attached my workbook. I have disabled the form from loading on startup. It can be opened by clicking on the Users button on the main 'Return Data' page.
Thanks,
James

[jaslake]

Hi Nitefox

Your Workbook Open Event is looking for a Sheet named "Search" but does not find it

Please Login or Register  to view this content.

[Nitefox]

Sorry, I removed the page to get the file size down, just ignore that.

[jaslake]

Hi Nitefox

Zip your file if you must...let us see the original file...

[Nitefox]

I removed the code looking for the 'Search' sheet on workbook open (see new workbook attached).
Dont worry, the search sheet has nothing to do with the 'User' userform.

[jaslake]

Hi Nitefox

In the Add Button Code you need to add the dots (.) such as this

Please Login or Register  to view this content.

In the Delete Button Code try this

Please Login or Register  to view this content.

[Nitefox]

Thanks Jaslake.
The Delete button code works great, but the Add user button still doesn't work. It seems to add a blank entry to the list. Whats strange is no data gets added to the sheet, but the Dynamic range keeps expending as if there is, just creating blank entries in the User Combo box drop down list.
See attached.

[jaslake]

Hi Nitefox

You missed two Dots(.)

This

Please Login or Register  to view this content.

Should be

Please Login or Register  to view this content.

In addition, as a result ** the missing Dots(.), you have data in about Row 1622 ** Users. Delete everything below your actual Last Row...the Code will work.

[Nitefox]

Thanks, that did it.

[jaslake]

Hi Nitefox

You're welcome...glad I could help. Thanks for the Rep.