+ Reply to Thread
Results 1 to 1 of 1

Userform Criteria

  1. #1
    Registered User
    Join Date
    01-11-2015
    Location
    COSELEY
    MS-Off Ver
    WINDOWS 8
    Posts
    57

    Thumbs up Userform Criteria

    Hi Guys,

    Was wondering...

    I have a userform and 6 sheet Tabs.

    Each tab is labelled Press 1, Press 2, Press 3, Press 4, Press 5, Press 6

    basically I am wondering weather I can use a cmd button on my usrform to write the data on my userform based on the following Criteria.

    First Look up the press in the userform Selected and locate the correct sheet.
    Next lookup the date selected in the userform and find the date on that sheet (Date format being dd/mm/yyy)
    Next Locate the Time selected and then rite the relevant data with in the row.

    I have attached my sheet for Reference

    Its sort of a bit like an appointment calendar I guess.

    Any ideas?
    Attached Files Attached Files

+ 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. Userform search from sheet and find criteria and sum
    By konficus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2015, 10:02 AM
  2. multiple criteria vlookup in vba userform
    By kuraitori in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-04-2014, 12:41 AM
  3. [SOLVED] Populate labels in userform if criteria met
    By intex in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-15-2014, 03:13 PM
  4. Userform To search based on 2 criteria Help
    By MDJ666 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2013, 09:29 AM
  5. Use criteria to populate a userform listbox
    By Magnet in forum Excel General
    Replies: 0
    Last Post: 07-19-2012, 03:25 AM
  6. Userform Multi Criteria search
    By winkypinky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2012, 04:41 PM
  7. Userform Search Criteria
    By timarcarze in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 04-14-2011, 11:35 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