Results 1 to 8 of 8

Limiting Input Box Selections

Threaded View

CJPHX Limiting Input Box Selections 07-21-2010, 03:33 PM
davegugg Re: Limiting Input Box... 07-21-2010, 03:52 PM
CJPHX Re: Limiting Input Box... 07-21-2010, 04:59 PM
davegugg Re: Limiting Input Box... 07-21-2010, 05:10 PM
CJPHX Re: Limiting Input Box... 07-21-2010, 05:14 PM
davegugg Re: Limiting Input Box... 07-21-2010, 05:16 PM
CJPHX Re: Limiting Input Box... 07-21-2010, 05:27 PM
davegugg Re: Limiting Input Box... 07-21-2010, 05:30 PM
  1. #1
    Forum Contributor
    Join Date
    05-19-2010
    Location
    Phoenix, AZ
    MS-Off Ver
    Excel 2003
    Posts
    107

    Limiting Input Box Selections

    I currently have an input box that asks for a user to enter their intials. Is there a way to make sure that the initials they entered are of a valid user. I only have about 6 people that use this. I would like it to check their input against the list and then if its not right make them enter them again.

    Sender = InputBox("Please Enter Your initials:")
    Example: CJH, PHT, FXH, TOM

    If the entry is not one of those then I would like it to ask them to input again.

    Once the input is made it outputs to a log sheet for me.

    Windows("RCSN Log.xls").Activate
    Sheets("Log").Select
    ActiveSheet.Cells(ActiveSheet.Cells(Rows.Count, "A").End(xlUp).Row + 1, "A").Value = Sender
    ActiveSheet.Cells(ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row + 1, "B").Value = SendDate
    ActiveSheet.Cells(ActiveSheet.Cells(Rows.Count, "C").End(xlUp).Row + 1, "C").Value = SendTime
    I would then like a yes/no input box that asks them a question. If they enter yes I would like it to output to the log. If they enter no I want it to just continue on with the rest of the macro.
    Last edited by CJPHX; 07-21-2010 at 05:38 PM.

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