Cancelado

Excel Macro Code Assignment Help-ASAP

I simply need help on a study guide question. Please let me know as soon as possible. Question is as follows...

11. You want to create a scroll bar in Cell C3, which will allow the user to select a car loan amount ranging from $5,000 to $60,000. When you click on one of the arrows at either end of the scroll bar, you want the dollar amount to change by $100 increments. When you click between the arrows, you want the dollar amount to change by $1000 increments. The loan amount selected using the scroll bar should be displayed in Cell B3.

A B C

1 Car Loan Payment Calculator

2

3 Loan Amount $25,000

4 Loan Term (in years) 5

6 Annual Interest Rate [url removed, login to view]%

8

9 Monthly Payment ($[url removed, login to view])

10

What properties need to be changed in order to create this scroll bar, and what should these properties be set at?

Now assume you want to create a spin button in Cell C4 to allow the user to click on the arrows to change the loan term in Cell B4. The user should not be allowed to enter anything less than one or greater than 5 for the loan term. What properties need to be changed in order to create this spin button, and what should these properties be set at?

Habilidades: Codeigniter, Processamento de Dados, Excel, Microsoft

Ver mais: less excel, excel less, need help excel, excel calculator, b3, car excel data, annual rate excel, entry data loan, monthly car loan, loan monthly payment, excel create macro, macro data entry, interest monthly payment, car monthly, car payment calculator, monthly loan payment, data entry loan, click macro, create excel loan calculator, monthly car payment, car loan data, code car loan payment, car calculator, data car loan, code excel macro

Acerca do Empregador:
( 31 comentários ) columbia, United States

ID do Projeto: #6823313

3 freelancers estão ofertando em média $30 para este trabalho

abdellatif81

Aucune proposition n'a encore été fournie.

$45 USD em 1 dia
(10 Comentários)
4.9
shuvo2alam

Thank you for this wonderful opportunity. Today Your job posting has caught my attention because Iâ??m keenly considering your job post including these skills. I have excellent experience in Microsoft Office and Admin Mais

$25 USD em 1 dia
(0 Comentários)
0.0
metalogics3

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Mais

$25 USD em 1 dia
(0 Comentários)
0.0
igotmail9

Dear Sponsor, I am a hard core developer with 14 years of experience in software development with Java (3Y), C++ (10Y), C#(3Y), Visual Basic, Excel, VBA programming, Web programming, HTML5, PHP, MySQL, Linux and Win Mais

$20 USD in 0 dias
(0 Comentários)
0.0