title: How do I create an Excel VBA Form text box to view multiple records from a filtered worksheet
body: <p>I’m an enthusiastic amateur to using VBA &amp; Developer in Excel. I use multiple excel data sheets &amp; workbooks on a daily basis and for years persevered by jumping between my various worksheets to retrieve and process my data. For a few months I’ve been following threads on stack overflow to teach me basic coding in order to develop a form to collate and view my data. Thank you so much! However! I cannot find a thread or guidance for the following:</p>
  <p>I have an excel table which contains multiple records of notes and comments (no more than 150 words), 4 columns but hundreds of rows. The records relate to a unique ID (personal number) for 200 people/employees. Each person has multiple records collected through years and all contained in one worksheet (CM_Notes). Within that worksheet I have created a ‘FILTER’ table to display all records relating to a specific unique ID which functions as a search.</p>
  <p>So, I have created a VBA Form which enables me to add further notes and view multiple records from all my worksheets which relate to the employees unique ID, mainly via list boxes; and it works well. Except for the ‘CM_notes worksheet’ which has too much text for a list box to be utilised.
  Therefore, <strong>I would like to include a text box will let me view no more than 200 words and allow me to cycle through the Cells containing the records from the filtered table (found in the CM_Notes worksheet) which relate to a specific ID.</strong></p>
  <p>Creating this function in Access literally takes seconds, however due to the nature of my work (collaborative working) I’m tied to excel. A screenshot of what I’m trying to achieve is attached.
  <a href="https://i.stack.imgur.com/xFFhU.jpg" rel="nofollow noreferrer">enter image description here</a></p>
  <p>Pease help!</p>
  <p>Ian</p>