Home |
Search |
Today's Posts |
#1
|
|||
|
|||
userform for spreadsheet
I'm trying to create report balancing sheets in Excel. I have certain steps
that have to be taken so it's not a basic spreadsheet . Is it possible to create spreadsheets and then create userforms to fill in my spreadsheet that's not in a basic format ? Can I create a userform and set what cells the userform is to fill in ? |
#2
|
|||
|
|||
Here are some starting points for userforms
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. http://support.microsoft.com/default.aspx?kbid=161514 XL97: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=213749 XL2000: How to Use a UserForm for Entering Data http://support.microsoft.com/default.aspx?kbid=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp -- HTH RP (remove nothere from the email address if mailing direct) "spreadsheets/userforms" wrote in message ... I'm trying to create report balancing sheets in Excel. I have certain steps that have to be taken so it's not a basic spreadsheet . Is it possible to create spreadsheets and then create userforms to fill in my spreadsheet that's not in a basic format ? Can I create a userform and set what cells the userform is to fill in ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
Cell Content from UserForm Not Retained | Excel Discussion (Misc queries) | |||
UserForm Recall Problem | Excel Discussion (Misc queries) | |||
How can I run a macro in the background whilst a UserForm is visib | Excel Discussion (Misc queries) | |||
UserForm TextBox/ComboBox question | Excel Discussion (Misc queries) |