+ Reply to Thread
Results 1 to 4 of 4

VB button to add "1"s

  1. #1
    Registered User
    Join Date
    11-18-2012
    Location
    Ireland
    MS-Off Ver
    Excel 2011
    Posts
    54

    Wink VB button to add "1"s

    Hi, I simply now little of VBA for excel... thus would it be possible to create a button; when pressed adds the digit "1" to a cell (pressed again add another 1, 2 appears in cell). is this a simple thing to code or setup! thanks for replys...

  2. #2
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: VB button to add "1"s

    hi,

    try this: PlusOne.xlsm

    contains:
    Please Login or Register  to view this content.
    Mark this thread SOLVED and click the star if this answer solves your problem.

    Regards
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

  3. #3
    Valued Forum Contributor WasWodge's Avatar
    Join Date
    08-02-2010
    Location
    Hampshire,England
    MS-Off Ver
    Office 365 and Office 2010
    Posts
    883

    Re: VB button to add "1"s

    Try
    Please Login or Register  to view this content.
    Change sheetname / range to suit
    Attached Files Attached Files
    Last edited by WasWodge; 04-20-2013 at 04:16 PM.
    If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved

    Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown

  4. #4
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: VB button to add "1"s

    Hi Stews,

    Like the attached, perhaps?

    Also see the "Please consider" note at the bottom of this post.
    Attached Files Attached Files
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1