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. Secondly, 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 know what to put to stand for the course code ie I have tried just * eg.***-**** as the form f the code to recognize 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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!