| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Starting a Visual Basic Code
I am trying to make a button on my excel sheet that when hit will do a few
things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a Visual Basic Code
http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Here are some other sources of information: -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote: I am trying to make a button on my excel sheet that when hit will do a few things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a Visual Basic Code
Thanks Tom, I'll give your links a try.
"Tom Ogilvy" wrote: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Here are some other sources of information: -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote: I am trying to make a button on my excel sheet that when hit will do a few things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a Visual Basic Code
Well, I am getting closer to what I need but am still not there. How do I get
the textboes to link to cells I want them to fill, and how do I get the form to open in excel? "Tom Ogilvy" wrote: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Here are some other sources of information: -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote: I am trying to make a button on my excel sheet that when hit will do a few things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a Visual Basic Code
Use the control source property of the textbox
Sheet1!A1 Userform1.show -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote in message ... Well, I am getting closer to what I need but am still not there. How do I get the textboes to link to cells I want them to fill, and how do I get the form to open in excel? "Tom Ogilvy" wrote: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Here are some other sources of information: -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote: I am trying to make a button on my excel sheet that when hit will do a few things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Starting a Visual Basic Code
I am finally getting somewhere, but now I am trying to figure out the code
for a button that you can press that enters all the information, I also want it to enter the info into a new row each time. i have a count, but I dont know how to link the count cell to the control source. All the columns stay the same but the row changes each time. "Tom Ogilvy" wrote: Use the control source property of the textbox Sheet1!A1 Userform1.show -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote in message ... Well, I am getting closer to what I need but am still not there. How do I get the textboes to link to cells I want them to fill, and how do I get the form to open in excel? "Tom Ogilvy" wrote: http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm Lesson 11: Creating a Custom Form Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step. XL97: How to Use a UserForm for Entering Data (Q161514) http://support.microsoft.com/?id=161514 XL2000: How to Use a UserForm for Entering Data (Q213749) http://support.microsoft.com/?id=213749 http://j-walk.com/ss/excel/tips/tip84.htm See this tutorial here http://www.dicks-blog.com/excel/2004...g_userfor.html http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Here are some other sources of information: -- Regards, Tom Ogilvy "Erik (AP Inc.)" wrote: I am trying to make a button on my excel sheet that when hit will do a few things. I want it to first insert a new row into my spreadsheet. I then want the form I created in Visual Basic to come up. This form has 11 different data fields. After those are filled manually, I want it to insert the values into the appropriate cells in my sheet. I made an extensive worksheet in excel and I am afriad of it getting messed up while I am at school and other people use it. I figure if I do it this way, people can continue to enter info, without mt formulas getting messed with, etc. I've never done this before but have worked alot with excel, so I think I can figure it out with some help. I dont really know how you decide what to type as the code. Is there a format or wizard? I've worked on it most of the afternoon today with little progress. Any help would be appreciated. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic code | Excel Discussion (Misc queries) | |||
| VISUAL BASIC CODE | Excel Programming | |||
| Visual basic Code | Excel Programming | |||
| visual basic code | Excel Programming | |||
| Visual Basic Code | Excel Programming | |||
![Erik (AP Inc.)[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
