+ Reply to Thread
Results 1 to 7 of 7

VBA guide/template for a beginner, user form

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    Manchester
    MS-Off Ver
    Excel
    Posts
    7

    VBA guide/template for a beginner, user form

    Hi guys,
    Does anybody know where i can find a good guide or template for creating a very simple vba form for inputting data that will then be displayed into a spreadsheet table?
    I have searched google and youtube and although there are guides for doing this, they are all about specific tasks such as animal species etc.
    When i try to do the same but change the questions to suit my needs i end up recieving error messages such as object required
    Any help would be greatly appreciated
    TIA

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: VBA guide/template for a beginner, user form

    If you describe what you want, we can help you build it while explaining what we are doing.
    I'm interested in starting a career working with VBA, if anyone knows of any opportunities!

  3. #3
    Registered User
    Join Date
    04-27-2016
    Location
    Manchester
    MS-Off Ver
    Excel
    Posts
    7

    Re: VBA guide/template for a beginner, user form

    Hi thankyou very much,
    i am trying to create a form similar to this
    Mock Up Form.png
    And so the data collected will then be input to a table similar to this
    Table.png
    I understand that the table/ form may need altering slightly to be cohesive, and i also understand that this is a fairly simple task that may not need a vba function however i have to do it with vba
    Thankyou for taking the time to read this and reply
    any more questions please feel free to ask

    P.S. I understand drop down boxes may be easier for this than check boxes in the form, is this correct?
    Last edited by Odowd; 04-28-2016 at 11:37 AM.

  4. #4
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: VBA guide/template for a beginner, user form

    I understand drop down boxes may be easier for this than check boxes in the form, is this correct?
    Those aren't check boxes, there option buttons, and they're a suitable and easy method for this application.

    See attached worksheet. I didn't try super hard on the formatting/look of the user form because, well, you're getting this for free. You can play with the formatting all you want.

    Please ask any questions you have, I don't want to take the time to explain how everything works, I'd rather just explain the things you don't understand. Also, it looks like your price column has a formula in it, you can either add the formula into the column in the attached, or show what the formula is, and I can incorporate it into the code. Either way is fine.

    For posterity, the code is also below, though you don't need to do anything with it; it's already in the userform.

    Odowd.xlsm

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    04-27-2016
    Location
    Manchester
    MS-Off Ver
    Excel
    Posts
    7

    Re: VBA guide/template for a beginner, user form

    Thank you so much for helping me here, i am just about to try it now
    i really appreciate your help

  6. #6
    Registered User
    Join Date
    04-27-2016
    Location
    Manchester
    MS-Off Ver
    Excel
    Posts
    7

    Re: VBA guide/template for a beginner, user form

    I cant thankyou enough Walruseggman that is perfect

  7. #7
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: VBA guide/template for a beginner, user form

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

    And any reputation points (the * in the lower left of the posts) are appreciated.

+ 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. Creating a User Form Template with Dynamic fields
    By squidpop in forum Excel General
    Replies: 1
    Last Post: 01-23-2016, 03:21 PM
  2. Excel Guide - Beginner to Intermediate
    By legento in forum Tips and Tutorials
    Replies: 0
    Last Post: 02-16-2015, 03:09 AM
  3. Replies: 1
    Last Post: 08-12-2014, 03:05 AM
  4. Guide to creating an Excel Order Form
    By balawton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-08-2013, 10:42 AM
  5. [SOLVED] Definitive Guide to User Forms
    By Nicole Seibert in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-26-2006, 09:35 AM
  6. Copying template to workbook but user form does not copy?
    By Alan Ibbotson in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2005, 07:10 PM
  7. VBA Beginner: Help with Checkboxes on created User Form
    By MarianneR in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-12-2005, 11:05 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