+ Reply to Thread
Results 1 to 2 of 2

VBA code to copy data from Excel data table to user form

  1. #1
    Registered User
    Join Date
    01-03-2011
    Location
    Bangalore, India
    MS-Off Ver
    MS Excel 2010
    Posts
    49

    VBA code to copy data from Excel data table to user form

    Hello,

    I have created an user form named Userform1. This form has ComboBox1, ComboBox2, TextBox1 and TextBox2. Upon clicking save button on the user form, data get saved in the next available row in work sheet named ViewData from column C to column F

    Now, I have 2 more command button added to the Userform1. 1 button to retrive data from the lastrow of the table and move backwards, but not able to write a correct syntax.
    Can any one assist me in writing a macro for the navigation command button.
    Thanks!
    Srikanth

  2. #2
    Spammer
    Join Date
    09-07-2011
    Location
    Vancouver
    MS-Off Ver
    Excel 2003-2007-2010
    Posts
    5

    Re: VBA code to copy data from Excel data table to user form

    Hi,

    It should be the reverse from your other code.

    Something like this :

    me.combobox1.value = range("A23")


    Regards

    Gaetan
    Last edited by Paul; 08-22-2014 at 12:43 PM. Reason: Removed advertising link

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Require VBA code to Get data from data table to user form using command button
    By Srikanth H N in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-01-2014, 04:17 PM
  2. VB Code to Capture Data from User Form
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2012, 12:33 PM
  3. [SOLVED] Cant Modify Data with User Form - Help with code!
    By eddyvilla in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-28-2012, 11:38 AM
  4. Can't write code to find last data row in excel user form
    By stevegrobertson in forum Excel General
    Replies: 8
    Last Post: 02-24-2012, 10:16 PM
  5. [SOLVED] Writing data table to user form
    By Mitch in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2005, 01: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