Hello gurus
I have a worksheet with Jobtitles in column A and there relevant competencies in columns B to Z for each Jobtitle.
I have a UserForm with a Job Title TextBox and a MultiPage Control with pages 1 to 25. On each MultiPage page I have a TextBox which I want to populate with the relevant competency.
i.e
MultiPage1.TextBox1.Value=lookup jobtitle and return column B content;
MultiPage2.TextBox2.Value=lookup jobtitle and return column C content;
etc...
Any suggestions