User Form with Empty row but user may enter data manually

I am very new to VBA and am trying to put together a user form (Learned to make one this week). The worksheet that it is populating I don't want to be overwritten when the user has manually entered something. They are scanning a huge barcode that I break apart to use, to populate other cells as well as Vlookup to get additional items. I enter the data from the userform in the first three columns, which I hide to the user, and an additional six are hidden. The first column the user sees is Column "I" which is where they may enter information that I want the user form to see and skip. The cells in column "I" also contain a formula to return a value from one of the hidden columns. There are time they will need to manually enter, and this is sporadically throughout the day.

This is what I have

'

Please Login or Register  to view this content.

Originally Posted by Nole68

The first column the user sees is Column "I" which is where they may enter information that I want the user form to see and skip. The cells in column "I" also contain a formula to return a value from one of the hidden columns. There are time they will need to manually enter, and this is sporadically throughout the day.

I understood up until this point (above). Then you lost me. I'm not sure what the question is?