Results 1 to 2 of 2

Up date button in User form

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Post Up date button in User form

    Private Sub cmdUpdate_Click()
    Dim Currentrow as string
    Dim Sln As String, ANames As String, Aage As Integer, Asex As String, Adoa As String, APhone As String, AcomboBox As String
    Sln = SlNo.Text
    ANames = Names.Text
    Aage = Age.Value
    Asex = ***.Text
    Adoa = DOA.Text
    APhone = Phone.Text
    AcomboBox = ComboBox1.Text
    With ActiveSheet
    Cells(currentrow, 1).Value = Sln
    ANames = Names.Text
    Cells(currentrow, 2).Value = AName
    Aage = Age.Value
    Cells(currentrow, 3).Value = Aage
    Asex = ***.Text
    Cells(currentrow, 4).Value = Asex
    Adoa = DOA.Text
    Cells(currentrow, 5).Value = Adoa
    APhone = Phone.Text
    Cells(currentrow, 6).Value = APhone
    AcomboBox = ComboBox1.Text
    Cells(currentrow, 72).Value = AcomboBox
    End With
    End Sub


    SlNo Age , *** DOA.... are names of textBox

    Please modify it
    Last edited by ROY_Z; 01-14-2017 at 12:14 PM. Reason: Rule 3

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] OK button in user form
    By twckfa16 in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 09-22-2015, 05:40 PM
  2. [SOLVED] Button Counting on user form
    By QAChaska in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-15-2014, 03:21 AM
  3. [SOLVED] User Form - Hyperlink Button within a Form, to create a Link on a Designated Cell
    By Sinalk in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-27-2013, 07:29 AM
  4. VBA User Form - Linking Close Button and Cancel Button
    By nivassrii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-26-2011, 07:05 AM
  5. User Form button
    By lapot in forum Excel General
    Replies: 0
    Last Post: 06-07-2007, 06:06 AM
  6. [SOLVED] User form x button
    By Greg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-12-2006, 12:00 PM
  7. User Form Spin Button
    By Rebecca in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-24-2005, 05:06 PM

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