PDA

View Full Version : toolbar question



vzachin
05-06-2011, 08:54 AM
hi,

in this post,

http://www.vbaexpress.com/forum/showthread.php?t=32596&highlight=toolbar

is there a way to customize the icon? instead of using faceid?

i want the icon to say "GO" or something like that

thanks
zach

Bob Phillips
05-06-2011, 09:31 AM
You could create a small .gif file and paste it onto a worksheet and use




cbTable.Shapes(shapename).Copy*Picture
cbCtl.PasteFace

where cbTable is the codename of the sheet containing the picture, shapename
is the name of the shape, such as 'Picture 30', and cbCtl is an object
variable for the control being added.

vzachin
05-06-2011, 10:34 AM
thanks bob, i'll give that a try later


zach