Copy the Code from an Excel Form to a Worksheet automatically

Logit · #1 10-19-2023, 01:41 PM

Quote:

Must be somewhere in the VBComponent.Export bit I guess?

Did a little internet research and I agree with your assumption. Trust we are both correct on this. Seems if you move a .frm file to another project the .frx file must go with it as it is part of the entire .frm makeup.

One website states :

Quote:

When we export forms from VBA projects it creates two files of two different types. One file with .frm extension and another with the .frx extension. .frm file contains the codes of the form. The .frx file includes the elements of the form file. Especially the graphical elements.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Link UserForm checkbox to corresponding shape on one worksheet and copy to 'template' worksheet	kiwimtnbkr	Excel Programming	23	10-08-2020 02:32 AM
Need to copy specific ranges column data as row data from one worksheet to another using excel VBA	ganesang	Excel Programming	1	03-26-2020 06:18 AM
How to get Excel to automatically continue a pattern which is form as 001-01-01 ....003-03-03	anakonda93	Excel	3	04-16-2018 12:01 AM
Automatically copy/paste a form field onto new pages, with user input included	Pindar	Word VBA	3	01-13-2017 11:49 AM
VB Code in Excel Active worksheet	shakilhyd	Excel	2	05-17-2010 07:50 AM