Results 1 to 6 of 6

Find input box value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    Find input box value

    Hi all

    I'm trying to make part of a macro that will find user input.

    User starts macro, is prompted to enter a date, and macro will find the date.
    Problem is, the code I've used does not want to work for me.

    I've tried Dim/Set, For Each/Next, and the below:
    date1 = InputBox("Enter date", "Enter Date")
        Cells.Find(What:=date1, After:=ActiveCell, LookIn:=xlFormulas, _
            LookAt:=xlWhole, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
            MatchCase:=False, SearchFormat:=False).Activate
    Does anyone know what I'm doing wrong, please?

    Thank you
    Last edited by Aaron092; 08-05-2014 at 09:54 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. find and input with to criteria
    By gjergji in forum Excel General
    Replies: 1
    Last Post: 01-11-2013, 08:42 PM
  2. [SOLVED] Find and Input with criteria
    By gjergji in forum Excel General
    Replies: 9
    Last Post: 09-20-2012, 08:19 PM
  3. Find Date and input row
    By Challenged_Mind in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2012, 01:41 AM
  4. find and input data
    By mickeynmh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-14-2008, 10:52 AM
  5. [SOLVED] find user input
    By BorisS in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-19-2006, 01:35 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