Simple question with a twist
Posted by J Tompson on August 14, 2001 11:36 AM
I'm designing a worksheet that is going to be a template for people to use. However i want to make sure that they yuse it correctly. I've got a user rorm that shouild allow me to place information into the correct cell... but i can't for the life of me remeber how to assign a textbox contents to a cell. The twist is i want to use a combination of the information placed in the userform to be the file name and save automatically in a selected location so that the original worksheet never being edited.
I would like to it be a combination textbox1 and textbox 2. Is this possible?
Further to this, can i save it as a type of file due to compatibility porblems with excel 97 and userforms?
Thanks in advance,