Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i bring a visual basic form to the spread sheet?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i bring a visual basic form to the spread sheet?
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i bring a visual basic form to the spread sheet?
What objet are on the form? Most cases you want to leave the form bu tput a button on the worksheet to open the form and to make it easy to access the form. Why do you want to run the userform from outside the workbook. what arre you trying to do with the userform? -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=189921 http://www.thecodecage.com/forumz/chat.php |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i bring a visual basic form to the spread sheet?
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 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Run imported form from VBA into Visual Basic 6 | Excel Programming | |||
visual basic help Excel/word form filling in | Excel Discussion (Misc queries) | |||
Visual Basic Form | Excel Programming | |||
Inserting Form form Visual Basic... | Excel Programming | |||
Using Visual Basic form to enter data | Excel Programming |