Using User input in excel VBA

  • Thread starter Thread starter drtracing
  • Start date Start date
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
 
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???
 
You must log in or register to reply here.

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

template creates invoice - how to create summary worksheet? 13
is this possible in excel 2007 3
Add one year in second combobox in vba 0
User input in textboxes 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
printing different numbers of rows of results depending on user in 1
Forcing User inputs 1
Creating a sales invoice 2

Back
Top