ExcelBanter - Cell Codes

I have a code that allows me to insert columns into my sheet. The column
is inserted with a name on 'row 10' and the date on 'row 9'. I would
like to add a code to a worksheet that would allow me to add the name
from 'row 10' and the date from 'row 9' to a row in that worksheet.

I would like to have the code in a userform so that it would be
something like:

textbox1.text = (row 9 and row 10 of the 'CGS worksheet')
textbox2.text = Range ("balance" or "waits" of the active worksheet)
optionbutton1 = Range("waits").EntireColumn.Insert
Worksheets('activeworksheet').Cells(11, Range("waits").Column -
1).Formula = TextBox1.Value
Else
Range("balance").EntireColumn.Insert
Worksheets('activeworksheet').Cells(11, Range("balance").Column -
1).Formula = TextBox1.Value

Now I think the trickiest part of this is to get the different
instances of rows 9 and 10 into different rows.

so that:
textboxt1 = (a9) and (a10)
textbox3 = (b9) and (b10)
and so on.

Help me out this is like the last part of my project and I can't wait
to finish this damn thing.

Thanks for your support.

--
oberon.black
------------------------------------------------------------------------
oberon.black's Profile: http://www.excelforum.com/member.php...o&userid=26732
View this thread: http://www.excelforum.com/showthread...hreadid=471371