View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Limey Limey is offline
external usenet poster
 
Posts: 20
Default Scroll Frame after user event

Hi,
thanks in advance for any help I receive.
I have a userform with a frame that has the vertical scrollbar
visible. Inside the frame are a number of textboxes, (10), all but the
first two are set to invisible. When the user clicks inside of the
second text box, the third becomes visible, clicking the third the
forth becomes visible etc. All is good so far, and I have this part
working beautifully. What is driving me mad, is that I would like as
the next textbox becomes visible, to scroll the focused control to the
top of the frame, fully revealing the next control.
I seem to be tripping up on what seems should be a simple thing.