What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Excel Help

Excel Help
Author: Message:
Petros
Junior Member
**

Avatar

Posts: 50
Joined: Jan 2003
O.P. Excel Help
im trying to make a quote system for I.T and i want to know if theres anyway to make a automated invoice number changer... like every time i press my reset button the invoice number goes up by one... hellpp
09-10-2004 09:24 AM
Profile E-Mail PM Find Quote Report
CookieRevised
Elite Member
*****

Avatar

Posts: 15517
Reputation: 173
– / Male / Flag
Joined: Jul 2003
Status: Away
RE: Excel Help
You need to write a small macro to do that. (you need to attach al macro anyway to do anything with a button).

So, if your number is in B4, make a macro:

Sub Increment()
  Range("B4").Value = Range("B4").Value + 1
End Sub

Now make a button on your sheed and attach the macro Increment() to it...

This post was edited on 09-10-2004 at 10:17 AM by CookieRevised.
.-= A 'frrrrrrrituurrr' for Wacky =-.
09-10-2004 10:08 AM
Profile PM Find Quote Report
Petros
Junior Member
**

Avatar

Posts: 50
Joined: Jan 2003
O.P. RE: Excel Help
thankz alot :)
09-10-2004 02:51 PM
Profile E-Mail PM Find Quote Report
« Next Oldest Return to Top Next Newest »


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On