+ Reply to Thread
Results 1 to 5 of 5

Excel VBA userform

  1. #1
    Registered User
    Join Date
    07-27-2016
    Location
    Liverpool, England
    MS-Off Ver
    2010
    Posts
    6

    Excel VBA userform

    Hi

    Not done much programming however I thought to try and teach myself I mainly due Desktop and Server Maintenance.

    My boss has asked my to build a userform which I have done with option buttons and checklists however he now wants it to have next buttons

    So basically the user selects an option button which then they click next to get to the next question set.

    What I need my userform to do is act as a wizard for Recovery of a vehicle

    So the first question would be who is calling and the user would select either policy holder or third party, so after they have answered this they would need to click next and then another question would require user input.
    Last edited by redstar81; 07-27-2016 at 08:48 AM.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Excel VBA userform

    Create a list of questions on one of your worksheets, along with an area for all the options for the buttons and checklists on your userform. And have an area for each set of responses.

    Then, use the code for your "Next" button to
    1) store the answer(s) to the current question in your database of responses
    2) clear the answer area and reset all controls
    3) change the question to the next one on the list
    4) change option buttons and checklist values and visibility etc to correspond to the what is needed for the next question.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Registered User
    Join Date
    07-27-2016
    Location
    Liverpool, England
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel VBA userform

    Thank you

    So just to get an understanding so for example Cell A1 would be one question and then Cell B1 would be its answer, or would all questions be in Cell A going down and the answers would be in Cell B.

    Would you be able to give me an example of the code for the next

  4. #4
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,912

    Re: Excel VBA userform

    This gives an example of what I described.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-27-2016
    Location
    Liverpool, England
    MS-Off Ver
    2010
    Posts
    6

    Re: Excel VBA userform

    Excellent is what is needed

    As I said am new to this and so thank you

+ 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. Excel Resources - UserForm vs Non-UserForm
    By DHFE in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2015, 06:26 AM
  2. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-04-2014, 07:11 AM
  3. [SOLVED] Excel 2007, Userform Textbox Date Format and Calendar Control Userform
    By riffology in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2014, 06:18 PM
  4. combining chart userform and data transfer userform into 1 userform
    By H_Kennedy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-03-2014, 12:28 PM
  5. [SOLVED] Excel vba userform - lock userform in place
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 04-30-2013, 10:30 AM
  6. [SOLVED] Open a userform from a userform, but preserve the info in the original userform
    By jfoerch in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2013, 02:38 PM
  7. [SOLVED] EXCEL USERFORM- pull data from sheet 1 into userform
    By PANTECH in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2013, 11:10 AM

Tags for this Thread

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