Excel Document Saving

Hey all,

Hopefully someone can help.

I want to create a customer macro/ button in excel that reads the value of a text box called CRNumber and then saves the document with said value.

I have created a macro that can read from a cell and save the file with the value of the cell, however can't for the life of me get it to read from the text box :/

I will be adding other stuff to the macro later, but this is the important part for now.

Thanks in advance.

Anyone able to help? :/

Never figured it out in the end, had to do it a different way but it works.

For those interested, I just linked the Text Box to a Cell and have hidden the cell text :D