i cant format textbox as number!

[barkiny]

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!

[Toppers]

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
>
>