Convert and export Access forms into excel

[sai_golden]

Is there any way to convert MsAccess Forms to VBA User form.

I have a form in access database i need to convert it into userform, so that i can import the same into excel.

Is there any way please help

[Simon Lloyd]

Moved to correct forum.

[sai_golden]

Thanks Simom,

Since both access and excel were involved and i wanted the forms in excel, i put this in Excel Forum.

Please help

[CreganTur]

I don't know of any way to directly copy the design of a form between any VBA programs.

To do what you want I would suggest building a new form in Access that looks how you want it to. Just be sure that you name all of your objects (textboxes, buttons, etc.) with the same names as the objects in your Excel file. Then you can just copy the code from your Excel form and paste it into the code section for your newly created Access form.

This way all of the heavy lifting is done- the code for btnOkay_Click in Excel will work for btnOkay_Click in Access. You'll probably need to make a few small syntax corrections, but at least this way you won't have to completely rewrite everything.

HTH