+ Reply to Thread
Results 1 to 6 of 6

Can't clear my form???????

  1. #1
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Can't clear my form???????

    Hi can anyone shine some light on this. I get an error on the isolated line below when I execute my clear form VBA??


    Please Login or Register  to view this content.



    Please Login or Register  to view this content.

  2. #2
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Can't clear my form???????

    try this instead to kill the form

    Please Login or Register  to view this content.
    Please consider:
    Be polite. Thank those who have helped you.
    Click the star icon in the lower left part of the contributor's post and add Reputation. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Posting code between tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

  3. #3
    Forum Contributor IonutC's Avatar
    Join Date
    01-28-2016
    Location
    Bucharest, Romania
    MS-Off Ver
    Office 2019
    Posts
    486

    Re: Can't clear my form???????

    for more info

    https://msdn.microsoft.com/en-us/lib.../gg278823.aspx

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Can't clear my form???????

    You cannot subtract a value from an empty textbox. Perhaps use
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't clear my form???????

    cheers everyone, I'll give it a whirl now and get back to you

  6. #6
    Forum Contributor
    Join Date
    07-05-2016
    Location
    cardiff
    MS-Off Ver
    2010
    Posts
    787

    Re: Can't clear my form???????

    Hi xlnitwit, I pasted your line in and its worked fine. I had a message box come which I had forgotten about so I changed to "Clear Form" and its great , Thanks everyone

+ 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] Clear Form Control
    By mariannehislop in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-27-2014, 03:22 AM
  2. Unloading Form on clear contents
    By reggie1000 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2009, 11:10 AM
  3. [SOLVED] How do I clear a form without a button
    By Pam Field in forum Excel General
    Replies: 4
    Last Post: 07-11-2006, 01:35 PM
  4. [SOLVED] Clear all textboxes on a form ?
    By SpookiePower in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-26-2006, 12:10 PM
  5. How to clear items on a form?
    By Grd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-12-2005, 05:05 PM
  6. [SOLVED] How to Clear the form?
    By Pastor Andrew Alexander in forum Excel General
    Replies: 1
    Last Post: 02-07-2005, 07:06 PM
  7. use a macro to clear a form
    By Future Leader in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2005, 08:08 AM

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