run time error 1004: application defined or object defined error

[derek296]

This is supposed to start a log by having the user input their name and then the marco puts their name and a time stamp on a worksheet. I have a similar code that does this on workbook close but I am running into a run time error when I am trying to use the code on workbook open. Any help would be appreciated

Please Login or Register  to view this content.

[GaidenFocus]

Maybe change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Cutter]

@ derek296

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules (Rule #3) require them so please keep that in mind and add them yourself whenever showing code in any of your future posts.
Thanks.

[derek296]

The code breaks if i include the lines that input the name collected from the input box and the time stamp, but each work correctly separately

Please Login or Register  to view this content.