Simple data form

T

Tracey

Hi,
I'm creating a Shipping template in Excel, and I want a simple form to
pop up for the line items. I can see how to do it using Data/Form,
however is there another way to do it, by not making the user do that?
Maybe so the form opens up when they get on the first cell of that part
of the worksheet?

Also I noticed when I do use this form, when I close it, it doesn't
bring me back to the worksheet, but rather to the VB code. I don't want
this to happen to my users. Any ideas?

Thanks!
Tracey:mad:
 
Top