Hi,
Can anybody help. I'm new to VBA and coding. I have created Userforms to control data. I have created a code that will insert data into a table but stumped as to how to sort that code so it appears in an ascending order. The code I have so far is:
Hi,
Can anybody help. I'm new to VBA and coding. I have created Userforms to control data. I have created a code that will insert data into a table but stumped as to how to sort that code so it appears in an ascending order. The code I have so far is:
VB:
Code
Private Sub cmdSave_Click()
'
' Send data to Specific Table'
'
Dim IrCD As Long
IrCD = Sheets("Data").Range("D" & Rows.Count).End(xlUp).Row
Sheets("Data").Cells(IrCD + 1, "D").Value = Textbox1.Text
Can anybody advise how I change this code to allow sorting?
Cheers
Can anybody advise how I change this code to allow sorting?
Cheers