Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / June 2007

Tip: Looking for answers? Try searching our database.

Onclick? Help  Auto Add

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Adam Bannister - 27 Jun 2007 07:27 GMT
I need make a excel so that when i click a
Button it will Add 1 to B3 etc
So each time we sell a product we can just press + or - to add and remove a
figure from that field
MartinW - 27 Jun 2007 10:48 GMT
Hi Adam,

You can use a spinner to do that.
Go to View>Toolbars>Forms
On the forms toolbar select the spinner (it's an up and down broad arrow
separated by a dash)
Your cursor will now be a small cross, just click and drag where you want
the button.
Right click on the button and goto Format Control where you can set
the cell link ($B$3 in your case), you can also set the incremental value as
well as many other parameters.
To adjust the size and location of your button you need to right click
on it and ignore the flyout menu, just click on the handles and drag it
around as you want.

HTH
Martin

>I need make a excel so that when i click a
> Button it will Add 1 to B3 etc
> So each time we sell a product we can just press + or - to add and remove
> a figure from that field
Dave Peterson - 27 Jun 2007 12:24 GMT
I put a button from the Forms toolbar (not control toolbox toolbar) on the
worksheet and assigned it this macro:

Option Explicit
Sub testme()
   With ActiveSheet
       With .Range("B3")
           If IsNumeric(.Value) Then
               .Value = .Value + 1
           Else
               Beep
           End If
       End With
   End With
End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

> I need make a excel so that when i click a
> Button it will Add 1 to B3 etc
> So each time we sell a product we can just press + or - to add and remove a
> figure from that field

Signature

Dave Peterson


Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.