Userform Textbox input value comparison?

**VAer** · 03-14-2017, 11:42 AM

Please Login or Register  to view this content.

Very strange, if TextBoxA.Value = "999" and TextBoxB.Value="2000", it can meet the condition.

Is it because the program treat it as string, not number? How to convert them to numbers?

Thanks.

**YasserKhalil** · 03-14-2017, 11:43 AM

You can use VAL function in this way

Please Login or Register  to view this content.

Userform Textbox input value comparison?

LinkBack

Thread Tools

Rate This Thread

Display

Userform Textbox input value comparison?

Re: Userform Textbox input value comparison?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Userform Textbox will not allow capital letters after first letter input

[SOLVED] Pass Value of combobox selected in Userform as input to textbox of other userform

input the value of a Combobox and a textbox to a TEXTBOX directly from a userform

[SOLVED] populate userform listbox from textbox input

Calculation based on input from userform textbox

Use textbox input and VLookup to update another textbox on same userform

Userform Textbox to input data to worksheet

[SOLVED] checking input on a textbox in userform to be a %

Bookmarks

Bookmarks

Posting Permissions