Hello, I'm just learning how to use macros and have this fairly large project to do. It concerns extracting data from a schedule (timetable) with the courses, course code, name of tutor on it. I have managed to extract from a cell and have the following information come up in a message box(course code, course title, tutor name. However, what I would like to do is just firstly select those cells by the course code. That is the course code usually follows this form CFR-2101, that is three letters in capitals followed by a dash and 4 numbers. I'm trying to create a user form where the user would have to type in the course code and if the code doesn't follow this form (the 3 letters-and 4 numbers, that a message pops up saying that the course code form is incorrect or something like this. econdly, based on this form of the course code, I would like o be able to highlight those cells in the timetable which start with a course code(eg put then in red or something). My problem is I don't knwo what to put to stand for the course codeie I have tried just * eg.***-**** as the form f the code to recognise but it doesn't work. I'm not to sure how to write in VBA the fact that the code must have this form, containing both letter and numbers.
Thanks for your help in advance
November 14, 2008 5:52 PM
November 25, 2008 4:57 AM