|
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 |
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 |
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com