MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to input text?

Posted by tee1_11 on May 25, 2000 4:26 PM

Forgive me for sounding totally ignorant, but I am. I have two little

1. How do you input the text in a form's textbox to a spreadsheet?

2. How do you make the form fire every time a new workbook is created from a
certain template?

Thanks a lot. I admire all of you excel gurus. This stuff is hard.



Posted by Ivan Moala on May 25, 2000 5:34 PM

Hi T
Do you mean a textbox from your Toolbox or forms control or from a Userform.
Have a look @ your online help if unsure.
Press F1 and let us know which one so that we can
help and direct you better.


Posted by tee1_11 on May 25, 2000 7:58 PM

Thanks Ivan. I posted the letter all over and got some good feedback. Thanks for the help.

I have another question though. I finished up the macro, but now it is only accessable from the spreadsheet that I made it in.

I saved the macro in the template, but running it opens the original documnet and starts doing its thing.

How am I to organize macros. I know in word if you save it to the almighty then every document can use the macro. Is there a similar procedure in Excel?



Posted by Ivan Moala on May 26, 2000 12:40 AM

Hi T

What you might consider doing is saving it as an addin = .xla file extension. this however will
still require it to be loaded in.
The features of an add-in become available to the user when the add-in is loaded. When a global template is loaded, Word merges the template’s menus, toolbars, AutoText entries and macros into the Word environment your file the t designating it is a template. Because of this, you may want to load the add-in.
To load add-ins or templates automatically when you start an application, you can place them in the Office Startup folder.
The default Startup folder is located in Program Files\Microsoft Office\Office\Startup.
In Microsoft Excel, you can also place an add-in in the Xlstart folder or in the folder you designate as the alternate startup folder.
To set the alternate startup folder, assign a path and folder name to the HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Excel\Microsoft Excel\AltStartup key in the Windows registry. This however will mean that everytime excel starts it will load this in? you may not wish to have this happen due to extra load times etc.

You did however say that you have saved ot as a template ?? but that opening this opens up the original ?? are you suree it is a template extension should be .xlt and that you have no refernces to the original in your library files.

Probably the best place to put your template if you have saved it as a .xlt is in your libray
dir usually C:\Program Files\Microsoft Office\Office\Library. What this means is that you will have access to this via File / New in excel and you should see your Template file.
Opening it this way should give you your workbook
as a New workbook with the macros intact.

For more info ALWAYS check your online help F1
The online help is free and helpful most of the