Thread: excel VBA user form

Hi,

i am a new user on excel VBA.

1)I know we create a user form in visual basic editor, but how do we show it
in the workbooks.
2)can we edit an existing form and how do we do it?
3)is there a any way we can import a form from access to excel? I have
create a database in access but now want to convert to excel due to numerous
calculations require?

"hngo" <hngo@discussions.microsoft.com> skrev i melding
news:074867B1-0B16-4796-99A4-8032648CA886@microsoft.com...

> i am a new user on excel VBA.
>
> 1)I know we create a user form in visual basic editor, but how do we show
> it
> in the workbooks.

That is done by running a macro, like

Sub ShowForm()
Userform1.Show
End Sub

> 2)can we edit an existing form and how do we do it?

You can edit a userform the same way/place that you create it, unless the
project is password protected. You can not modify Excel's built-in dialogs.

> 3)is there a any way we can import a form from access to excel? I have
> create a database in access but now want to convert to excel due to
> numerous
> calculations require?

As far as I know; No, sorry.

HTH. Best wishes Harald