Results 1 to 10 of 10

Clicking the command button more than twice

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-10-2014
    Location
    Alberta
    MS-Off Ver
    2016
    Posts
    128

    Clicking the command button more than twice

    Hello,

    I have a command button (titled "Out1") and when clicked it enters "1" into cell H6. I am wanting users to be able to click the command button again and then enter "1" into cell I6. and then a third time to put "1" into I6. Can this be done?

    Here is my code for this:
    Private Sub Out1_Click()
    
    Range("H6").FormulaR1C1 = "1"
    
    End Sub
    Or, perhaps this may be easier if the command button was set to place a "1" to the right a column every subsequent time it was pushed. Is it even possible to push the command button more than once?
    Last edited by Templemind; 09-06-2014 at 08:05 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] remove database by command instead of clicking delete button
    By dharmang1910 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-30-2013, 01:19 PM
  2. Reset Value in cells to 0 after clicking the command button
    By STU22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-27-2012, 11:47 AM
  3. Exiting a cell when clicking on a command button
    By jcl20 in forum Excel General
    Replies: 1
    Last Post: 07-06-2008, 10:32 AM
  4. Changing cells color without clicking command button
    By grumpyguppy in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-19-2008, 03:22 AM
  5. Double Clicking a Command Button
    By NewExcelUser in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-09-2007, 01:37 AM

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