Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
The remote procedure call failed. (Exception from HRESULT: 0x80070 | Excel Worksheet Functions | |||
Remote module call | Excel Programming | |||
Call a Module | Excel Programming | |||
Call other sub in the same module | Excel Programming | |||
remote module | Excel Programming |