I have an excel file with a sheet called bookings and a form call frmBookings.
The form is used to capture bookings for people and the resultant records are added to the "bookings" sheet.
I have already set up a named range for the people in the table as well as a Dynamic range name using the worksheet change event.
What I am wanting to do is populate the List Box on the form with the distinct names of the people stored in the table (sheet bookings).
I need this to occur each time the user opens the form or adds a record.
Can someone please help as I am stuck with it.
Just to clarify please.
What is CompName = UNIQUE(.Range("a1").Curren
Where is Current Region in the range names? Do I need to create this? If so, please specify.