VBA update search find routine using userform listbox selection

So someone recently helped me with implementing a way to manage data updates using a sheet change event within a lookuplist sheet and it works great...however only if the user updates values on the sheet directly. The goal is this list will be hidden and controlled using only forms allowing the user to work within the forms regardless of which sheet is selected. Many thanks to mart37 for the code:

Please Login or Register  to view this content.

When a value is updated (or added) when not on the lookup sheet, the error occurs on:

Please Login or Register  to view this content.

I've changed ActiveSheet to Sheets(5) - but I'm not sure if I'm referencing the sheets correctly. Regardless, it doesn't seem to make a difference.

The Change event macro only works on the host sheet.

If you want to use the macro to change another sheet then use the change event macro to call another macro.

The Second Macro should be in a normal macro module.

You can delete the Message Box, if that line is not needed.

I understand that the change event only works on the host sheet. The change is indeed made to the host sheet from the sub routine. It's when a change to the host sheet occurs, values are updated within another database within another sheet. Like I say, it works, but only if the host sheet is active. I guess I don't understand why the sheet needs to be active for the sub to fire properly. Is there an alternative, such as something in the update macro to activate the host sheet, make the update (or add), then reactivate whatever sheet the change was made from? Something like:

Please Login or Register  to view this content.

Could something like that work? Does it make any sense? Apologies for the simplicity, as I'm somewhat of a vba novice.

UPDATE: so I ran the below code and it worked to update the host sheet without any error:

Please Login or Register  to view this content.

The value on the host sheet changed via the macro. Why is the worksheet change event not recognizing the value change even when the macro is run while the host sheet is active? It works when I change the value on my keyboard, but not through the form.

Assuming that

Please Login or Register  to view this content.

is the problem area then try removing ActiveSheet so that line becomes:

Please Login or Register  to view this content.

Or try

Please Login or Register  to view this content.

UPDATE: This is an update to my problem of updating a secondary data using an update to primary data value. Originally I was using a sheet update event, but decided that the easier solution would be to just put the code within the update routine. The title has been changed to reflect the issue. I thought maybe posting my solution may help others if they were ever so inclined to have the same issue. It is only for a command button, but I believe one can get the gist.

The userform code allows updates to list of primary values (attributes) using listbox selection through text control. Range data are used to compile a secondary dataset within separate sheet, therefore can contain many copies of primary value within secondary dataset.

When user updates original primary value through the listbox selection, dataset values compiled from the list are updated to reflect updated value. Below is final code.

Please Login or Register  to view this content.