+ Reply to Thread
Results 1 to 2 of 2

What is the variable 'vbyes' classified as?

  1. #1
    Registered User
    Join Date
    07-10-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    77

    What is the variable 'vbyes' classified as?

    Whenever a message box returns a yes or no, it's really returning an integer 6 for yes or 7 for no. However, I originally thought that it was literally just returning a special variable thats only value was vbyes or vbno. Does MSDN have a name for an intrinsic variable that holds an integer value?

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: What is the variable 'vbyes' classified as?

    vbYes and vbNo are VBA constants, you'll find all the constants listed in the Object Browser (F2).
    If posting code please use code tags, see here.

+ 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. VBA MsgBox with vbYes and vbNo
    By sswcharlie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-08-2015, 06:34 PM
  2. [SOLVED] Return to InputBox based on Value AND vbYes/No
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-18-2012, 11:44 AM
  3. Replies: 8
    Last Post: 07-07-2011, 02:18 AM
  4. [SOLVED] MsgBox, VBYes, VBNo
    By Richard in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2006, 01:35 PM
  5. Return column to row classified by parent
    By dorlan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2005, 02:29 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