Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform combobox treating numbers as text
hello I have created a task planner userform with comboboxes as selectors fo week numbers. I have set the condition that the target completion wee combobox value must be greater than the start date combobox - howeve the combobox is treating the week numbers as text and therefore wee *1*2 is saying it is smaller than week 8 - I would assume that I woul have to set the format of the comboboxes in Userform Initialise sub t number format - can anyone tell me how I would do this -- apnda ----------------------------------------------------------------------- apndas's Profile: http://www.excelforum.com/member.php...fo&userid=3613 View this thread: http://www.excelforum.com/showthread.php?threadid=56226 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform combobox treating numbers as text
All values in combo/list/text boxes are text.
If you require numerical comparison, coerce to numbers first: If CLng(cboStartWeek.Value) .... NickHK "apndas" wrote in message ... hello I have created a task planner userform with comboboxes as selectors for week numbers. I have set the condition that the target completion week combobox value must be greater than the start date combobox - however the combobox is treating the week numbers as text and therefore week *1*2 is saying it is smaller than week 8 - I would assume that I would have to set the format of the comboboxes in Userform Initialise sub to number format - can anyone tell me how I would do this. -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=562265 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform combobox treating numbers as text
Thanks Nick Appreciate your help Regards darren -- apndas ------------------------------------------------------------------------ apndas's Profile: http://www.excelforum.com/member.php...o&userid=36137 View this thread: http://www.excelforum.com/showthread...hreadid=562265 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table treating numbers as text in value field | Excel Worksheet Functions | |||
2007 treating Text as a Number | New Users to Excel | |||
If Function Treating Answer as a Text Box and Not a Numeric Box | Excel Discussion (Misc queries) | |||
Excel treating text as function | Excel Programming | |||
Userform text & combobox population help required please | Excel Programming |