Loading the value of text file (notepad) to a textbox

[nathan0519]

Hi Sir/Maam, is there a way to load the value of a text file (notepad) to a textbox? Is it possible? Refer to my screenshot. I already have the code on how to open a specific file directory and all I just want to learn is to how to load the value of a textfile to a textbox. Thank you
TestFile.png

[p24leclerc]

try the following macro. Make sure you start it while being in the sheet that contains your textbox.
Also, change the file path and name as per your file's name and location and change theTextBox 1 name if needed.

Please Login or Register  to view this content.

[nathan0519]

Sorry p24leclerc but im not familiar in macro, would you mind educating me? thank you very much

[p24leclerc]

Below, you'll find 2 files. One is the workbook with the macro to import a TXT file into a TextBox. The other one is a TXT file as an example. Open the Test.txt file for instructions.
Hope this helps
Regards

[nathan0519]

Thank you very much p24leclerc.