excel VBA user form

[hngo]

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?

[Harald Staff]

"hngo" <[email protected]> skrev i melding
news:[email protected]...

> 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