changing font size in an activex label

T

TONY

This fragment of code i am creating a lable, but when I attempt to change the
font size in the WITH BLOCK. Could someone point out what I am doing wrong.

Set control = OLEObjects.Add(ClassType:="Forms.Label.1", Link:=False, _
DisplayAsIcon:=False, Left:=cw * 3, Top:=rh * 2, Width:=cw * 6,
Height:= _
rh)



With control


End With
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prgrammatically added OLE Listbox, now cannot select from it 9
The size of the ActiveX ListBox control shrinks 2
insert label in worksheet 5
ActiveX Properties missing from menu 2
Excel crashes and restarts when accessing newly created worksheet 2
Putting 2 command buttons into 1 cell 2
ListBox on Worksheet AddItem 7
Removing border around Check box 0

Top