Cancelado

Write simple Excel VBA -- 2

Required Functionality:

1. A User Form that allows the details of a Property to be added, modified and deleted. This form should allow the user to cancel, and also allow user to confirm before the details are changed to the “Property” worksheet. If it’s a new listed property, then the details should be added below any existing properties. You should set up your worksheet to contain some sample data, and assume that this data is already there before this form is used.

Note: The Property ID is generated automatically by the system and increments by 1 each time.

2. A User Form that allows user to select from a range of criteria (suburb, bedrooms etc.) and display all the available listed properties for lease. Name this worksheet as “Listed Properties” (you may pre-created this worksheet). A button on the worksheet for user to print preview this worksheet. The worksheet must display the following details:

• Property ID, Date listed, Bedrooms, Bathrooms, Address, Type, Weekly rental fee.

3. A User Form (‘New Lease’ ) that allows the details of a new lease to be entered:

i. Once the New Lease form is opened, a new worksheet (named as “Lease Temp”) should automatically be created to temporarily hold details of the lease.

ii. The form should display an auto-generated Lease Code (in chronological order) when the form is opened; a list of tenants and a list of properties from which to select. Other necessary information to be entered by user can be checked from the Lease History sheet.

iii. The form should also display the security deposit (which is equivalent to at least one month’s rental fee) plus GST (10%) amount which should be included as a separated field on the form.

iv. The form should contain an ‘Accept’ button which will add the details of each lease to the lease (“Lease Temp”) list created in step 1. Please note that it is possible to rent more than one property by the same tenant because the tenant may also rent one for his/her family.

v. The form should allow the user to cancel and return to the previous form. The temporary worksheet “Lease Temp” will also be deleted.

vi. The form should include a ‘Transfer’ button which transfers the details of the new lease(s) from the temporary lease sheet to the Lease History sheet, updates the status of the property in the Property sheet, and then deletes the temporary sheet and returns to the main menu form.

Note: Each newly lease will have a unique lease code.

4. A User Form named ‘Generate Owner Monthly Statement’, which allows the user to input the rental start date, and creates monthly statements for the rental period. The information should be obtained from the Owner, Property and Lease History worksheets.

The required information is as follows:

Owners’ Statement Worksheet

Each sheet presents the details of the income and expenses made from the rental period. For instance, if the user enters 2/8/2016, then three statements (for L1003, L1004 & L1006) will be generated (based on the given data set in the Lease History sheet). The information to be shown on the statement worksheet is given below:

• Rental start and end period for the statement (e.g. 2/8/2016 to 1/9/2016)

• Date in which the Owner’s Statement was created

• Owner’s details (Owner Code, Owner Name, and Address etc.)

• Rental property address

• Commission Amount for the period

• GST which is 10% of the Commission Amount

• Lease Amount for the period

• A button for user to print statements to a pdf file

Other requirements:

• You must make use of decision structures and repetition structures.

• You must include data validation to ensure the user only enters valid information, and report meaningful error messages if they don't.

• You should use appropriate indentation of your code so that it is easily readable

• You should include appropriate documentation in your code

Habilidades: Excel, Visual Basic para aplicaciones

Ver más: vba excel simple, excel vba rank function write, vba excel write xml file, vba excel simple dial, simple vba excel scripts, write xml vba excel, simple optimization algorithm vba excel, vba excel write data xml file, access vba excel task manager simple, vba excel write unicode text, vba excel creating simple form, write vba excel 2007, vba excel write file, search excel vba csv simple database, vba excel write xml

Información del empleador:
( 0 comentarios ) Australia

ID de proyecto: #11753273

17 los freelancers están ofertando un promedio de $246 para este trabajo.

$400 AUD en 3 días
(252 comentarios)
7.6
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$250 AUD en 3 días
(182 comentarios)
6.7
paris2785

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Más

$250 AUD en 7 días
(113 comentarios)
6.4
ZeusMan

Hello, I’ve carefully gone through your job posting Write simple Excel VBA -- 2. I'm an expert in Advanced Excel VBA programming techniques. I am very much interested in your project with all of your requirements. Más

$222 AUD en 3 días
(73 comentarios)
5.9
zebracaro

i can do it for you quickly and exactly

$250 AUD en 4 días
(73 comentarios)
5.7
royalcalif

Hi Mr. Employer I have lot of experience in excel spreadsheet and I can do this project in effective manner with 100% accuracy report to your requirements. See Below video as my earlier work with Excel . https://yout Más

$225 AUD en 9 días
(32 comentarios)
4.6
vsprybhanu

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in exchanging data between sheets, advance formulas, critical programming, developing system for management and creating reports. I have read your ins Más

$555 AUD en 10 días
(44 comentarios)
4.7
$250 AUD en 4 días
(8 comentarios)
5.2
wiisetech

Hi, I can make the VBA you required. I am an excel expert and I can write code for it. I had done the same work recently. Ready to do start it right now. Let's discuss about it. Regards.

$222 AUD en 4 días
(8 comentarios)
3.1
SergeyKyiv

Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA. Any code I provide is well structured and commented, client gets whole access and rights for th Más

$250 AUD en 7 días
(5 comentarios)
3.1
$155 AUD en 3 días
(1 comentario)
2.4
fixen2011

Hi Sir, I am a professional Software Engineer with 4 years experience. I have the advantage among others who can make a clean code that is readable and could provide excellent documentation for easy maintainance and e Más

$200 AUD en 10 días
(7 comentarios)
2.5
$100 AUD en 5 días
(4 comentarios)
2.1
marcosarocha

Hi, I have a great experience in Excel and macros development and i am a fast typist. I constructed my experience working at Yamaha do Brasil and DuPont do Brasil for 8 years, where i performed many gerencial report Más

$222 AUD en 10 días
(0 comentarios)
0.0
serxanbayramli

Hi, In my last job I developed an MS Access application that managed student subscriptions. payments, enrollment and etc. using VBA and SQL. I also have experience with developing interactive Excel spreadsheets. I b Más

$250 AUD en 3 días
(0 comentarios)
0.0
lilyjapar04

Hi, Your project is very interesting and I want to work on your project. please tell me if you are interested in my work on your project. Thanks Lily

$222 AUD en 4 días
(0 comentarios)
0.0
$155 AUD en 3 días
(0 comentarios)
0.0