EXCEL VBA
-
hi, i had a problem in VBA, and i really hope you guys is able to help mi. i'm creating a simple system using VBA in excel, therefore i'm using the sheets as my DB. how am i suppose to call the things i wan. 2nd question how am i suppose to link the data list or list box with the sheets. Thanks really hope to hear from you guys thanks Best Regards Veon cheng
-
hi, i had a problem in VBA, and i really hope you guys is able to help mi. i'm creating a simple system using VBA in excel, therefore i'm using the sheets as my DB. how am i suppose to call the things i wan. 2nd question how am i suppose to link the data list or list box with the sheets. Thanks really hope to hear from you guys thanks Best Regards Veon cheng
veon cheng wrote:
how am i suppose to call the things i wan.
I see you meant to type 'want', and that's cool. We all make typos. But, I still can't work out what on earth you may be asking for. I don't do VBA, but I doubt anyone who did, could answer you either, for this reason. Perhaps you need to explain more.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
-
veon cheng wrote:
how am i suppose to call the things i wan.
I see you meant to type 'want', and that's cool. We all make typos. But, I still can't work out what on earth you may be asking for. I don't do VBA, but I doubt anyone who did, could answer you either, for this reason. Perhaps you need to explain more.
Christian Graus Driven to the arms of OSX by Vista. Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
hi sorry about the "wan" thingy. hmm ok i'm creating a form in excel where the form is able to let the user to select the start date and end date of the report to be generated. therefore i need to know the code that is able to call the data from an excel sheet to get the figure as well as items in the excel sheet. where i want to use the excel sheet as a DB. how? thanks Veon
-
hi sorry about the "wan" thingy. hmm ok i'm creating a form in excel where the form is able to let the user to select the start date and end date of the report to be generated. therefore i need to know the code that is able to call the data from an excel sheet to get the figure as well as items in the excel sheet. where i want to use the excel sheet as a DB. how? thanks Veon
there are objects that allow you to look at the various sheets and reference them by name etc. One of the best things to do, is record a macro and perform a number of operations e.g. move around sheets, changing values in cells etc. Then look at the code that is recorded. The object browser will also help you identify the various objects and methods that can be called.