Posts by jaylotheman

    Hey all, so basically I need help with a VBA code that can do the following.


    If you have a certain cell selected, it will format the next 5 cells including the cell selected a certain colour/format.


    How can I do this, ideas?


    Thanks!


    Possible e.g.


    Code
    Range(CurrentPosition, Range(CurrentPosition).offset(0, 4).Colorindex


    I dunno?

    For whatever reason I've been assigned to another task for taking an Excel Spreadsheet and creating an application for mortgages. I only have a very basic understanding of VBA but need to do the following which I believe to be done best utilizing a web query, a user form and output form:

    Must create an application that will allow a user to download the purchase price, legal fees, property taxes, and mortgage insurance homes (using this website: http://zakhomes.blogspot.com/).


    Must also allow a user to calculate the total price and mortgage payments for the purchase of the home they choose.
    (This is a Canadian application. The monthly mortgage payment must be based on the full house price including legal fees, property taxes (monthly) and monthly mortgage insurance costs based on the data on the web page plus GST and less any down payment.)


    The user must also be able to enter in the terms of the mortgage.


    Afterward the application must report to the user on a screen the housing details along with the total cost (with a breakdown of costs), the monthly mortgage payment, and the total of all their payments (with a breakdown of principle and interest amounts) along with all the financing terms.


    Finally the user must have the option of printing the report in a formatted Word document.


    Make sense?

    Can someone help me with the code to do this? Any help would be appreciated thanks.

    Re: VBA Multidimensional Array Help


    Hey thanks for the response, that looks like what I'd need!


    Any chance I could see the code to help teach myself? The workbook had no code in the VBA editor.


    Let me know, thanks again.

    For whatever reason I've been assigned to this task for taking an Excel Spreadsheet with two columns of values (please see attached file). I only have a very basic understanding of VBA but need to do the following which I believe to be done best via a dynamic multidimensional array:


    Create an application routine that allows a user to merge the asset data the separate restaurant companies, rename the newly formed company and add it to the list (via a userform).


    In addition, the merged restaurant companies must be removed from the list.


    Ideally the resulting list will be sorted alphabetically once the merger is completed.


    So basically, For e.g. (not in spreadsheet)


    Column A Column B
    Harveys 400
    BK 500
    Wendy's 600


    If I want to create a dynamic multi-dimensional array that merged all of A so that I could create a "super-entity" so combine A1-A3 and be able to create a new name for it so "Super Wendy-BK-Harvey's" and at the same time it auto-sums values B1-B3 so it creates



    Column A Column B
    Super Wendy-BK-Harvey's 1500


    Make sense?


    Can someone help me with the code to do this? Any help would be appreciated thanks.