+ Reply to Thread
Results 1 to 2 of 2

Evaluate Userform entry as a formula

  1. #1
    Registered User
    Join Date
    02-27-2013
    Location
    Manchester, Ct.
    MS-Off Ver
    Excel 2010
    Posts
    2

    Evaluate Userform entry as a formula

    I need to know if there is a way to evaluate a Userform.textbox entry as a formula? For example, for a length field in a Userform the customer could enter 24 or 12*2 and either way it would evaluate to 24. Entering =12*2 would also be acceptable. I just would like for them to be able to use the input field to do calculations for convenience. I would like to be able to do this without putting the data as a string into a cell and then evaluating it. It would be preferable to "evaluate" it right within the VBA code. Thanks in advance for any help!

  2. #2
    Registered User
    Join Date
    02-27-2013
    Location
    Manchester, Ct.
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Evaluate Userform entry as a formula

    Soooo.... I seem to have answered my own question:

    DimensionString = Evaluate(Me.Rail_Length.Value)

    Works like a charm!

+ 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] After userform entry require tab entry
    By Tiger20 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2013, 12:24 AM
  2. Replies: 2
    Last Post: 07-09-2012, 02:05 AM
  3. Evaluate formula
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-08-2011, 06:49 AM
  4. Evaluate Sub-formula Only Once
    By djk in forum Excel General
    Replies: 3
    Last Post: 12-16-2010, 06:10 AM
  5. [SOLVED] Evaluate formula using VBA
    By Ali Baba in forum Excel General
    Replies: 0
    Last Post: 08-16-2005, 08:05 PM

Tags for this Thread

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