+ Reply to Thread
Results 1 to 2 of 2

Locking Date

  1. #1
    Registered User
    Join Date
    05-20-2005
    Posts
    22

    Locking Date

    I have a spreadsheet were I need to enter a shipping date every time I scan a shipping label.

    What I would like to do is when I scan the shipping label, the column date would fill the date automatically and would not change the next day. I know I can use “if” statement with “=today() but the problem is that the data would change everyday.

    Any suggestion?

    Thank you.

    Juran

  2. #2
    Forum Contributor
    Join Date
    05-14-2006
    Posts
    104

    Date fix

    Could write a macro similar to the if... that you can write

    e.g


    Sub test()
    If ActiveCell = "" Then
    Else
    ActiveCell.Offset(0, 1) = Date
    End If
    End Sub

    nb:
    activecell = selected cell so you would have to scan in product then select cell with the new barcode in it - chances are it already does this
    activecell.offset(0,1) = euals the 0 is the row it is out e.g put a 2 there and the selected cell will drop 2 rows. and the 1 represents the cloumn so it will be the column right next to the selected cell
    Date in VBA means it will stamp the date into that cell

    so scan barcode = select cell run macro - doing this many times u may want to set a button up reply if you need help with that

+ 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