+ Reply to Thread
Results 1 to 4 of 4

userform condition if textbox is empty do nothing

  1. #1
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    userform condition if textbox is empty do nothing

    Hey guys, I want to set a condition so that when I dont have a value in some of my textboxes the cell values do not get replaced with 0. If lets say I have 10 textboxes and only one has a value only the cell linked to that textbox gets its value updated while the rest stay the same. Thanks.

    this is what i use to enter values
    Please Login or Register  to view this content.

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: userform condition if textbox is empty do nothing

    Does this do what you need?

    Please Login or Register  to view this content.
    BSB

  3. #3
    Forum Contributor
    Join Date
    07-22-2013
    Location
    Sibiu
    MS-Off Ver
    Excel 2007
    Posts
    114

    Re: userform condition if textbox is empty do nothing

    Yes. Thank you so much.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: userform condition if textbox is empty do nothing

    No problem. Happy to help

    Thanks for the rep point.

    BSB

+ 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. [SOLVED] Paste Userform textbox values into next empty cell on a sheet
    By dubcap01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-16-2015, 04:51 AM
  2. [SOLVED] Userform Textbox Preventing 0 and over 100 condition
    By calvinle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-24-2014, 09:57 AM
  3. [SOLVED] Userform Label visible if two textbox values meet condition
    By KK1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-20-2014, 01:57 AM
  4. [SOLVED] Checking for empty textbox and setfocus the empty textbox
    By subbby in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-23-2013, 02:49 PM
  5. Replies: 2
    Last Post: 01-05-2013, 12:42 AM
  6. Message Box if any of userform textbox are empty
    By Rey Ocampo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-16-2012, 02:42 PM
  7. UserForm textbox data to empty cells
    By RLWells in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-29-2012, 02:42 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