Results 1 to 8 of 8

Change Date when one of 4 fields = string

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2020
    Location
    Kentucky
    MS-Off Ver
    2016
    Posts
    24

    Change Date when one of 4 fields = string

    so what im doing is setting a date with time in a cell. based on 4 other columns.
    Columns A are the options column b are what they mean.
    Column C is where time gets put
    Column D thru G are data validation fields where you can pick options from column A

    options fields
    A                      B                   C(Time)          D           E              F               G
    accept             Accept                 time          
    Refuse             Refuse                time
    Called accept    Accept                time
    called refuse     refuse                time
    no answer                               No time
    time off                                  no time
    im using Private Sub Worksheet_Change(ByVal Target As Range) to get this to update.

    Ex. lets say D and E = refuse and which is fine it gets time Now in C the way i want. but column F is time off it changes the time. i dont want this i want it to do nothing if B answers are blank[table="width: 500"]


    c
    Last edited by mthroesch; 11-08-2020 at 11:44 AM. Reason: Attaching File

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to change text dates into usable date fields
    By ammartino44 in forum Excel General
    Replies: 4
    Last Post: 09-06-2020, 08:42 PM
  2. Replies: 5
    Last Post: 07-23-2019, 07:18 AM
  3. Replies: 27
    Last Post: 03-29-2019, 10:47 PM
  4. Change written date (Day, day month time timezone) to date string
    By ABBOV in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-08-2017, 05:08 AM
  5. change a rows colour if the todays date is 1 month from the dates in the fields
    By andrewd94 in forum Outlook Formatting & Functions
    Replies: 1
    Last Post: 09-17-2013, 07:41 PM
  6. [SOLVED] Macro to deconstruct and change date string needed
    By Aceso in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2013, 12:41 PM
  7. [SOLVED] Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS!
    By PSSSD in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-08-2006, 04:35 PM

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