Userform strange behavior

There are no attachements

I hope I understand your problem correctly

It is not just the 1st word that is being replaced but all data

When using the option buttion to select which network worksheet you are looking at You are not saving the displayed data before changing sheets, As the form is already loaded using Load WANInventory will not trigger UserForm_Activate macro.

When you click on the next button because it has data from the previous worksheet still displayed in the form the SaveRow macro overwrites the data on the current active worksheet with the data displayed in the form

using the following code should fix you problem.
Add similar code for other options as well

Please Login or Register  to view this content.

Thank you for your time, this is an excellent forum, and while reading responses to posting everyone is so positive to those like me who are just starting to get their feet wet. Question if I save am I actually writing to the file? This form is to be used by our NOC and I only want them to view the data.

Thanks again..

In the book you posted the SaveRow macro is called by several other macros, cmdPrev_Click, cmdNext_Click, cmdAdd_Click, cmdClose_Click.

Each time it is called it will replace data on the active sheet with the data that is in the displayed form.

If you want to restrict the people that have approval to save/overide the data then I would suggest using this SaveRow macro. It users the PC's User ID to allow access to the save commands - Replace the names in Red with valid PC User ID's

Please Login or Register  to view this content.