Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Everyone,
I am trying to put in a error trap with a MsgBox to check and see if a number that is input into a TextBox is NOT a valid number. The TextBox input is for a Wind Direction such as 040 degrees, OR 180 degrees. Now, since the direction of the wind is only valid for 360 degrees in a circle, is there a way to ensure the number they input meets the criteria for a degree. Example: If they put in the number 36, my wind formula will not calculate the correct wind correction angle from the runway. The wind direction MUST be 360 to calculate properly. Can I do a error routine to ensure that?? Thanks in Advance... mv PS: Tom... your my man! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do i circle a number? | Excel Discussion (Misc queries) | |||
How do I make circle within circle graphs in Excel 2003? | Charts and Charting in Excel | |||
How do I circle a number in excel | Excel Worksheet Functions | |||
In Excel, how can I type a number with a circle around it? | Excel Worksheet Functions | |||
How circle an individual number in a cell? | Excel Worksheet Functions |