Could do with a bit of help please.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

wwfc_barmy_army - 29 Oct 2004 22:23 GMT

Ok, well, i have been set the task of making an invoice system that eve
a noob could use. The invoice system is for a chemist.

At the moment i have my main menu, a button on there links to custome
details. Where the input box comes up like on the picture below, i mad
that come up with macros etc.

http://www.ashu56.dsl.pipex.com/Peter/excelchemist.png

What we have been asked to do also if to make it so the customer numbe
is automatically put in each time an 'entry' is put in (so they don'
have to put it in). I have no idea how to do this?

Can anyone help?

Cheers.

Pete

Reply to this Message

JulieD - 30 Oct 2004 14:40 GMT

Hi

as far as i can see, to achive what you're after you'll need to create your
own VBA form rather than using the Form from the Data menu.

You could possibly do it without using the data form and use another
worksheet set up as the input sheet with data / validation used to provide a
list of current customers and VLOOKUP to populate the form with related
data - i have an example invoicing workbook set up like this (with an
example of a VBA user form in it as well) - if you'ld like to email me
direct (julied_ng at hcts dot net dot au) i can send it to you.

Cheers
JulieD

> Ok, well, i have been set the task of making an invoice system that even
> a noob could use. The invoice system is for a chemist.
[quoted text clipped - 14 lines]
>
> Pete.

Reply to this Message