+ Reply to Thread
Results 1 to 6 of 6

Can't get my case argument to activate?

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Can't get my case argument to activate?

    Hi,

    This code is supposed to put an error reading in textbox14 when the value of 380 is more than the contents of textbox9 and combobox16 says"IMEMA001"
    The problem is the error reading is popping up premeturely when combo box 16 displays "IMEMA001" before I've even addressed text box 9's contents? Help!



    Please Login or Register  to view this content.
    Last edited by bralew; 10-27-2016 at 03:21 AM.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How do I fix this simple case???

    Please take a few minutes to re-read the forum rules about thread titles, then amend yours accordingly.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: How do I fix this simple case???

    Wouldn't you want to test this in the TextBox9_Change procedure?

    And add a condition that TextBox9 is not empty.

    I don't fully understand what you're doing, but maybe something like this...
    Please Login or Register  to view this content.
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.

  4. #4
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How do I fix this simple case???

    Thanks, I'll give it a whirl, thanks

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: How do I fix this simple case???

    Aww Thanks, it works, really saved my bacon. Thank you ever so much

  6. #6
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,643

    Re: How do I fix this simple case???

    You're welcome.

    Don't forget to fix the title.

+ 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. Replies: 1
    Last Post: 07-14-2016, 05:51 AM
  2. [SOLVED] Lower Case to Upper Case but No Auto Correction : Solved by Mod (6StringJazzer)
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-27-2014, 10:44 AM
  3. Write a subroutine in a module to change case upon exit of a cell to upper case
    By Stephd22 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-15-2013, 06:39 PM
  4. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  5. Replies: 2
    Last Post: 06-18-2012, 11:37 AM
  6. Replies: 2
    Last Post: 12-09-2005, 05:15 AM
  7. Excel should have a quick and simple "change case" function like .
    By NinaSvendsen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-28-2005, 02:06 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