Savings Deposit User Form

[DEBLACKJACKAL]

Regards to all

Am happy to face yet another challenge in the VBA arena that prompts me to visit this forum seeking skilled assistance and guidance from members whom I know are very much present here. Am trying to figure out how to create a simple Savings deposit portal where by you enter a member’s ID and his/her name is instantly retrieved from sheet 1 and entered into the corresponding text box which I believe I have successfully coded. Next the operator is required to enter the date of deposit and the amount received. The mother of all battles is that when the deposit button is clicked, based on the member’s name, ID and date, the amount received ought to be entered into the corresponding cell in Sheet 1. Any ideas on how this can be done using VBA code?
I have attached my sample sheet with the relevant user form for perusal

Cheers

DEBLACKJACKAL

 

[Logit]

You have posted to several Forums without indicating such in your post.

I posted an answer here : https://www.ozgrid.com/forum/index.php?thread/1230202-savings-deposit-entry-user-form/

 

[vletm]

DEBLACKJACKAL
You should reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There has written very clear - what to do if someone would like to use Cross-Posting.
Those rules are for You too.

 

[Belleke]

Does this help?