+ Reply to Thread
Results 1 to 5 of 5

IsBlank function run on form will not allow initial save of bank value to send to users

  1. #1
    Registered User
    Join Date
    08-14-2013
    Location
    Kentucky, United States
    MS-Off Ver
    03,07,10
    Posts
    61

    IsBlank function run on form will not allow initial save of bank value to send to users

    I have the following code to prevent users from being able to save the form blank to send. However I need to be able to send the user a blank form innitially I can not figure out how to do this, Please advise.

    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    04-24-2007
    Location
    NYC
    MS-Off Ver
    2k3/2k7/2010
    Posts
    270

    Re: IsBlank function run on form will not allow initial save of bank value to send to user

    Disable macros before opening this file. Then fix your code, and save.

  3. #3
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: IsBlank function run on form will not allow initial save of bank value to send to user

    Hi lengwer,

    To iniitialize your data try the following in an ordinary code module such as 'Module1':
    Please Login or Register  to view this content.

    Your routine checks for empty cells, but does not check for cells that contain blanks and no other characters. I added 'MyIsEmpty()' to replace 'IsEmpty()'.

    MyIsEmpty():
    a. Checks for empty cell
    b. Checks for cell that contains only spaces (BLANKS)
    c. Removes leading and trailing spaces from non-BLANK cells

    Please Login or Register  to view this content.
    Lewis

  4. #4
    Registered User
    Join Date
    08-14-2013
    Location
    Kentucky, United States
    MS-Off Ver
    03,07,10
    Posts
    61

    Re: IsBlank function run on form will not allow initial save of bank value to send to user

    Thank you all for the information (Sorry for spelling errors in advance). I did figure out the issue myself. I also concatenated the msgbox to contain all of the errors at once. I created the following code to cover three scenarios:

    1. Will save if all fields are null
    2. Will not save if one or more of the required fields are null
    3. Will save if all fields required are completed.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    08-14-2013
    Location
    Kentucky, United States
    MS-Off Ver
    03,07,10
    Posts
    61

    Re: IsBlank function run on form will not allow initial save of bank value to send to user

    I will definitly change the code to reflect the MyIsEmpty() rather than the IsEmpty(). I can see where this would benifit. Thank you again for the information and the quick responses.

+ 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. Disable save function for users
    By Barry Engelbrecht in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 07-09-2013, 09:36 AM
  2. Initial Combobox blank value in a Form is Null
    By Paulo Buchsbaum in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2012, 11:50 AM
  3. disable save & send function
    By wetph00t in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2012, 04:24 PM
  4. Help with ISBLANK function referring to a cell with another ISBLANK formula
    By camdameron in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-23-2011, 12:45 PM
  5. Form function to save worksheet
    By jcarstens in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2009, 06:05 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