Dear all
Thank you for your help.
Here I have attached the Excel Workbook which I have prepared. Please find the user form. I have created user form namely “frmDespatchAdviceEntry”. I wrote macro such that all inputs keyed in user form will be saved in cells from cell”A” to cell”AK”.
Please help for the followings:
1) I could not call the user form through the button click event from Work sheet.
2) I have set (through initialize subroutine) default values for all the fields in the user form but it works only I click the command button “CLEAR” .I want this to be done whenever the user program called i.e. without selecting the CLEAR command button how to call initialize subroutine during opening the user form.
3) I have four command buttons FIRST/LAST/PREVIOUS/NEXT
How to retrieve the data stored in the worksheets for FIRST/LAST/PREVIOUS/NEXT
On selecting FIRST “ I want to get the data stored in FIRST row in the respective fields of User form”
On selecting LAST “ I want to get the data stored in LAST row in the respective fields of User form”
Similary “Previous” and “Next “.
PLEASE HELP.
Best regards
Krish
Bookmarks