+ Reply to Thread
Results 1 to 5 of 5

Text Box's after-update property does not allow to delete existing populated value

  1. #1
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Text Box's after-update property does not allow to delete existing populated value

    • I have a text box in a USERFORM .
    • Have the following code associated with the text box. (which helps perform basic arithematic… eg. If engineers wanna key in 39+137, instead of 176.)


    Please Login or Register  to view this content.
    When I run the userform, the userform’s INITIALIZE procedure populates the textbox with value from a cell in the spreadsheet. When I delete the value completely , it gives error almost instantaneously

    Error is "Could not set the value property. Type Mismatch"
    Last edited by subbby; 05-14-2014 at 03:39 PM. Reason: Solved

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Text Box's after-update property does not allow to delete existing populated value

    Could that be because when you delete the value in the textbox you leave an empty string and Evaluate("") is returning an error?
    Please Login or Register  to view this content.
    Last edited by Norie; 05-14-2014 at 03:36 PM.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Text Box's after-update property does not allow to delete existing populated value

    Quote Originally Posted by Norie View Post
    Could that be because when you delete the value in the textbox you leave an empty string and Evaluate("") is returning an error?

    Absolutely YES... let me try this..

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Text Box's after-update property does not allow to delete existing populated value

    Oops, there was a typo.

    I had .ValueText, it should be just .Value - I've edited the post.

  5. #5
    Forum Contributor
    Join Date
    08-24-2012
    Location
    Hollidaysburg, Pa
    MS-Off Ver
    Excel 2010
    Posts
    398

    Re: Text Box's after-update property does not allow to delete existing populated value

    Oh okie!! that works Forum guru ! Thanks !

+ 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. VBA Tag property. Retrieve data into form and update existing row
    By djm601 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2014, 11:28 AM
  2. Replies: 4
    Last Post: 05-27-2013, 10:01 AM
  3. update with last populated cell
    By FindAnswers in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-22-2012, 09:04 AM
  4. Automatically update existing data using a Update command button
    By 9999335 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 09:46 PM
  5. how to add a constant prefix to an existing list of populated cells
    By brit6400 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-23-2010, 03:11 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