Results 1 to 15 of 15

Message box requesting user input if range is NOT empty?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    879

    Message box requesting user input if range is NOT empty?

    Good evening happy campers.

    I have a workbook (attached)
    This records all hours worked in various areas through the business, it relies upon the person in charge of the area for that week to manually enter both the names of all staff, and then the times for each day.
    The same person then needs to go to the first tab (named Sign Offs) and add their name/initials into the box relevant to the area they have just added information to. this way we can keep a record of the hours and who has updated them.

    What i would like is:

    When names AND times are entered into Fridays column (or if the range of fridays column is not empty)
    AND
    When the save button is clicked
    A message/text/user input box (whatever is best) appears that asks for the users name
    Click ok
    The code then saves the name entered into the relevant box on the Sign Offs tab.

    If i didnt explain it clearly please shout and i will re-do the explanation.

    Many, many thanks in advance.
    galvinpaddy
    Attached Files Attached Files

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