Userform only works on sheet 2

Hi All,

Still quite new to VBA but I've put together a little application to help my team try and manage the assets we have. Each with its own asset ID.

I wanted the application to be able to allow the team to book in and out assets and for it to be recorded simultaneously on an audit log, and for it to be able to update the asset register (sheet 2) with the name of the person who its assigned to and update the status from "available" to "unavailable" etc.

The problem I have is that the userform only seems to work when I press "play" from the vba editor and if sheet 2 is open! I cant seem to figure out why it wont run correctly with sheet 1 open.

Any help would be amazing.

Thanks in advance.

I've tried to add the workbook to this thread post. Bare with me if it hasnt worked.

ws2 had not been assigned early enough

Please Login or Register  to view this content.

Thanks for this.
So I've updated the code with your additions and unfortunately it still doesn't have the desired outcome.

There is no error produced. It just doesn't function properly. The "Audit Log" sheet updates fine and as expected, but the "Asset Register Worksheet" remains unchanged.

All worksheets will also remain locked for editing by a password.

Any further suggestions? Its been bugging me for so long! Desperate to fix!

AH!! My brain thought I had done what you suggested but I had, infact not... It works! Genius!

Thank you so much both of you!

I found despite setting the worksheet the find was not stable.
As you have already loaded the combobox you know the item exists.
Therefore use the combobox listindex to ID the row.
I have altered the attached code to suit, it is several lines shorter and is direct with no need for searches.