Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform

2013-08-20 Thread Mangesh Vimay
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

2013-08-19 Thread De Premor
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 =