Forum Discussion
Charles Harris
May 15, 2018Copper Contributor
VBA Adding Controls to floating Shape
In a shape (floating) I want to place, 1 at a time with vba, activex control boxes as required, (listbox, or textbox etc)
- So the 'shape' will vertically list 1 or more activex control boxes for the data to be viewed. The only items in the shape will be activex controls. When placing control box in to shape how do I specify the distance between the previous and new box. There is no rows in shape. Want about equivalent of 3 or 4 rows space. Something equivalent to lastrow +3 etc
- The shape will need a vertical scroll bar to scroll the 2 or more boxes. Seems to be scroll for boxes with rows but what scroll option available for boxes within shape.
No RepliesBe the first to reply