I gang

Program a simple Excel 2010 VBA application and a custom function

Mandate:

- Program a simple Excel 2010 VBA application

- Create a custom fonction (using the same code)

Application Description:

- Select a value form a Drop down menu (Cell B2 on Exemple Tab)

- Enter values in a pop-up windows (1, 2 or 3 values depending on B2 choice)

- Get result in a cell (Cell B24 on Exemple Tab)

Formula Description

- The formula do the same calculation as the application, however it bypass the drop down menu and the pop-up window

- Formula will be Formula(Choice,ValueA, ValueB, ValueC)

Instructions

- Code should be well documented and well structured and no password protect

- The Example tab is a prototype. The program and function should give the same result as the prototype

- Cells highlighted in green are for the input and output example

- Cells highlighted in yellow are to show which values are used based on the input (B2) and the Lookup table (L1:Q6)

- Use the "Application" tab for the application interface

- The total should be formated (ex: cell B18:B22).

Equation B1 - 4 decimals

Equation B2 - 3 decimals

Equation B3 - 2 decimals

Equation B4 - 1 decimal

Equation B5 - no decimals

- Use the attached spreadsheet

Færdigheder: Excel, Visual Basic

Se mere: tab prototype, simple prototype, excel to application, excel spreadsheet formula, simple excel, pop-up formula, excel to vba, excel password, excel ex, excel calculation, Excel and VBA, create a simple program, B3, excel formula spreadsheet spreadsheet, custom formula, spreadsheet vba code, excel create input output, windows vba, program protect, application description, application vba, vba function, excel input interface, custom value calculation, excel excel 2010

Om arbejdsgiveren:
( 16 bedømmelser ) Boucherville, Canada

Projekt-ID: #6008950

Tildelt til:

williammatheson

Hello, I am an Engineer from Nova Scotia, Canada. I work for a large Engineering/Project Management company. I am relatively new to Freelancer, but I've programmed countless VBA projects for my employer; budgeting Mere

$35 USD på 1 dag
(4 bedømmelser)
3.7

10 freelancers are bidding on average $30 for this job

zExcel

A proposal has not yet been provided

$40 USD på 1 dag
(82 bedømmelser)
6.2
koolsidz

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link [url removed, login to view] then you will notice that I have not Mere

$35 USD på 1 dag
(127 bedømmelser)
6.1
finecodervw

Hi, Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc.. I have more than 10 years of experience to my credit. I fully understand on this highly competetive Mere

$30 USD på 1 dag
(73 bedømmelser)
5.7
avinav606lx

Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality ou Mere

$34 USD på 1 dag
(40 bedømmelser)
5.1
ethicalboy

Hello ready to start asap to deliver you, I worked with different types of numbers and data,functions and macros, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel and vba exp Mere

$27 USD på 1 dag
(40 bedømmelser)
4.8
tomislav1975

Yes I can, and I will help you if you pick me for your project. Check my profile, see my reviews and award me now. Thanks, Tom

$40 USD in 2 dage
(11 bedømmelser)
4.1
danielrinf

Hello. It is a very simple job. Do not let that fake freelances fool you. I give it to you in 2 hours.

$25 USD på 1 dag
(3 bedømmelser)
2.7
aticul

Hi, Thanks for your project. I can take 100% confidently your project. I will make you fully satisfy by my work.

$10 USD på 1 dag
(4 bedømmelser)
1.0
pendaflex

Seems like you have got a good code already, but I understand the purposed "application" would condense the amount information displayed. Relatively simple, and I can do it to be error-resistant. I realize I have n Mere

$25 USD på 1 dag
(0 bedømmelser)
0.0