Thanks for the reply


Yes, this can be done and it is not very hard. re what aspect do you need help?
  1. setting up a userform?
  2. reading from a text file?
  3. moving the text file info into the userform?
A few other questions?
  1. should the userform display the current, say, path and log file?
  2. should the userform allow the user to select another logfile for display?
  3. should the user be able to display only what is of interest (perhaps based on some criteria?
  4. in addition to what the user might want to do (#3), is there any info in the log file that triggers action by the spreadsheet? For example, lines that should not be displayed
What i am trying to do is allow my user to see a list of textfiles in a listbox think im ok with that bit, Im also ok with writing my textfiles, im using the extention CMI. i.e. filename.cmi, but it is just a text file

I want them to be able to select a file to open from that list and then the contents be imported into the textbox on my userform, thats the bit I need help with.

My text file will contain 2 parts seperated by a : would be good to be able to put the first part in textbox 1 and the second part in text box 2 if thats not too much more complicated.

in answer to the above, i dont require anything more complicated than the ability to open the two parts of my text file into my two textboxes, if they require to open another file it will be from the list box and just overwrite the previous content of my two textboxes

Thanks again for the help

Gibbo