+ Reply to Thread
Results 1 to 2 of 2

Converting to number error checking

  1. #1
    Forum Contributor
    Join Date
    01-03-2016
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016
    Posts
    125

    Converting to number error checking

    I'm trying to "track" (recording a macro) this error check that converts this "text" to a number, but it won't track anything (literally blank).
    It says the data in that cell is a text, but I don't know what to do, except, making "TextBox1.Text" to "TextBox1.Value".

    ps: I wanted to track so I could make it a number, make the calculations and then make it a currency again
    ps2: You can see it on Worksheet("January").Range("C77")

    This is my workbook (as I can't upload files larger than 1000kb, I'm linking my dropbox link below:
    https://www.dropbox.com/s/l3gzfibg6a...0dev.xlsm?dl=0

    Error checking instructing me to convert into number (but, once I can't track, how it does it?):
    bad5603.png

  2. #2
    Forum Contributor
    Join Date
    01-03-2016
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016
    Posts
    125

    Re: Converting to number error checking

    All I had to do was make "TextBox1.Text" into CCur(TextBox1.value). This CCur converted the value in TextBox1 to currency.

+ 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] Error checking routine - check range values on various worksheets and report if error
    By TheRobsterUK in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-29-2014, 06:36 AM
  2. Replies: 2
    Last Post: 02-18-2013, 10:17 AM
  3. [SOLVED] Error checking
    By kello99 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-05-2012, 09:34 AM
  4. Error Checking
    By dshilan in forum Excel General
    Replies: 1
    Last Post: 11-05-2010, 02:18 PM
  5. error checking
    By ghadir14 in forum Excel General
    Replies: 6
    Last Post: 10-15-2007, 06:44 PM
  6. Error Checking - Convert to Number
    By dbarelli in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-16-2006, 10:57 AM
  7. Error Checking
    By mworth01 in forum Excel General
    Replies: 1
    Last Post: 05-18-2006, 03:50 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