can a User Form reference several sheets?
I need to write a User Form that has several combo boxes/list boxes whose
values are located on another spreadsheet. How do I reference the ranges from
those other sheets?
I have a sheet named "Dashboard" that contains the User Form. The data that
populates the controls on the form is located in the sheet named "Lists".
Any help would be appreciated.
Adam
|