Using User input in excel VBA

D

drtracing

I'm supposed to make an invoice of 4 items. Each item needs to have
user input for the description, price, and quantity ordered. Then I
need to calculate the cost of the 4 items. Then calculate the sales tax
at 6%. Then calculate the total cost including sales tax. This needs
to be done using VBA code in excel.
--I'm curious as to how to prompt the user to give me information.
--I'm curious as to how I would use the users input in another cell
once they entered it.
-- I'm curious also as to how VB will know that something is entered
once the user enters something into the desired field.

Thanks for any help you may give me.
drt
 
E

Earl Kiosterud

Drt,

There's a ready-made form for entering data into a table. Your table must
have headings (Description, quantity, etc). It's Data - Form.

Normally, the summing of the costs is done with a formula in a cell, as is
the tax calculation. Does the teacher require you to use VBA???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add one year in second combobox in vba 0
is this possible in excel 2007 3
Input Cell 1
excel formula for markup and profit margin 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
How can sales tax be formulate in a invoice 2
User input in textboxes 2
VBA Data Entry Window 1

Top