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
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.
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.
Dang! can anyone help me with this issue.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1