PART $1$: EXCEL VBA $-$ Working with Strings

$(50$ marks$)$

Each project team $(3-7$ students$)$ is required to create a VBA Excel UserForm object to change

case data atready inserted in your Excel shown below. A Command Button must be inserted in

your spreadsheet as shown below. Four Option Buttons must be added to the UserForm,

rename the options Buttons as specified on the Form. Two command buttons should be added

as well on the UserForm and renamed as shown. The Quit command button when pressed

should be able to close the UserForm, and the OK command Button should be able to change

the Text Case according to the user selection. Be creative and show your research skills.

A UserForm guides you according to your selection, so the first thing you need is a data

range$($Month Of the Year Jan$-$Dec$).$ The figure below shows the sample data set of what you

are expected to do$.$ The workbook must be saved as macro$-$enabled if you are using version

$2016$ or later. Click the File tab $($or Office button$)$ and choose Save As$.$ From the Save As Type

drop$-$down menu, choose Excel Macro$-$Enabled Workbook $(*.$xlsm$)$ to save your workbook as

Project Assignment $($Your Group Name$).$

NB: Whatever option a user is going to select on the User Form should change the Text case in

your spreadsheet data.