I have a UserForm with a few textboxes/comboboxes on it. For textbox5 I have the text and value (they are hand in hand I guess) of the properties window as =CurrentUser(). When the submit button is clicked, the CurrentUser name is transferred to the next available cell in column B which works fine. The problem is that when the next user opens the file, it changes all the previous user names to their (the current users) name. Is there a way to have just the CurrentUser name transferred to the cell without the formula being transferred with it? I have to have the current user name in the cell for traceability purposes. I have attached a sample of the expected outcome and the actual outcome.
CurrentUser before and after.xlsx
Any help is greatly appreciated
Thanks
Bookmarks