Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox In VBA Growing
I have a listbox in a VBA script which grows both in width and height
after each save and re-open of the script. The height and width values on the properties of the box change automatically. Is there any way of stopping this.? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox In VBA Growing
Alok
Thanks for your idea. I think this would work for me also, however I am fairly new to VBA and I've tried setting the height and width during a record macro, to get the values but this was no help as I had to go into the design tool to do it, and the recorder doesn't seem to work in the design mode. Could you let me have the syntax for setting the height and width for your list box. Alok wrote: Yes this is a problem. In my case the Listbox kept shrinking and finally became a text box. I did not research this issue much and handled the problem by fixing the Height and Width properties of the Listbox in the Workbook open event. Alok " wrote: I have a listbox in a VBA script which grows both in width and height after each save and re-open of the script. The height and width values on the properties of the box change automatically. Is there any way of stopping this.? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox In VBA Growing
Alok
Thanks for your idea. I think this would work for me also, however I am fairly new to VBA and I've tried setting the height and width during a record macro, to get the values but this was no help as I had to go into the design tool to do it, and the recorder doesn't seem to work in the design mode. Could you let me have the syntax for setting the height and width for your list box. Alok wrote: Yes this is a problem. In my case the Listbox kept shrinking and finally became a text box. I did not research this issue much and handled the problem by fixing the Height and Width properties of the Listbox in the Workbook open event. Alok " wrote: I have a listbox in a VBA script which grows both in width and height after each save and re-open of the script. The height and width values on the properties of the box change automatically. Is there any way of stopping this.? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox In VBA Growing
Alok
Thanks for your idea. I think this would work for me also, however I am fairly new to VBA and I've tried setting the height and width during a record macro, to get the values but this was no help as I had to go into the design tool to do it, and the recorder doesn't seem to work in the design mode. Could you let me have the syntax for setting the height and width for your list box. Alok wrote: Yes this is a problem. In my case the Listbox kept shrinking and finally became a text box. I did not research this issue much and handled the problem by fixing the Height and Width properties of the Listbox in the Workbook open event. Alok " wrote: I have a listbox in a VBA script which grows both in width and height after each save and re-open of the script. The height and width values on the properties of the box change automatically. Is there any way of stopping this.? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox In VBA Growing
Thanks Alok,
Works a treat, much appreciated. Alok wrote: In the Visual Basic IDE find out the programmatic name of the worksheet on which your list box is located. Say it is Sheet2. Also say that your list box is ListBox1. With Sheet2.ListBox2 .Height= ... .Width =... End with Alok " wrote: Alok Thanks for your idea. I think this would work for me also, however I am fairly new to VBA and I've tried setting the height and width during a record macro, to get the values but this was no help as I had to go into the design tool to do it, and the recorder doesn't seem to work in the design mode. Could you let me have the syntax for setting the height and width for your list box. Alok wrote: Yes this is a problem. In my case the Listbox kept shrinking and finally became a text box. I did not research this issue much and handled the problem by fixing the Height and Width properties of the Listbox in the Workbook open event. Alok " wrote: I have a listbox in a VBA script which grows both in width and height after each save and re-open of the script. The height and width values on the properties of the box change automatically. Is there any way of stopping this.? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
File size growing growing exponentially | Excel Discussion (Misc queries) | |||
Growing filesize without doing anything | Excel Discussion (Misc queries) | |||
Listbox In VBA Growing | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Growing CF Problem | Excel Programming |