visual basic Form

dantb · Mar 21st, 2002, 07:13 PM

I am new to visual basic. I have made a form in vba, and I can not figure out how to import it into Excel, and make the dern thing work. Newbe here, and help would be appriciated. Thx

robfo0 · Mar 21st, 2002, 09:01 PM

Hi,

If you open excel, or the file you want to import to, then go to the code screen (by pressing alt+f11), then go to "File" and "Import File". then you locate your .frm form file.

Hope that helps

Ivan F Moala · Mar 21st, 2002, 09:49 PM

Quote:

On 2002-03-21 18:13, dantb wrote:
I am new to visual basic. I have made a form in vba, and I can not figure out how to import it into Excel, and make the dern thing work. Newbe here, and help would be appriciated. Thx

Do you mean you have a form and you don't
know how to load it into excel ??

If so then type in [Load Statement] while
in the VBA editor, this should get you started on the coding.

Ivan

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 07:13 PM	#1
dantb Board Regular Join Date: Mar 2002 Location: Arkansas Posts: 358	I am new to visual basic. I have made a form in vba, and I can not figure out how to import it into Excel, and make the dern thing work. Newbe here, and help would be appriciated. Thx

Mar 21st, 2002, 09:01 PM	#2
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Hi, If you open excel, or the file you want to import to, then go to the code screen (by pressing alt+f11), then go to "File" and "Import File". then you locate your .frm form file. Hope that helps