"hngo" skrev i melding
...

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