+ Reply to Thread
Results 1 to 2 of 2

Cell Codes

  1. #1
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    132

    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.

  2. #2
    Forum Contributor
    Join Date
    08-28-2005
    Posts
    132
    Dang! can anyone help me with this issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1