Results 1 to 14 of 14

Copy sent to "History Sheet" everytime the Active X button is pressed.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-28-2013
    Location
    Green Bay, WI
    MS-Off Ver
    Excel 2007
    Posts
    125

    Copy sent to "History Sheet" everytime the Active X button is pressed.

    Hello,

    I am looking for cells B18, C18, and E18 on Sheet 1 to be sent to the History sheet to the first available open row when the Box Count button is pressed. The first available row starts at row 3 and moves down depending on how many entries are already on the page. Any help would be appreciated. I'm not very good with this part of vba coding.


    Thanks


    The code is in module 1 as Sub Boxcount. Here is the code.

    Sub BoxCount()
        Dim Qty1 As Double
            
            Qty1 = ThisWorkbook.Worksheets(1).Range("C18").Value - _
            ThisWorkbook.Worksheets(1).Range("B18").Value
            
        ThisWorkbook.Worksheets(1).Range("C18").Value = Qty1
        
        'Clear cell after subtraction
            ThisWorkbook.Worksheets(1).Range("B18").Value = ""
        'Message Box too order boxes when below 1500
        If ThisWorkbook.Worksheets(1).Range("C18").Value <= 1500 Then
        MsgBox ("Tell Chris to order more boxes")
        End If
    End Sub
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to copy "command button" to another sheet
    By norika in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-31-2015, 01:47 PM
  2. [SOLVED] Copy range from hidden sheet to active sheet if cell ="Some text"
    By pjbassdc in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 01:19 AM
  3. Button that makes the "Find and Replace" popup come up when pressed.
    By fred80213 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-12-2013, 01:54 PM
  4. [SOLVED] Macro to look up and down from the active cell, copying the active "section" of the sheet
    By mikkola in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-12-2013, 07:21 PM
  5. Locked sheet, Button to remove or "copy add" specified columns
    By ballex in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-23-2012, 08:58 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