Initialize Sub routine

Hot Topic

Running script
How can I store a merge field value as document metadata?
read line from table cell for vba in ms word
How to pop data from a table in MS Access 2003?
vba array?
Trying to create Data Acess Pages to manipulate recordsets.
How to use data from inputbox
To find Whether a value in a cell is pasted?
Searching / Hilighting OCR text in Office Document and Imaging
datagrid control in access

Microsoft ISV

what is wrong with this formula? *9 Views & no one knows?*
Hybrid between Cells.Select and ActiveCell.CurrentRegion?
Attempted to read or write protected memory. This is often an indication that other memory is corrupt
vlookup
Merry Christmas and Happy New Year
VBA Module to DLL
Countdown / Automatic Recalc ?
Automation Error During Execution of Stored Procedure Using ADO
Protecting formulas in cells
Using Proper function to Format Worksheet

Initialize Sub routine

Hi there,

I'm new to VBA. I created have class module in VBA project. To my understanding, Initialize() routine acts as Constructor. I need to have to Initialize method with different signature. It's giving an error having 2 Intialize sub even with different signature. How do I implement it in VBA

Thanks,

SARAVANt




Answer this question

Initialize Sub routine

  • wirwin

    Hi, Sara2006,

    Unfortunately VBA does not allow method overloading. You cannot have two methods with the same name with two different signatures. Your alternative is to pass a value to the initialise statement that you use to determine which code in initialising your class module. VBA is not an object orientated programming language.



  • Initialize Sub routine
Answer this question