What is a user form?
in [Programming]
|
From: Jennifer on 30 Nov 2009 14:39 My company finally upgraded to Excel 2007. I've been reading in this newsgroup about user forms and thought that once I finally got 2007 I'd see for myself. But looking in the help files, I don't see anything for User Forms. Is this just a slang term for the Developer tab? What am I missing? Thanks! Jennifer
From: JLGWhiz on 30 Nov 2009 15:05 A user form is a file platform that allows a user to build a set of controls which can be used to manipulate data on the worksheets, received user input and display selected data, to name a few uses. In xl2003 and earlier, you could access the VBE by pressing Alt + F11 and then Insert>UserForm to display the basic form breadboard. I do not have xl2007 or later but I understand that you do have to use the Developer ribbon to access the Visual Basic facilities of Excel. Once in, you should be able to insert the form in the same manner. "Jennifer" <j.evans.1970(a)gmail.com> wrote in message news:6077b4d2-3df4-47aa-a2e1-60528238a9b4(a)m35g2000vbi.googlegroups.com... > My company finally upgraded to Excel 2007. I've been reading in this > newsgroup about user forms and thought that once I finally got 2007 > I'd see for myself. But looking in the help files, I don't see > anything for User Forms. Is this just a slang term for the Developer > tab? What am I missing? > > Thanks! > Jennifer
From: Steve Yandl on 30 Nov 2009 15:05 Jennifer, Hold down the Alt key while pressing the F11 key to get a VBE window, then go to help in that window and type in userform. Steve Yandl "Jennifer" <j.evans.1970(a)gmail.com> wrote in message news:6077b4d2-3df4-47aa-a2e1-60528238a9b4(a)m35g2000vbi.googlegroups.com... > My company finally upgraded to Excel 2007. I've been reading in this > newsgroup about user forms and thought that once I finally got 2007 > I'd see for myself. But looking in the help files, I don't see > anything for User Forms. Is this just a slang term for the Developer > tab? What am I missing? > > Thanks! > Jennifer
From: Jennifer on 30 Nov 2009 15:55 Thank you both for the reply! Much appreciated.
From: Ron Rosenfeld on 30 Nov 2009 16:14
On Mon, 30 Nov 2009 15:05:46 -0500, "JLGWhiz" <JLGWhiz(a)cfl.rr.com> wrote: >I do not have xl2007 or later but I >understand that you do have to use the Developer ribbon to access the Visual >Basic facilities of Excel. You can do it that way. But you can also access the VBE with <alt-F11> --ron |