View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] benabd@gmail.com is offline
external usenet poster
 
Posts: 8
Default VBA control vscroll and hscroll in a frame

Hi Gary,

I am not sure I got your point, but you can use the ScrollTop
(Vertical) and ScrollWidth (Horizontal) property to position them. Of
course, you should know the values (in design mode) to do so and also
you should set the Setfocus method to the adjacent object (textbox,
command button, checkbox, etc).

myFrame.ScrollTop = 1176
myFrame.ScrollWidth = 600
myTextBox.SetFocus

I hope this helps.
Karim