Dear all,
Kindly help me to complete attached User Form with VBA Commands on all buttons
please use the data as example which is on sheet 2 as my master data.
Buttons are :
ADD RECORD = for adding new employee record using user form interface.
SAVE = to save record from user form interface to sheet 2 (master data)as database in table style.
CLEAR = to clear user form for new record
SEARCH = to search/view required employee data with unique ID(which is Emp. No.) on user form interface.
EDIT = to change or edit missing information
UPDATE = after edit or change information, update the record on master data. (If Save button do the same as update button so it will not required, plz suggest/advice)
<<Go to First = Show first record on user form interface
< Previous = previous record
>Next = next record
>>Go to Last = Show Last record
If anyone have some better idea so please share, it will be welcomed.
I am hoping some solution this time from experts as they are very helpful to their users.
thanks and best regards,
Virgo
Bookmarks