+ Reply to Thread
Results 1 to 4 of 4

Yes/No question chart

  1. #1
    Registered User
    Join Date
    06-04-2018
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    54

    Yes/No question chart

    Dear All

    I wan't to program a yes/no question chart in vba.

    if answer is yes, go to next question. if answer is no, go to another question...

    I've made something with msgbox's (vbYes, vbNo, vb Cancel). but I wan't to highlight some sentenses in the question. I think this is not possible with a msgbox.
    therefore I wan't to make a userform that I can use like a '"msgbox".

    and there it stops for me :D

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,642

    Re: Yes/No question chart

    Sure,
    You can use Userform instead of msgbox.
    It's for sure more work, but you will have a control over fonts, colors etc.

    See for example such thread: https://www.mrexcel.com/board/thread...ge-box.926850/

    Or may be this would even better suit your needs: https://www.excelforum.com/excel-pro...-userform.html

    If it's not enough - consider the tip displayed in yellow banner near the top of the page
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    06-04-2018
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Yes/No question chart

    Dear Kaper

    See attached my workbook.

    If I doubleclick on a cell in column A (Sheet1), the chart starts (classic msgbox)
    In VBA you can see the userform that I wan't to use.

    Sheet Chart is the question chart I need to follow.

    Samet
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    06-04-2018
    Location
    Belgium
    MS-Off Ver
    Office 2013
    Posts
    54

    Re: Yes/No question chart

    Can anybody help me please with this?

+ 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. N/A Question for Chart
    By Victor Li in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-07-2018, 05:51 PM
  2. Chart question
    By toocold in forum Excel General
    Replies: 2
    Last Post: 05-15-2009, 12:20 AM
  3. Chart question
    By styre in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 03-25-2009, 05:01 PM
  4. Chart Question and table question
    By nmss18 in forum Excel General
    Replies: 5
    Last Post: 03-17-2009, 08:52 AM
  5. Bar chart question
    By Avrilon in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-02-2007, 06:22 PM
  6. [SOLVED] chart question
    By Cowtoon in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2006, 09:00 PM
  7. [SOLVED] Another Chart Question
    By Donna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2005, 11:06 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