Hi,
I need a help regarding little issues in the vba coding. I am working since last many days on file and have done all in my strength from Youtube and vba forums to make this file without having knowledge of vba coding.
The file has a sheet name Purchases having a structured table " Purchasing" and a user form link to that table. I am still unable to make it perfect since days while trying to complete it.
it is completed from my angle any how I don't know unless the issues will comes later on
Delete key and code working FIne
Search key working fine
List box double click working fine and record on user form and search text box are sync with each others.
Problem
Save Command on click error sometimes.
1) I am unable to handle this. when i click save its goes to runtime error and yellow lines come on first line of transfer of data i.e EntryNo.value to S.no in table. but when i click to continue form its came back to userform and entry has been saved in table but the format of font is bit small and different alignment when saved cleanly.
.2) If during data earning i found new item . I have to close the form and add new item in table "itemsMaster" and if from there i Run form . and enter data when click to save subscript out of range error comes while if i open user form while my "Purchases" SHEET is active this error never comes. Is it possible to remove this sensitivity?
3) Update command is working perfectly but its taking almost 10 to 15 seconds. and calculating threads
4) I try to find solution for list box highlitened when saved complete but didnt found solution or may be I am nill in vba i dont understand if its easy. list box highlight row never moves when serach button clik to display desired entry No. on userform.04-01-22.xlsm04-01-22.xlsm
I will be grateful to all champs here for their kind consideration on my file which is really big. But right now I need help the issues written above.
As I am keen to complete this home project.
Thanking you.
Please find attached file.