VBA Button and text box

[cswan]

Hi

I am writing a program and I need to display the bottom value in column A of my spreadsheet; I have a userform which has a command button and a text box, what code do I need to enter to make it so that when I press the command button it displays the bottom value in column A into the text box?

Any help would be greatly appreciated.

Thanks

 

[VoG]

Try

Private Sub CommandButton1_Click()
TextBox1.Value = Range("A" & Rows.Count).End(xlUp).Value
End Sub

 

[cswan]

Thankyou very much for your help, worked brilliantly