+ Reply to Thread
Results 1 to 3 of 3

Warning message. And changing data without close message.

  1. #1
    Registered User
    Join Date
    01-25-2013
    Location
    seville
    MS-Off Ver
    Excel 2007
    Posts
    16

    Warning message. And changing data without close message.

    Hi everyone!!!

    I'm trying to make one application wich look for wrong data and, if those exist, give me a message in such way the user could change them. When the user changes the wrong data the macro should continue the execution by the next step.
    My first idea was make it with a msgbox, but it don't allow to modify data in excel sheets. so, I'm trying make it with a form. I program this form with showmodal=False in that way the user will be able to change the sheets data, but the problem is the macro continues the execution, generating errors.

    So... here I am. I don't know how solve this problem. anyone have an idea?

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-31-2012
    Location
    Jhang, Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    250

    Re: Warning message. And changing data without close message.

    Try using Inputbox to get new input data in case of errors.

  3. #3
    Registered User
    Join Date
    01-25-2013
    Location
    seville
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Warning message. And changing data without close message.

    Thank you for you interest

    But isn't the solution cause maybe I have to introduce data from other sheets or change values of other cells... And inputbox don't allow changes in sheets contents neither.

    Maybe is not possible

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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