Results 1 to 16 of 16

VBA code to Select Cell based on multiple criteria

Threaded View

ankamshetti.nagaraj VBA code to Select Cell based... 11-27-2020, 11:36 AM
Mumps1 Re: VBA code to Select Cell... 11-27-2020, 12:28 PM
ankamshetti.nagaraj Re: VBA code to Select Cell... 11-30-2020, 10:32 AM
Mumps1 Re: VBA code to Select Cell... 11-30-2020, 10:45 AM
ankamshetti.nagaraj Re: VBA code to Select Cell... 11-30-2020, 10:46 AM
Sintek Re: VBA code to Select Cell... 11-28-2020, 02:27 AM
ankamshetti.nagaraj Re: VBA code to Select Cell... 11-30-2020, 11:01 AM
Sintek Re: VBA code to Select Cell... 11-30-2020, 10:47 AM
Sintek Re: VBA code to Select Cell... 11-30-2020, 11:09 AM
ankamshetti.nagaraj Re: VBA code to Select Cell... 11-30-2020, 12:06 PM
Sintek Re: VBA code to Select Cell... 11-30-2020, 12:18 PM
ankamshetti.nagaraj Re: VBA code to Select Cell... 11-30-2020, 02:25 PM
Sintek Re: VBA code to Select Cell... 11-30-2020, 12:40 PM
Sintek Re: VBA code to Select Cell... 12-01-2020, 02:03 AM
ankamshetti.nagaraj Re: VBA code to Select Cell... 12-01-2020, 06:00 PM
Sintek Re: VBA code to Select Cell... 12-02-2020, 01:28 AM
  1. #1
    Registered User
    Join Date
    08-30-2012
    Location
    Hyderabad
    MS-Off Ver
    Excel 2007
    Posts
    38

    VBA code to Select Cell based on multiple criteria

    I'm looking for a vba code to select the cell based on the 2 criteria's (1. search the string in column A and 2. search for a date number in row 4). basically i have a sheet which consists of employee names in column A and numbers (1 to 31, which is formula based) as a header in row 4. I have a userform with combobox & Calendar control. My query here is based on the employee name & date selected in userform, i want to select the cell in sheet for that employee.

    For Example: In the image if i want to choose Employee3 and date as 9, macro code should select the J8 cell.

    I've attached the sample file & code for reference.

    any help here is really appreciated !!

    Leave.PNG
    Userform.PNG
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA code to get the value of a cell based on multiple criteria
    By braun reivn in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2020, 07:56 PM
  2. Select a cell at random based on multiple selection criteria across multiple sheets.
    By scottyms in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2016, 09:44 AM
  3. Replies: 6
    Last Post: 06-17-2014, 11:11 AM
  4. Select Max Date Based on Multiple Criteria with Wildcard Text
    By TxNyCa in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-28-2013, 02:34 PM
  5. Select multiple criteria based on check box selection and return all unique values.
    By TommyToe in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2013, 09:14 AM
  6. Need code to select a range of cells based on criteria in column H
    By davekippen in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-06-2011, 01:40 PM
  7. [SOLVED] Select cell formula based on criteria
    By roseberryv@orvis.com in forum Excel General
    Replies: 1
    Last Post: 06-15-2006, 07:10 PM

Tags for this Thread

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