Results 1 to 10 of 10

Find the last cell with value in column E and Send value of textbox to the same row in col

Threaded View

MariaPap Find the last cell with value... 12-24-2013, 10:12 AM
Sadath31 Re: Find the last cell with... 12-24-2013, 10:25 AM
MariaPap Re: Find the last cell with... 12-24-2013, 10:52 AM
xlbiznes Re: Find the last cell with... 12-24-2013, 10:59 AM
MariaPap Re: Find the last cell with... 12-24-2013, 11:06 AM
moonsaga Re: Find the last cell with... 12-24-2013, 11:39 AM
MariaPap Re: Find the last cell with... 12-24-2013, 11:52 AM
moonsaga Re: Find the last cell with... 12-24-2013, 11:59 AM
MariaPap Re: Find the last cell with... 12-24-2013, 12:11 PM
moonsaga Re: Find the last cell with... 12-24-2013, 12:15 PM
  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Find the last cell with value in column E and Send value of textbox to the same row in col

    Hello

    I use this code for transfer data from a User form in sheet DataBase, column E.

    Private Sub CommandButton1_Click()
    
    Dim i As Integer
    Dim lRow As Long
    For i = 1 To 4
        If Me.Controls("ComboBox" & i).Value = True Then
            With Sheets("DataBase")
                lRow = .Range("e" & .Rows.Count).End(xlUp).Offset(1).Row
               .Range("e" & lRow).Value = Me.Controls("ComboBox" & i).Value
                
            End With
        End If
    Next i
    End Sub
    My goal is to send the value of textbox1, in sheet DataBase, column L, in the last row that exist data in column E.

    So if column E has data until row 6, then value of textbox must tranfered in L6.

    Thanks in advance for any assistance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Find duplicated cell, with certain condition and send mail under the same address.
    By EugeneE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2013, 11:49 PM
  2. [SOLVED] find the highest value in a column and in a textbox
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-13-2013, 11:42 AM
  3. Using an Option Button to send a textbox value to a cell
    By JChaney17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2013, 11:24 PM
  4. Replies: 2
    Last Post: 05-18-2012, 12:34 AM
  5. Find from Textbox and Paste into Cell on sheet one
    By Mark Cover in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-05-2005, 10:05 AM

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