visual basic Form

dantb

Active Member
Joined
Mar 20, 2002
Messages
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
 

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop
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
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,214,812
Messages
6,121,693
Members
449,048
Latest member
81jamesacct

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top