Hi,
I've got functions that build active-x controls at runtime; but they are drawing larger than what I'm asking for.
Example:
Example:Set TempControl = ActiveSheet.OLEObjects.Add(ClassType:="Forms." & cType & ".1", _ Link:=False, _ DisplayAsIcon:=False, _ Left:=Output.Left + 15, _ Top:=Output.Top + Output.height / 2 - 10, _ width:=cWidth, _ height:=cHeight)
cWidth x cHeight = 223.5 x 31.5
Getting:
Width x Height =297.75 x 42.75
This makes no sense to me. Any idea?
Bookmarks