Add & Delete Records in Excel using a form showing a scrollbar also!
Hi all,
I am trying to mk a Data-Entry Form (using VBA) similar to the DataForm made available in Excel in DATAFORM menu. I have made an excel sheet with the foll fields: CODE EMPLOYEE_NAME DESIGNATION DEPARTMENT DEPT_NO I have made a dynamic named range called "DATABASE" for the above (using OFFSET function) & now trying to make a form which contains a a) Vertical scrollbar on the left & b) 5 labels for the fieldnames & c) 5 textboxes for entering the field records, arranged on the right to the scrollbar & one-above-the-other for entering the data for the following fields. d) There is a Label on the extreme top-right also which will show the current record out of the Total records present in Database. e) Add Record button f) Delete Record button g) Find Duplicate Records button h) Close Form button 1) I want to make something similar to the DataForm (which is present in Excel), but donot knw the coding as to how the textboxes get updated (display) with the current record value when the scrollbar arrows are pulled up/down. 2) How to enter new records into the textboxes so that it becomes the last record of the database. 3) How to find Duplicate entries displayed in textboxes & delete the same with the delete button. Is it possible to move the scrollbar arrows with keyboard arrow keys instead of using a mouse to drag the arrows up/down? Could anybody help me out on this thru VBA programming? Any help will be really appreciated. Thanks & Regards, Eijaz |
Add & Delete Records in Excel using a form showing a scrollbar also!
Eijaz
Why re-invent the wheel ... take a look at John Walkenbach's Advanced Data Form. I'm sure this will give you what you need and, for a small price, you can see the code. http://www.j-walk.com/ss/dataform/index.htm Regards Trevor "eijaz" wrote in message ... Hi all, I am trying to mk a Data-Entry Form (using VBA) similar to the DataForm made available in Excel in DATAFORM menu. I have made an excel sheet with the foll fields: CODE EMPLOYEE_NAME DESIGNATION DEPARTMENT DEPT_NO I have made a dynamic named range called "DATABASE" for the above (using OFFSET function) & now trying to make a form which contains a a) Vertical scrollbar on the left & b) 5 labels for the fieldnames & c) 5 textboxes for entering the field records, arranged on the right to the scrollbar & one-above-the-other for entering the data for the following fields. d) There is a Label on the extreme top-right also which will show the current record out of the Total records present in Database. e) Add Record button f) Delete Record button g) Find Duplicate Records button h) Close Form button 1) I want to make something similar to the DataForm (which is present in Excel), but donot knw the coding as to how the textboxes get updated (display) with the current record value when the scrollbar arrows are pulled up/down. 2) How to enter new records into the textboxes so that it becomes the last record of the database. 3) How to find Duplicate entries displayed in textboxes & delete the same with the delete button. Is it possible to move the scrollbar arrows with keyboard arrow keys instead of using a mouse to drag the arrows up/down? Could anybody help me out on this thru VBA programming? Any help will be really appreciated. Thanks & Regards, Eijaz |
All times are GMT +1. The time now is 04:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com