Results 1 to 7 of 7

Thread: ***RESOLVED*** Data type conversion error

Threaded View

  1. Jul 25th, 2002, 04:38 PM #1
    Jefftopia
    Jefftopia is offline

    Thread Starter
    Addicted Member
    Join Date
    Jun 2002
    Location
    Sunny Scottsdale Arizona
    Posts
    254

    ***RESOLVED*** Data type conversion error

    I need to be able to divide two currency values in an MSFlexGrid to come up with a percent value.

    The challenge is that I need to have error handling to be sure that if the user puts in a $.0 currency value I do not get an error.

    Ex.

    Private Sub MSFlexGrid1_LeaveCell()

    With MSFlexGrid1
    .TextMatrix(1, 1) = Format(.TextMatrix(2, 1) / .TextMatrix(3, 1), "0.0%")
    End With

    End Sub
    Last edited by Jefftopia; Jul 26th, 2002 at 09:07 AM.
    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