Excel Sheet Question

  • Status: Closed
  • Prize: $20
  • Entries Received: 2
  • Winner: ilkecokay

Contest Brief

Open the file named (SecondAsg.XLSX) and perform the following questions


Q1. On excel file create a macro name it (Q1) this macro needs to perform the following operations on relative basis

a. Font name (Courier)
b. Font size (13)
c. Font color Blue
d. Alignment center

Q2. Create a procedure named (Q2) when it runs it types your name in A1, and your Student id in A2 in Sheet1
Q3. Add a button on sheet 1 , when it is clicked it will add new sheets to the current workbook, the procedure name should be (Q3)
Q4. Add a button to sheet 1, when it is clicked it will save the current workbook, The procedure name should be (Q4)

Q6. Write a procedure named Q6, when activated it will search for any value larger than 2000 and it will make its background red, This procedure is activated on Sheet 2 only
Q7.Write a procedure named Q7 , when activated it will make the values in even row number have green background , it should be applied on Sheet3 only
Q8. Write a procedure named Q8, when activated it will take the values found in Sheet 3 and will print them to the immediate window
Q9. Write a procedure named Q9, when activated it will add the value of (VBA is Easy) in Cell G9 for every sheet
Q10. Write a procedure named Q10, when activated it will close excel using Application Object

Note: Do not forget to save the file as .xlsm , otherwise no macros will be attached

Recommended Skills

Employer Feedback

“Very Faast Trustable can teach you how to make the thing work with you step by step He is the best Freelancer ever ”

Profile image Yabedullah, Jordan.

Top entries from this contest

View More Entries

Public Clarification Board

  • ilkecokay
    ilkecokay
    • 1 month ago

    Finished as promised

    • 1 month ago
    1. ilkecokay
      ilkecokay
      • 1 month ago

      https://ibb.co/NmnCRCC

      • 1 month ago
    2. Yabedullah
      Contest Holder
      • 1 month ago

      besssst Freelance ever

      • 1 month ago

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!