Populating drop down list from another drop down list in Excel
Posted on 2003-02-25
I made this Excel batch/application that is making a dynamic form from an external Oracle database and since it takes a long time to run, I have to minimise the operations and querys made by my application. Since the form is making a lot of drop down lists that are exactly the same, I thought that copying these from one another would be faster that going through SQL to populate each and every similar drop down objects.
Public Function Copy_List(ByVal as_ObjectName, as_SourceName as String) As Integer
CopyList = 1
On Error GoTo MyErrHandler
// Copy from the Source_D_D_L to the Other_D_D_L
MsgBox ("Error Copy_List: " & Err.Number _
& " " & Err.Description _
& " " & Err.Source)
CopyList = -1
Thanks 4 help !