Frame1 scroll

[Nirmalesh]

I have 1Frame control on user form.and
1label control and six textboxes under label. I want to do that when I scroll frame control then label control stay on their exact position as a header.
Actually I would like to make textbox grid. In this grid I use label control as header. How can I do this. Please vcçv

 

[sijpie]

There are various ways to achieve this.

Method 1:

1. Remove the scrollbar from Frame1
2. Add another frame inside Frame1
3. Give Frame2 a scrollbar
4. Move the textboxes into Frame2
5. Position the header label above frame2
6. Edit the Frame2 properties so that it doesn't have a border (optional) and delete its name

Method 2:

1. Remove the textboxes and replace by a Listbox.
2. You can multiple columns in a listbox if you want a 'grid'
3. You can give the listbox a scrollbar by not making it six rows high
4. Move the label to above the listbox as a header

Method 3 (does not work on MacOS):
Use the ListView control. This is a control that you also see a lot of Windows dialog boxes. It has its own headers and a scrollable list underneath. In order to use this you need to add the reference to the Windows Common Controls. In VBA in the menu go to Tools, then References. Search for Microsoft Windows Common Controls 6.0, and tick the box. Now the Listview should be available in your toolbox.
You will have to readup on the web how to use the listview.

 

[Nirmalesh]

There are various ways to achieve this.

Method 1:

1. Remove the scrollbar from Frame1
2. Add another frame inside Frame1
3. Give Frame2 a scrollbar
4. Move the textboxes into Frame2
5. Position the header label above frame2
6. Edit the Frame2 properties so that it doesn't have a border (optional) and delete its name

View attachment 61662


Method 2:

1. Remove the textboxes and replace by a Listbox.
2. You can multiple columns in a listbox if you want a 'grid'
3. You can give the listbox a scrollbar by not making it six rows high
4. Move the label to above the listbox as a header

View attachment 61663


Method 3 (does not work on MacOS):
Use the ListView control. This is a control that you also see a lot of Windows dialog boxes. It has its own headers and a scrollable list underneath. In order to use this you need to add the reference to the Windows Common Controls. In VBA in the menu go to Tools, then References. Search for Microsoft Windows Common Controls 6.0, and tick the box. Now the Listview should be available in your toolbox.
You will have to readup on the web how to use the listview.

View attachment 61665

No sir I want do do a dynamic list using frame label and texbox. I do not want to use listbox or listview it is easy. I want to do some different grid box using frame textboxe label.its challenge for me

 

[sijpie]

Please draw a userform showing how you want it to look. I will understand better. i thought Option 1 was what you are asking for.

 

[Nirmalesh]

 

[Nirmalesh]

When I scroll frame scrollbar then label also go upward direction

 

[Nirmalesh]

1) If I do Label1.top=Label1.top+6
Then it do proper but when I scroll up then label1 top added 6 and 6
2 if I do Label1.top= Frame1.scrolltop then it going proper way but some showing gap in label top

 

[Nirmalesh]

This is my project but there is one proble when I scroll a scrollbar of frame1 then label also go upward direction and hide please resolve it

 

[Nirmalesh]

 

[sijpie]

Hi Nirmalesh, thanks for the screenshots.
Question: Why don't you have the labels outside the frame, Just above the frame. Then they won't move when you scroll. That is by far the simplest solution.