Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox scretch
Hello, I added a listbox in my main sheet. The only property changed is the
"listfillrange" (linked to another sheet/range A3:A200). Each time i load the file, the listbox is smaller and smaller... How can i fix this problem ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox scretch
Jean,
In design mode, right click the listbox and change the IntegralHeight property to False. Does this correct the problem ? Skiffle "Jean" wrote in message ... Hello, I added a listbox in my main sheet. The only property changed is the "listfillrange" (linked to another sheet/range A3:A200). Each time i load the file, the listbox is smaller and smaller... How can i fix this problem ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox scretch
Jean,
In my original post, I didn't direct you to IntegralHeight accurately. In design mode, right click the listbox, choose properties and then change the IntegralHeight property to False. If this does not work, right click the listbox, choose Format Control -- Properties Tab and select 'Move but don't size with cells' -- OK Cheers "Jean" wrote in message ... Hello, I added a listbox in my main sheet. The only property changed is the "listfillrange" (linked to another sheet/range A3:A200). Each time i load the file, the listbox is smaller and smaller... How can i fix this problem ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
userform listbox cannot get listbox.value to transfer back to main sub | Excel Programming | |||
avoiding duplicates in listbox (added from another listbox) | Excel Programming | |||
VBA: Creating listbox similar to the one in Pivot table (Listbox+Checkbox) | Excel Programming | |||
listbox.value not equal to listbox.list(listbox.listindex,0) | Excel Programming | |||
Is refreshing listbox rowsource in listbox click event possible? | Excel Programming |