Add & Delete Records in Excel using a form showing a scrollbar also!

[eijaz]

Hi all,

I am trying to mk a Data-Entry Form (using VBA) similar to the DataForm made
available in Excel in DATA>FORM 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

 

[Trevor Shuttleworth]

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