Forum Discussion

Charles Harris's avatar
Charles Harris
Copper Contributor
May 15, 2018

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)

 

  1. 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
  2. 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

Resources