Results 1 to 14 of 14

A blank input to a InputBox (method) runs the alert of typing formula in a cell with error

Threaded View

Pete u\'Line A blank input to a InputBox... 06-04-2023, 03:43 PM
Keebellah Re: A blank input to a... 06-04-2023, 05:17 PM
Pete u\'Line Re: A blank input to a... 06-05-2023, 01:14 AM
Keebellah Re: A blank input to a... 06-05-2023, 02:05 AM
Pete u\'Line Re: A blank input to a... 06-06-2023, 01:40 AM
Keebellah Re: A blank input to a... 06-05-2023, 02:44 AM
Pete u\'Line Re: A blank input to a... 06-06-2023, 01:42 AM
ByteMarks Re: A blank input to a... 06-05-2023, 08:28 AM
Pete u\'Line Re: A blank input to a... 06-06-2023, 01:49 AM
Keebellah Re: A blank input to a... 06-05-2023, 10:56 AM
Pete u\'Line Re: A blank input to a... 06-06-2023, 01:51 AM
Keebellah Re: A blank input to a... 06-06-2023, 02:09 AM
Pete u\'Line Re: A blank input to a... 06-06-2023, 02:10 PM
Keebellah Re: A blank input to a... 06-06-2023, 03:00 PM
  1. #1
    Registered User
    Join Date
    12-21-2020
    Location
    Santa Oliva
    MS-Off Ver
    Excel 2003, Excel 2007, Excel(Mac) 2011
    Posts
    11

    Unhappy A blank input to a InputBox (method) runs the alert of typing formula in a cell with error

    Hi, everybody,
    I want a very simple InputBox, but I want it to be with the InputBox method, to validate the input as numeric and evaluate easyly when it is cancelled by the user. By the way, then I'll do one more validation to the input value, no problem with that.

    When I clic OK with nothing in the entry field of the InputBox dialog, I get the same alert you get when you type a formula which contains errors in a cell:
    "The formula you typed contains an error.
    • For information about fixing...
    • To get assistance in...
    • If you are not trying..."


    It supposed that a blanck entry will yield a 0-length string, perhaps a vbNullString. The variable getting the value is variant. Parameter "Type" is 1.
    I made trials with/without default value. And don't want to go to the InputBox function.
    Why the hell Excel-VBA thinks anyone is typing anything into a cell?

    Attached a sample to reproduce this behavior. Wondering to know from you guys what stupid mistake I'm doing.
    Thank you.
    Attached Files Attached Files
    Last edited by Pete u'Line; 06-05-2023 at 12:58 PM. Reason: typos, incorrect English: "I'm want" changed to "I want"

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Disable Typing/Paste/editing & Double click on locked cell without notification alert
    By abhinavbinkar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-19-2018, 05:14 AM
  2. [SOLVED] Clear Text Box after Input Error Alert
    By azheuer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2018, 11:40 PM
  3. [SOLVED] inputbox to select cells instead of typing cell locations
    By miyachow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-13-2013, 09:20 AM
  4. Cancelling an inputbox if blank input or cancel button is pressed
    By kathhying in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-01-2011, 12:07 PM
  5. Retain the state of an inputbox's default input for successive runs
    By MCCCLXXXV in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-05-2011, 10:02 AM
  6. [SOLVED] Formula expected end of statement error, typing formula into cell as part of VBA macro
    By DavidGMullins@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-20-2006, 03:05 PM
  7. [SOLVED] Type Mismatch Error when using InputBox Method
    By Anolan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-22-2005, 03:40 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