+ Reply to Thread
Results 1 to 1 of 1

Userform to enter data into Sheet. Created a second Userform to Search that data to send

  1. #1
    Registered User
    Join Date
    02-27-2014
    Location
    Whitehall, MI
    MS-Off Ver
    Excel 2007
    Posts
    1

    Userform to enter data into Sheet. Created a second Userform to Search that data to send

    I have Created a main Userform for data to be enter into a main sheet called "MasterData" which works very well. Now I am trying to create a second userform that will search through this data for a specific job number that is enter into one of the text boxs and then create a new sheet to view the data in. I have a CalendarPicker on this user form with one text box for the job number.

    On the second user form I am trying to use a textbox that would filter the data searching for "Job Number" that they will scan in from travelre. I have the userform creating a new worksheet for this data but can't get it to pull in any data. I am very new at this so I have pieces this together from searching on the net.

    So for the text box being a filter I am not sure what I should put here and do I also include the range of the data I want they will be sent to the new sheet that will be created. Here is my code for everything:
    Please Login or Register  to view this content.
    Last edited by vlady; 02-27-2014 at 08:06 PM.

+ 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 to Search based on Unique ID update and save data in an exel sheet
    By Rosco90 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2013, 04:50 PM
  2. Search data from sheet & display in the userform
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2013, 01:08 PM
  3. Sheet Protection 'ON' and still enter data from UserForm??
    By leopardhawk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 07:32 AM
  4. [SOLVED] EXCEL USERFORM- pull data from sheet 1 into userform
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 11:10 AM
  5. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01:06 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