I need to know how I can write a code in vba to read if a textbox has a negative value. For example if textbox1.value = "-1" then msgbox "negative value". this is not only restricted to -1, it goes for any "-" value. Any help will be greatly appreciated!!! Thanks in advance.