Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Howdy all. How the hell do I do this!

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I have a userform which pops up from a worksheet when I click a button. It has a textbox and a combobox, and a command button on it. All I need to know is, when I've filled in the textbox and the combobox, I want to push the command button, which unloads the form and places the textbox's answer into the cell in Column K in whichever row I'm in, and the same for the combobox but in column J. So basically, I need to know what the code is to put the answer from the two boxes into K and L of whatever row I'm in

    Can anyone help?

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try


    Private Sub CommandButton1_Click()
    Cells(ActiveCell.Row, 11) = Textbox1
    Cells(ActiveCell.Row, 12) = Combobox1
    Unload Me
    End Sub

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Superb Dave, thank you very much!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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