Optional Automated Data Entry Form

[JJoll]

I have a data entry userform. The user will enter a tracking number and location and the system automatically uploads to a database in a seperate sheet.

I have an additional checkbox for potential additional data. In the event a user need to log a name and comment, they check the box the addtional fields are added and they are moved through the userform.

I need to know how to code the two additional textboxes to function like the tracking and location boxes but only when visible, otherwise I need them to just log nothing.

I have attached an excel for reference.

[Logit]

Please Login or Register  to view this content.

[JJoll]

Thank you, VBA is not native to me and I make lots of little errors even simple things like initializing.