AutoFill Certain Columns When a Row is created

[Mr.Steel]

Hello!

Im new to vba and trying to get a grasp on things but im still experiancing lots of problems.

Attached is a version of a Fixed asset ledger i am building for my company. In the userforms section on VBA their is a userform called AddAsset. Contained within this forms VBA under the Sub Okay_Click() is my attempt at making VBA to automatically autofill the cells from a few selected columns R, S, T, W, X, Y when the okay button is hit. (This is just my problem but the other columns are filled with other information pretaining to the specific asset)


Attached is a version of my spreadsheet. Thanks in advance for helping me out on my work! Have a wonderful day.

[tigeravatar]

Mr.Steel,

Give the following a try for your okay button code in the AddAsset userform:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Mr.Steel]

Thanks for the timely response tiger avatar!

Unfortunetly that didn't solve my problem as it didnt copy the exact formulas contained in the cells above the new entry, the cells returned as "0$" instead of containing a formula which performs calculations. Are their any other ideas you can provide to help me with my problem?

[tigeravatar]

Mr.Steel,

Updated code for cell formulas instead of just values:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[tigeravatar]

Oh, I just realized I made a mistake, fixing now, post again in a sec

[tigeravatar]

Mr.Steel,

Alright, this should fix it, sorry for the confusion:

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[Mr.Steel]

That Worked perfectly. Thank you very much for your help. XD