Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
#7
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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' |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Modify Code | Excel Worksheet Functions | |||
How to modify the code for different type of input? | Excel Worksheet Functions | |||
How to modify the code for different type of input? | Excel Discussion (Misc queries) | |||
code line with two conditions | Excel Discussion (Misc queries) | |||
Modify Macro Code Depending on Excel Version | Excel Discussion (Misc queries) |