+ Reply to Thread
Results 1 to 2 of 2

Finding cell based on user input within a calendar

  1. #1
    Registered User
    Join Date
    09-10-2013
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    16

    Finding cell based on user input within a calendar

    Hello Everyone. I have am new to VBA with a bit of c++ experience. I am attempting to locate a specific cell based on matching a user input with values found in column A and row 1.

    Essentially I have a calendar with Dates across the top and hours down the left side. User inputs a date and time and the macro finds the proper cell and populates a text string.

    This is what I am experimenting with so far, simply trying to debug the search so far. Any help greatly appreciated.


    [I]
    Please Login or Register  to view this content.
    Last edited by Fotis1991; 09-13-2013 at 04:04 AM. Reason: added code tags

  2. #2
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Finding cell based on user input within a calendar

    Welcome to the forum

    Pls

    Use code tags around code.

    Posting code between
    Please Login or Register  to view this content.
    tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

    Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here


    I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Cell based on formula and allow user input?
    By proepert in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-27-2013, 06:00 PM
  2. Help with Finding Date based on User Input
    By micmcgee in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-08-2013, 05:22 PM
  3. Excel fiscal year calendar color formatting based on user input from dates.
    By mdjco in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2012, 03:30 PM
  4. placing a cell value based on user input
    By JJCRIC in forum Excel General
    Replies: 2
    Last Post: 12-29-2009, 10:03 PM
  5. Finding a record based on user input
    By Soundman in forum Excel General
    Replies: 5
    Last Post: 06-20-2005, 11:05 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