Results 1 to 25 of 25

Export CSV data to Excel Userform using reference number to specify relevant data

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-12-2013
    Location
    Usually at work, in the UK
    MS-Off Ver
    Excel 2010
    Posts
    639

    Export CSV data to Excel Userform using reference number to specify relevant data

    I have a Notepad saved in a folder which I keep notes everytime I speak to a customer.

    What I would like to do is create a userform where I can input a case reference number and click a command button which searches the CSV/TXT file for any notes for the specific reference number and then returns all notes (seperated by a blank line) in the textbox within the userform in the posted/saved format.

    I can find lots about importing to excel but nothing about importing data to userforms. Is what I am attempting possible and if so what should I be googling/researching to assist me in doing so?

    CSV file added for format. The userform contains two text boxes, one blank for import and one for completing the case reference number (format on CSV file. Line item 1).

    i.e. if I searched by SL-001-0155648 I would get the below (It's not code but I thought the best way of showing what I mean):

    SL-001-0155648, SLewings, 16/06/2014  15:13:27
    Spoke to Mr S on the phone and he is an idiot
    
    SL-001-0155648, SLewings, 18/06/2014  21:13:27
    Mr S Called again and he's even more annoying this time
    Attached Files Attached Files
    Last edited by Sc0tt1e; 06-18-2014 at 07:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Number Format when writing data from VB to excel on a Userform
    By Nathan44 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-12-2013, 05:32 AM
  2. [SOLVED] VBA Userform Data Entry - Reference Number problem
    By TalResha in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 06-17-2011, 09:03 AM
  3. macro for Extracting relevant data from an excel database
    By cbhawsar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-22-2011, 11:50 AM
  4. How to extract relevant column data in excel 2003
    By joee in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2010, 04:57 AM
  5. Userform to Export Certain Data
    By RecRic in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-02-2007, 05:01 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