ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   modify a line code (https://www.excelbanter.com/excel-discussion-misc-queries/189753-modify-line-code.html)

TUNGANA KURMA RAJU

modify a line code
 
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'

Stefi

modify a line code
 
Try
If.me.TextBox2.value < "textstring"
Regards,
Stefi


€˛TUNGANA KURMA RAJU€¯ ezt Ć*rta:

how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'


Bob Phillips

modify a line code
 
If.Me.TextBox2.Text < "textstring" Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TUNGANA KURMA RAJU" wrote in
message ...
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'




TUNGANA KURMA RAJU

modify a line code
 
Thank you Bob,
after a long time i met u today.
thank you

"Bob Phillips" wrote:

If.Me.TextBox2.Text < "textstring" Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TUNGANA KURMA RAJU" wrote in
message ...
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'





TUNGANA KURMA RAJU

modify a line code
 
Sorry Bob,
Its not working,i have entered text in textbox2 ,the validation logic is not
working.Why?

where I am wrong
"Bob Phillips" wrote:

If.Me.TextBox2.Text < "textstring" Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TUNGANA KURMA RAJU" wrote in
message ...
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'





TUNGANA KURMA RAJU

modify a line code
 
My question is wrong,i want code for
If textbox2 does not contain any text,then...

"Bob Phillips" wrote:

If.Me.TextBox2.Text < "textstring" Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"TUNGANA KURMA RAJU" wrote in
message ...
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'





Bob Phillips

modify a line code
 
If.Me.TextBox2.Text < "" Then

Met me? How?


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"TUNGANA KURMA RAJU" wrote in
message ...
My question is wrong,i want code for
If textbox2 does not contain any text,then...

"Bob Phillips" wrote:

If.Me.TextBox2.Text < "textstring" Then


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my
addy)



"TUNGANA KURMA RAJU" wrote
in
message ...
how to modify this line of code
If.Me.TextBox2.value < VbNullString
modify this line to
If.me.TextBox2.value < 'textstring'
(if Textbox2 value not equal to text value)
I am unable to codify that 'textstring'








All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com