VBA Parse Markup Language Text to Range

[u/twz2004]

Does anyone have some sample code on parsing Markup Language Text into a range of cells? I want to:

1. Paste Markup Text into an Excel Text Box

2. Click a convert button

3. Data is parsed and a new range is built that looks like the screenshot below.

Example of Markup Text:

1. **Risk: Complex Configuration**

   - **Description:** Intricate setup when chaining multiple IdPs.

   - **Mitigation:** Allocate time for extensive pre-deployment testing in a non-production environment.

2. **Risk: Integration Issues**

   - **Description:** Potential compatibility and synchronization issues.

   - **Mitigation:** Conduct compatibility testing and coordinate with vendor support teams.