View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Exiting a Textbox

Maybe the LostFocus event?

--
HTH

Bob

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

"EGL" wrote in message
...
I have several worksheet textboxes that are multiline and autosize.
However,
the users' input can get quite lengthy and the full textbox must be
visible,
so as one textbox expands it hides the textboxes (and other worksheet
data).

My workaround was to develop a routine to run when the user "exited" a
textbox, to "go behind" the textbox and insert the same number of rows
that
the textbox expanded by.

One "small" detail is thwarting my efforts...I don't know the name for the
"event" of exiting the worksheet textbox that would trigger my workaround.
All the info I could find was related to user forms.

Any ideas???