Edi
06-22-2011, 12:45 AM
Hi,
It's my first day at using VBA and would be great if someone can help me with the attached spreadsheet. There's a few things I'd like to do:
a) If this is a new test (F2 = "Y") then:
- the duration (H14) = 1 otherwise (ie if F2 = "N") it can be any number from 1-10.
- the start date must be 12 months from the registration date ie H12 = H10 + 12 months, otherwise the registration date (H12) can be any date which is not more than 12 months away from H10
b) I've built in a macro so that if the user toggles with F2, cells F4 and F6 will clear. Is it possible to create a pop up box which warns the user that certain fields will now be cleared?
Thanks for the help!
It's my first day at using VBA and would be great if someone can help me with the attached spreadsheet. There's a few things I'd like to do:
a) If this is a new test (F2 = "Y") then:
- the duration (H14) = 1 otherwise (ie if F2 = "N") it can be any number from 1-10.
- the start date must be 12 months from the registration date ie H12 = H10 + 12 months, otherwise the registration date (H12) can be any date which is not more than 12 months away from H10
b) I've built in a macro so that if the user toggles with F2, cells F4 and F6 will clear. Is it possible to create a pop up box which warns the user that certain fields will now be cleared?
Thanks for the help!