+ Reply to Thread
Results 1 to 2 of 2

Userform to display Log data; add, edit data, and navigate between records help

  1. #1
    Registered User
    Join Date
    04-07-2015
    Location
    DC
    MS-Off Ver
    2012
    Posts
    5

    Userform to display Log data; add, edit data, and navigate between records help

    Hi,

    I'm very new to VBA and am in the second iteration of attempting to create a userform to control the data entry of a Log.
    I adapted the code from an old VBA book after failing from a previous version of the form.

    I need to navigate 100+ records, display the selected record in the form, allow the user to edit/add missing information, or allow a new record to be created. We are adding proposal number as our unique identifier (format 2012-11111). This code is exact from a book, but it wasn't working, so I added the worksheet reference and still no luck. There are so many ways to do this it's hard to pull it together in my own context.

    This form won't display the data at all. Any help is very much appreciated!!!

    Thanks in advance,
    Laurie

  2. #2
    Forum Expert skywriter's Avatar
    Join Date
    06-09-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    2,760

    Re: Userform to display Log data; add, edit data, and navigate between records help

    I'd be willing to help you, but you have a lot of data and code. So we could just take one problem at a time. Give me some specifics of one scenario in which you would use this form and then the exact result you would expect to see. In other words give me exact data to enter into which parts of your form, then which button would you push and what would you expect to see. The more details the better. If you give me generic things you want to do it will just cause me to have to study your code and try to figure out what you are trying to do and I don't want to do that. So help me to help you.
    Click the * Add Reputation button in the lower left hand corner of this post to say thanks.

    Don't forget to mark this thread SOLVED by going to the "Thread Tools" drop down list above your first post and choosing solved.

+ 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. Add/edit/delete records userform
    By kryt0n in forum Excel General
    Replies: 7
    Last Post: 09-10-2018, 11:49 AM
  2. userform to display data and edit it
    By robertogavilan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2014, 08:12 PM
  3. [SOLVED] Need userform to search and edit records
    By Damian37 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-30-2014, 03:16 PM
  4. UserForm : i need a userform to add data, delete data, edit data
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-08-2014, 01:59 AM
  5. Userform - next record button or scrollbar to navigate through records
    By KA123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-19-2008, 07:49 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