Results 1 to 3 of 3

Thread: Need VBA Code for Excel Problem?

Threaded View

  1. Mar 26th, 2005, 04:37 PM #1
    TheRobster
    TheRobster is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2004
    Location
    Right here
    Posts
    275

    Need VBA Code for Excel Problem?

    I'm creating an Excel application and sometimes, because of the figures I put into some of the worksheets, I get the error message "#VALUE!". This isn't a problem because I know why it does it, but rather than have it say "#VALUE!" I'd rather have it say something else, in this case the text string ">50yrs".

    Do I need to use VBA code to do this? I can't find a way of doing it just using the formula bar and inputting a formula.

    Thanks
    -Rob
    Last edited by TheRobster; Mar 26th, 2005 at 05:23 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width