Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
List objects and Buttons
I have a list object over a Button is there a way to keep the listo boject
from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows. -- Thanks Lonnie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
List objects and Buttons
Set the button's Top property based on the List Object's Top and Height
properties. For example, Button.Top = List.Top + List.Height + Gap You may have to play around with the syntax to make it work for you, but hopefully that will point you in the right direction. Matthew Pfluger "lrjanzen13" wrote: I have a list object over a Button is there a way to keep the listo boject from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows. -- Thanks Lonnie |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
List objects and Buttons
Unfortunatly thre are no Top and Height properties for the list object. It
seems to be grid based. -- Thanks Lonnie "Matthew Pfluger" wrote: Set the button's Top property based on the List Object's Top and Height properties. For example, Button.Top = List.Top + List.Height + Gap You may have to play around with the syntax to make it work for you, but hopefully that will point you in the right direction. Matthew Pfluger "lrjanzen13" wrote: I have a list object over a Button is there a way to keep the listo boject from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows. -- Thanks Lonnie |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
List objects and Buttons
There does not seem to be a top and Height property for the List object.
Appears to be Grid based. -- Thanks Lonnie "Matthew Pfluger" wrote: Set the button's Top property based on the List Object's Top and Height properties. For example, Button.Top = List.Top + List.Height + Gap You may have to play around with the syntax to make it work for you, but hopefully that will point you in the right direction. Matthew Pfluger "lrjanzen13" wrote: I have a list object over a Button is there a way to keep the listo boject from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows. -- Thanks Lonnie |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
List objects and Buttons
The Answer CommandButton.Placement = Excel.XlPlacement.xlMove
-- Thanks Lonnie "lrjanzen13" wrote: I have a list object over a Button is there a way to keep the listo boject from rolling over the button? I have tried the Object positioning settings under format control with no luck. I need to have the button move down as the list grows. -- Thanks Lonnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count the unrepeated objects on a excel list | Excel Discussion (Misc queries) | |||
How to list objects defined - buttons, etc.? | Excel Programming | |||
Delete Rows from List Objects based on Conidtion | Excel Programming | |||
objects (buttons, dropdown list) move after print | Excel Programming | |||
Yes or No buttons,list,or Combo box | Excel Worksheet Functions |