How to force cells to return n/a if left blank?

  • I think this is the same code you suggested before, the one that is giving me the "Run-time error 13: Type mismatch". I'm only able to fix it if I remove the "#" in "#N/A" and just use "N/A" instead. Which is ok for me but it shows "N/a" (with small "a") in cell C3 instead of the normal "N/A" in the other blank cells. Thanks

  • Hello,


    I should have explained more clearly the modification :



    Hope this explanation is clearer ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • OK I get it now, yes I just tried it again and it's already working. Thank you very much. Will try to work on the other features listed on my previous post. Thanks I really appreciate your assistance on this.

  • OK I get it now, yes I just tried it again and it's already working. Thank you very much. Will try to work on the other features listed on my previous post. Thanks I really appreciate your assistance on this.


    Glad you could fix your problem .. :wink:


    Thanks ... for your Thanks ... :smile:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    I'm back again. I'm trying to fix one of the features I'm working on this workbook. The tabbing In and Out of ComBoxes to make documentation much easier for the users. Right now the code below only works if I edit Cell E4 (Auth/Case#). If I skip and not edit E4, I'm able to Tab to ComboBox1 (Call Reason) but the ComboBox is not activated. The ComboBox is not activated if I skip it. I want to be able to Tab or hit Enter key from either Cells C4 (AMI#) or Cell E4 (Auth/Case#), with or without editing them and have the next ComboBox activated. I hope to also be able to tab in/enter to the ComboBox2 (Call Resolution).



    This is the code I have right now:


    If Not Intersect(Range("E4"), Target) Is Nothing Then
    ActiveSheet.CallReasons.Activate
    End If

  • Hello,


    In order to help you out ... could you please attach your latest updated file ... in order to better visualize the problem ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    Sorry .... but password protection ... is preventing from testing any possible improvements ... :roll:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hello,


    Thanks for your password free workbook ... :wink:


    Will take a look at your earlier remarks ... and your objective ...

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!