P
Patrick Simonds
I have 2 open workbooks Able and Baker
In WorkBook Able I call a Userform which has a ListBox. The ControlSource
for the ListBox is a range located on WorkBook Baker. The ListBox shows a
list of employees and their department. I want a sort button on my UserForm
which will run a sort routine on the workbook Baker which has the employee
data.
I have the Sort routines defined on WorkBook Baker :
Module1.SortByName
Module1.SortByDepartment
But how do I run the sort module on WorkBook Baker without leaving WorkBook
Able?
In WorkBook Able I call a Userform which has a ListBox. The ControlSource
for the ListBox is a range located on WorkBook Baker. The ListBox shows a
list of employees and their department. I want a sort button on my UserForm
which will run a sort routine on the workbook Baker which has the employee
data.
I have the Sort routines defined on WorkBook Baker :
Module1.SortByName
Module1.SortByDepartment
But how do I run the sort module on WorkBook Baker without leaving WorkBook
Able?