+ Reply to Thread
Results 1 to 2 of 2

Message boxes are coming after closing the user form

  1. #1
    Registered User
    Join Date
    03-06-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    95

    Message boxes are coming after closing the user form

    Hi,

    I am getting Message box when I closed the form after completion of the data entry. The message box which displayed after closing the form were given for validation checks. Example, BP is not more than 200 if user enter BP>200 the message will be displayed "Diastolic BP is not correct". This message box is coming after closing the form though we enter the BP<200 also. I was cross checked the entire code to find the issue but I am unable to find out where the issue and why that message box event firing after closing the form.

    I am uploading the file which I am facing the issue.

    Can anyone help me to solve this issue.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,304

    Re: Message boxes are coming after closing the user form

    It may or maybe not have a bearing on the problem.
    Your declaration of variables are by default 'Variant' type with the exception of 'bg As VbMsgBoxResult'.
    torachan.

+ 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. Populate text boxes on user form, from combo box on same user form
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 26
    Last Post: 07-03-2016, 09:35 AM
  2. If user doesn't open file...avoid from the Debug message coming up
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-12-2015, 02:18 PM
  3. [SOLVED] Warning message when closing form
    By PDBartlett in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-25-2014, 08:12 AM
  4. populating list boxes and combo boxes in a user form.
    By ahceinaej in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-10-2014, 11:54 AM
  5. User Form to check data before closing form
    By CityMPLSEmpolyee in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-15-2012, 12:42 PM
  6. Message populate while closing user form
    By rajeev.raj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-24-2010, 08:18 AM
  7. Replies: 1
    Last Post: 07-12-2006, 05:48 PM

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