Autofill cell in a userform based on a previously filled in cell.

[streamofmight]

Hi all.

my file's username and password is username1 and password1 respectively.

at the home page, there is a macro called Add/Edit Transactions. For the option description, the user is supposed to select which fruit he wishes to purchase. After he has selected, I want the Price/Unit textbox to display the corresponding price of the fruit chosen based on the table Home!A8:E37.

After Quantity is set, assuming user is happy with the price/unit shown and does not proceed to edit it, the total price would be automatically calculated by multiplying the quantity with the price/unit.

Please assist me! I have struggled with this for the whole day looking through google and this forum. Currently reading through vba for dummies to try to solve it. Thanks!

[streamofmight]

Solved! Thanks! Managed to figure it out

[JohnnyAmbush]

What did you do? I might have a similar need.