none
Idea of a mini Project in Excel VBA RRS feed

  • Question

  • Do you guys have any good idea about what kind if mini project in excel vba that I can start creating for a student.

    Thanks! 
    Tuesday, February 16, 2016 3:03 PM

Answers

  • Sakura,

    Sorry but you have posted to a forum that deals exclusively with customization and programming of Microsoft Project, a project management application. I suggest you try the following Excel forum:

    https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

    That being said, I think a good "starter" VBA exercise for Excel might be to have the students develop a macro to format a worksheet (i.e. column headers and column widths), and then loop through a simple lookup table to populate cells using the Range object. The next step might be to create a graph of the data in the cells. The important point is to learn how the basic parts of a good VBA procedure (e.g. variable declaration, processing flow, loops, etc.) and then use that structure to perform a function that is not already available in the application, in this case, Excel.

    Hope this helps.

    John

    Tuesday, February 16, 2016 3:37 PM

All replies

  • Hi Sakura,

    I don't know if this will satisfy the requirement, but check out the following website :

    http://www.makeuseof.com/tag/excel-project-management-tracking-templates/

    Also, if you are looking for something else, please let us know.

    Thanks,

    A

    Tuesday, February 16, 2016 3:29 PM
  • Sakura,

    Sorry but you have posted to a forum that deals exclusively with customization and programming of Microsoft Project, a project management application. I suggest you try the following Excel forum:

    https://social.msdn.microsoft.com/Forums/office/en-US/home?forum=exceldev

    That being said, I think a good "starter" VBA exercise for Excel might be to have the students develop a macro to format a worksheet (i.e. column headers and column widths), and then loop through a simple lookup table to populate cells using the Range object. The next step might be to create a graph of the data in the cells. The important point is to learn how the basic parts of a good VBA procedure (e.g. variable declaration, processing flow, loops, etc.) and then use that structure to perform a function that is not already available in the application, in this case, Excel.

    Hope this helps.

    John

    Tuesday, February 16, 2016 3:37 PM