+ Reply to Thread
Results 1 to 3 of 3

Message box option buttons not working....

  1. #1
    Registered User
    Join Date
    02-11-2014
    Location
    Central New York
    MS-Off Ver
    Excel 2010
    Posts
    18

    Message box option buttons not working....

    Hi All,

    I have a form with the following code:

    Please Login or Register  to view this content.
    My problem is that no matter which option button is selected, all I get is the results for Case 2 and then the vlookup doesn't work. So if the user wants to cancel and reenter a new clock number they have to close the form and manually reopen it.

    this was working until I decided I wanted a vbOKCancel instead of a VbOkOnly.

    What should I do?

    Thanks,

    Angelina

    PS I would love to upload a sample, however the uploader is not working for me.

    The best I can do is a link for OneDrive
    https://onedrive.live.com/?cid=B3C47...091AE166%21105

  2. #2
    Forum Contributor
    Join Date
    12-09-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    171

    Re: Message box option buttons not working....

    Hi,

    Try this...

    in the both vlookup functions instead of
    Please Login or Register  to view this content.
    use

    Please Login or Register  to view this content.
    Thanks,
    BP
    Like my answer, then click * below

  3. #3
    Registered User
    Join Date
    02-11-2014
    Location
    Central New York
    MS-Off Ver
    Excel 2010
    Posts
    18

    Re: Message box option buttons not working....

    thanks Satabp, but I get the same results....

+ 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. How can I insert multiple sets of option buttons (radio buttons) in Excel 2010?
    By mickwooduclan in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-25-2013, 10:01 AM
  2. [SOLVED] Disabling an Entire Frame with Option Buttons if other Option Buttons are not clicked.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-20-2012, 04:07 AM
  3. [SOLVED] Option Buttons with macro and working with 2 workbooks
    By Ren in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-26-2006, 03:15 PM
  4. cell message with option buttons
    By Rmagic in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-18-2005, 01:55 PM
  5. Replies: 1
    Last Post: 11-03-2005, 11:10 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