The workbook must be macro-enabled if you are using version 2016 or later. Figure below shows the sample data set of what you are expected to do. A Userform guides data entry, so the first thing you need is a data range. The more different controls you have added the more chances of scoring marks. Group members are to decide on which controls to be added on their userform. Design your Userform as attractive as possible. First insert a Command Button to your worksheet and use a Command Button to call the Userform that you have created. Transcribed image text: PART 1 - EXCEL VBA (40 marks) Each project team (2-5 students) is required to create a VBA Excel UserForm object to aid data entry in Excel, add different controls to it, and then use Visual Basic for Applications (VBA) to link the controls to a worksheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |