Change Workbook Open event Zoom via VBA

I have set up a form to allow the user to modify up to 8 separate usernames zoom level for the workbook, as some screen resolutions are set differently.

I use a faily basic setting to set the zoom level for each user as below:

Please Login or Register  to view this content.

My question is how do i change these zoom levels now from the form data?
The form has 16 textboxes.
8 for usernames & 8 for the zoom level for each user.
2 buttons, 1 cancel, and one to save changes, where i need to update the changes to the workbook open event.

Solved.

Ended up placing a range of cells on a sheet, and saving the updated vales there, then using the range of cells instead of the usernbame and zoom levels in the workbook event.