Something like
![]()
With Worksheets(me.ComboBox1.Text) lngR = .Cells(.Rows.Count,"A").End(xlUp).Row + 1 .Cells(lngR,"A").Value = me.Textbox1.Text .Cells(lngR,"B").Value = me.Textbox2.Text End With
Something like
![]()
With Worksheets(me.ComboBox1.Text) lngR = .Cells(.Rows.Count,"A").End(xlUp).Row + 1 .Cells(lngR,"A").Value = me.Textbox1.Text .Cells(lngR,"B").Value = me.Textbox2.Text End With
Bernie Deitrick
Excel MVP 2000-2010
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks