Program a simple Excel 2010 VBA application and a custom function


- 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)


- 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

Evner: 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:


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 Flere

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

10 freelancere byder i gennemsnit $30 på dette job


A proposal has not yet been provided

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

Hello :) I am an VB / Excel Expert. If you see my reviews by navigating to this link http://www.freelancer.com/users/feedback_1193882.html?period=entire_history&category=0 then you will notice that I have not Flere

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

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 Flere

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

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 Flere

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

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 Flere

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

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)

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)

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)

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 Flere

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