 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / January 2008List 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.  SignatureThanks Lonnie 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 > 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. Unfortunatly thre are no Top and Height properties for the list object. It seems to be grid based. SignatureThanks Lonnie > Set the button's Top property based on the List Object's Top and Height > properties. For example, [quoted text clipped - 10 lines] > > under format control with no luck. I need to have the button move down as the > > list grows. There does not seem to be a top and Height property for the List object. Appears to be Grid based. SignatureThanks Lonnie > Set the button's Top property based on the List Object's Top and Height > properties. For example, [quoted text clipped - 10 lines] > > under format control with no luck. I need to have the button move down as the > > list grows. The Answer CommandButton.Placement = Excel.XlPlacement.xlMove SignatureThanks Lonnie > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.