如何使用VBA代码将带有项目符号，粗体字符和分隔线的文本粘贴到单个Excel单元格中？

I want to do the equivalent of selecting a cell in a sheet, pressing F2 and then CTRL+V, so that all the formatting such as bullets, bold characters and breaklines are preserved and pasted into one cell. Please note that I'm NOT copying from excel sheets, rather im using excel vba to copy from a Word Document.I want to do the equivalent of selecting a cell