Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking input on a textbox in userform to be a %
Hi,
i have a textbox in a userform that is linked tot cell A1 of the spreadsheet. Cell A1 is defined as %. When the user starts the userform the textbox will show 0,04 corresponding to 4% in cell A1. However, if the userform is empty and the user types in 4 in the textbox, cell A1 will show 400%. how can i make sure that the input in a textbox will be seen as a percentage so that if the input is 4, cell A1 will show 4% ? thanks, Jean-Pierre -- Message posted via http://www.officekb.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform-Change textbox color and font based on input in other tex | Excel Programming | |||
Checking a userform for blanks | Excel Programming | |||
Input mask for userform textbox | Excel Programming | |||
Checking input for alphabet (i.e. words) | Excel Programming | |||
UserForm TextBox to ActiveSheet TextBox over 256 characters | Excel Programming |