Hi,

I have created a form using teh developer tab in excel in vb. The problem
is anytime I want to access the form i need to go to the developer tab, click
on vb and run it frorm there. What I would like to do is to bring the form to
the spreadsheet so that I can run it directly from there. or better yet, be
able to run the form independently of the spreadhseet. is that a possibility?

Thanks a lot for your help,

Maryam

add a button to the spreadsheet and attach the code
UserForm1.show 'or whatever the form name is

You will not be able to run the form independant of XL...

--
HTH...

Jim Thomlinson


"MaryamB" wrote:

> Hi,
>
> I have created a form using teh developer tab in excel in vb. The problem
> is anytime I want to access the form i need to go to the developer tab, click
> on vb and run it frorm there. What I would like to do is to bring the form to
> the spreadsheet so that I can run it directly from there. or better yet, be
> able to run the form independently of the spreadhseet. is that a possibility?
>
> Thanks a lot for your help,
>
> Maryam

Sub ShowForm
UserForm1.Show
End Sub

Attach to a macro button you place on the QAT or a Command Button on a
worksheet.

Not sure what you mean by "run the form independently of the spreadsheet"

What do you consider as a "spreadsheet"?

Worksheet or Workbook?


Gord Dibben MS Excel MVP


On Tue, 23 Mar 2010 11:16:07 -0700, MaryamB
<(E-Mail Removed)> wrote:

>Hi,
>
>I have created a form using teh developer tab in excel in vb. The problem
>is anytime I want to access the form i need to go to the developer tab, click
>on vb and run it frorm there. What I would like to do is to bring the form to
>the spreadsheet so that I can run it directly from there. or better yet, be
>able to run the form independently of the spreadhseet. is that a possibility?
>
>Thanks a lot for your help,
>
>Maryam