XL 2003

I have a command bar with a text box (msoControlEdit) for the user to enter
text as the basis of a search parameter.

Via the .OnAction event it works fine (the user enters the text then presses
return), but is there a way I can capture the text as it is entered ...
effectively a change event on the text in this control ?

Many thanks
John

I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John" wrote in message
...
XL 2003

I have a command bar with a text box (msoControlEdit) for the
user to enter text as the basis of a search parameter.

Via the .OnAction event it works fine (the user enters the text
then presses return), but is there a way I can capture the text
as it is entered ... effectively a change event on the text in
this control ?

Many thanks
John

Thanks Chip .... I'm sure you'd know about it if there was a workaround.

Looks like I'm going to have to change it to a useform and capture key
events :-(

John



"Chip Pearson" wrote in message
...
I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John" wrote in message
...
XL 2003

I have a command bar with a text box (msoControlEdit) for the user to
enter text as the basis of a search parameter.

Via the .OnAction event it works fine (the user enters the text then
presses return), but is there a way I can capture the text as it is
entered ... effectively a change event on the text in this control ?

Many thanks
John

Have you tried this:
Private Sub TextBox1_Change()

MsgBox (TextBox1.Value)


End Sub

Obviously you will have something more meaningful replacing the Msgbox, I
have to warn you, it will execute as soon as the firs letter is keyed in.




"John" wrote:

Thanks Chip .... I'm sure you'd know about it if there was a workaround.

Looks like I'm going to have to change it to a useform and capture key
events :-(

John



"Chip Pearson" wrote in message
...
I don't believe this is possible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"John" wrote in message
...
XL 2003

I have a command bar with a text box (msoControlEdit) for the user to
enter text as the basis of a search parameter.

Via the .OnAction event it works fine (the user enters the text then
presses return), but is there a way I can capture the text as it is
entered ... effectively a change event on the text in this control ?

Many thanks
John