VBA code to return the last value in a column into a UserForm TextBox

[Grizlore]

Hi All,

I have a UserForm, which I would like to calculate a weight.

I would like the User to enter the current weight and the UserForm to display the previous weight - subtracting one from the other, I can display the weight used.

I would like the vba code to pick up the last value in column G on sheet "Data"

Could some be able to help me please?

Thansk in anticapation

 

[Momentman]

The last value in column H on sheet data can be picked up via

TextBox1.Value = Worksheets("Data").Range("H1").End(xlDown).Value

 

[Grizlore]

Many Thanks !!!!

Appreciate it

 

[Momentman]

H in my code should av bin G