I am using Excel 2003. I have a spreadsheet called planning. In one tab,
labelled "plandata", I have my planning data. In a separate tab, I have
created a User Form. This form uses selected fields from "plandata", or it
will. I want to hide the plandata sheet and display the select fields in my
User Form (frmPlanData) for the users to edit. They will NOT add or delete
any records in the file - Edit only.
I can create the form but can't get it to display the records from the other
sheet.
Help!
Obviously new to forms in Excel.
Thanks.