VB Macro

  • Thread starter Thread starter Heather C
  • Start date Start date
H

Heather C

I need some help writing a macro in visual basic. I'm tring to give an
invoice number to each new invoice. I don't want it to do it every time I
open the program though, I would like it to be done when I enter the customer
number into the field. I'm not quite sure how to do this.

Please Help!!
 
You may want to review JE McGimpsey's notes:
http://mcgimpsey.com/excel/udfs/sequentialnums.html

Personally, I wouldn't use the changing of a cell to grab a new number. I'd put
a button from the forms toolbar on the worksheet and force the user to click the
button when they wanted it.

Anything else would seem too much like magic <vbg>.
 
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

excel macro 1
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
template creates invoice - how to create summary worksheet? 13
How do I write to a closed work book as a "register" 1
Data Validation to exclude blank cells 6
macro for inserting one row between different data 2
Create an Invoice from a row of data 2
Excel 2000 questions 1

Back
Top