Results 1 to 12 of 12

Userform Textbox to populate with

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-18-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    127

    Userform Textbox to populate with

    Hi. There's a couple of Userforms i'm working on that appear one after the other, but which I'm having problems with. Hopefully someone can help.

    Userform1 is a basic search and find using the text the user enters in a text box, followed by 'ok' commandbutton.

    If a matching cell is found in the worksheet, the row is selected and the second userform asks for text via textbox2. This text will be placed in the end column of that row (column L) that was found to have the text input in Userform 1.

    What's important is that if on that row some text already exists in column L, that this appears in textbox2 allowing the user to modify it.

    I'm ok with the search and find :

    Private Sub Commandbutton1_Click()
        Cells.Find(What:=TextBox1, After:=ActiveCell, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
            False, SearchFormat:=False).EntireRow.Select


    But can anyone help with how I do the rest?

    Jules
    Last edited by Julesdude; 02-10-2010 at 12:06 PM.

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