Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - VBA guru needed URGENTLY!
Hi,
I am currently struggling with Excel macros and I have to say I don't know anything about creating the macros. So, here's the problem: I have a worksheet x1 where I have a form for adding a new customer. Then I have a table in anothe worksheet x2 where I have all the customer id's, names, addresses and so on. I would need to have the x1 form to work the way that it automatically gets the first available customer id to the cell D9 from the x2 table (for the new customer). Then, after entering the new customer details to the form x1 I have a button, which should by pressing it, copy the customer names and addresses to the correct cells in the table of sheet x2. Of course the details should go to the same line, which indicates that new customer id. So, if the next available customer id is 8 and the row number is 9, the details should be copied to that line number 9. And the next new customer should get the next available customer id, 9 and the details to be copied in line 10 etc. Hopefully I have explained this clearly enough :) Just to make sure that I am understood: I have two problems 1) How to automatically get always the next available Customer ID to a certain cell (in this example D9)? 2) How to copy the new customer details to the correct cells depending on the customer id and next available lines by pressing a button "Save new customer details"? Please email me if you need more information as I am really in a hurry with this thing :o Thanks for all the tips and help! Rgds, Minna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel - VBA guru needed URGENTLY!
http://j-walk.com/ss/excel/tips/tip84.htm
http://support.microsoft.com/default...b;en-us;829070 How to use Visual Basic for Applications examples to control UserForms in Microsoft Excel 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/?id=168067 File Title: Microsoft(R) Visual Basic(R) for Applications Examples for Controlling UserForms in Microsoft Excel 97 File Name: WE1163.EXE File Size: 161742 bytes File Date: 05/08/97 Keywords: kbfile Description: This Application Note is an introduction to manipulating UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual Basic for Applications macros that show you how to take advantage of the capabilities of UserForms and use each of the ActiveX controls that are available for UserForms Peter Aiken Articles: Part I http://msdn.microsoft.com/library/en...FormsPartI.asp Part II http://msdn.microsoft.com/library/en...ormsPartII.asp Excel VBA tutorial: http://maths.sci.shu.ac.uk/units/ioa/ -- Regards, Tom Ogilvy "Minna" wrote in message om... Hi, I am currently struggling with Excel macros and I have to say I don't know anything about creating the macros. So, here's the problem: I have a worksheet x1 where I have a form for adding a new customer. Then I have a table in anothe worksheet x2 where I have all the customer id's, names, addresses and so on. I would need to have the x1 form to work the way that it automatically gets the first available customer id to the cell D9 from the x2 table (for the new customer). Then, after entering the new customer details to the form x1 I have a button, which should by pressing it, copy the customer names and addresses to the correct cells in the table of sheet x2. Of course the details should go to the same line, which indicates that new customer id. So, if the next available customer id is 8 and the row number is 9, the details should be copied to that line number 9. And the next new customer should get the next available customer id, 9 and the details to be copied in line 10 etc. Hopefully I have explained this clearly enough :) Just to make sure that I am understood: I have two problems 1) How to automatically get always the next available Customer ID to a certain cell (in this example D9)? 2) How to copy the new customer details to the correct cells depending on the customer id and next available lines by pressing a button "Save new customer details"? Please email me if you need more information as I am really in a hurry with this thing :o Thanks for all the tips and help! Rgds, Minna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help needed urgently | Excel Worksheet Functions | |||
Help needed urgently..:( | Excel Worksheet Functions | |||
Excel Guru Needed For Formula | Excel Worksheet Functions | |||
help needed urgently | Excel Worksheet Functions | |||
Help Needed Urgently | Excel Worksheet Functions |