im having my final project. My program is all about retrieve data from Excel Worksheet then show/calculate it in VB6.
The problem im having here is i keep getting compile error "Procedure too large". I understand that VB6 procedure max is 64k and to make it small is by using Sub or Function modular.
The big problem is.. i have no idea how to create one. I did quite few research but still dont get it.
Does anyone have any idea how overcome my problem? Thank you in advance in helping this newbie
i've uploaded the code where got this compile error