Enhancement of xls RoI calculator with VBA

  • Posted
  • Proposals 1
  • Remote
  • #3901
  • Expired
James B. has already sent a proposal.
  • 0

Description

Experience Level: Intermediate
The project entails the enhancement of a .xls file as follows:

1. Use of macros (VBA) for two things:

a. to show / hide the relevant cells if the input is Y / N, e.g in worksheet called %u2018Initial #%u2019s%u2019 if a user chooses %u2018N%u2019 in cell D12 then cells E12 and F12 should not appear and F12 should take value of zero.

b. to disregard relevant data if a %u2018NO%u2019 is selected, e.g. if user chooses NO>> in worksheet %u20182nd semester%u2019 (cell E14) then values in worksheet %u20182nd semester_1%u2019 should be disregarded (taking zero value) in calculations.

2. Not allowing users to jump from one worksheet to another by clicking on the tabs below, but only by following the relevant Next / Back buttons and always start file with the worksheet called %u2018Start%u2019

3. Validating the cells on those that require user input %u2013 while this has been done already for most of the cells, those that require input of as %%u2019s still require validation, e.g. cells D6 and E6 in worksheet called %u20181st semester%u2019


Notes:
1. The individual worksheets and the file are password protected.
2. The worksheet with the calculations has been hidden. This should not require any modifications.
3. For any questions about the scope of the project and/or to get the password to unlock the worksheets please email me

Clarification Board

    There are no clarification messages.