Numeric Textbox that accepts negative sign (-)

**Axmed.cm** · 08-02-2015, 02:56 AM

Hi Everyone.

Can anyone help me have a code for a numeric textbox that accepts minus (negative) sign.
Thanks in advance.

**evertjvr** · 08-02-2015, 03:18 AM

If you are reffering to a textbox in a form - ALL textboxes are always text and as such will accept all value if you want to use the data within as numbers you will need to convert it to one of the number formats
ie:

Please Login or Register  to view this content.

**Axmed.cm** · 08-02-2015, 03:45 AM

Thanks for your reply.

it is in userform.
I used this code

Please Login or Register  to view this content.

but unfortunately it also rejects negative values.
is there any solution to accept it??

thanks

**Andy Pope** · 08-02-2015, 05:44 AM

add some additional checks

Please Login or Register  to view this content.

Numeric Textbox that accepts negative sign (-)

LinkBack

Thread Tools

Rate This Thread

Display

Numeric Textbox that accepts negative sign (-)

Re: Numeric Textbox that accepts negative sign (-)

Re: Numeric Textbox that accepts negative sign (-)

Re: Numeric Textbox that accepts negative sign (-)

Thread Information

Users Browsing this Thread

Similar Threads

TextBox that only accepts integers

Multiplying a numeric value textbox by a duration value textbox

One Input Data Table, how to remove negative sign when referencing a negative value

negative numbers w/o negative sign

Textbox accepts alpha only

[SOLVED] Automatically put negative sign in cells with positive numeric dat

TextBox that only accepts integers?

Bookmarks

Bookmarks

Posting Permissions