i cant format textbox as number!
 

file is simple
i want to sort the data given particular criteria

from start menu i choose top
than i choose greater than
then to the text box i write 4

but the code recognize the 4 as "4" (text)
so hide all the rows
(but i want hide the row if it is less than 4, or show if it is 4
or above)

please hlp i am not going any further!


+-------------------------------------------------------------------+
|Filename: dnm.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3612 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=389184

i cant format textbox as number!
 

Hi,

This works for me:

If Cells(b, kolonsayisi).Value <= CInt(UserForm1.TextBox1.Value) Then
Rows(b).EntireRow.Hidden = True


HTH

"barkiny" wrote:


file is simple
i want to sort the data given particular criteria

from start menu i choose top
than i choose greater than
then to the text box i write 4

but the code recognize the 4 as "4" (text)
so hide all the rows
(but i want hide the row if it is less than 4, or show if it is 4
or above)

please hlp i am not going any further!


+-------------------------------------------------------------------+
|Filename: dnm.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3612 |
+-------------------------------------------------------------------+

--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=389184