Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform
Thanks a ton !!! On 8/20/13, De Premor d...@premor.net wrote: paste this on userform1 ' Dim Target As Range Private Sub CommandButton1_Click() Target.Offset(1).Select Unload Me End Sub Private Sub TextBox1_Change() Target = TextBox1.Text End Sub
Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform
paste this on userform1 ' Dim Target As Range Private Sub CommandButton1_Click() Target.Offset(1).Select Unload Me End Sub Private Sub TextBox1_Change() Target = TextBox1.Text End Sub Private Sub UserForm_Activate() Set Target = Selection TextBox1.Text =