View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
kirkm[_9_] kirkm[_9_] is offline
external usenet poster
 
Posts: 14
Default Looking for an example

On Tue, 28 Jul 2009 12:29:34 -0700, "Steve Yandl"
wrote:

Kirk,

I did a quick test and your code worked fine except a width of 30 wasn't
quite enough to fit the caption. The one think I left out was the variable
declaration. Try changing
Dim myLabel As Label
to
Dim myLabel As Control


Steve Yandl


Steve, thanks for that. Worked a treat.
But do you know how (or if you can)
lock the controls onto the Forn, as if they had been
put there at design time?

I've found I can't get to their click event code anyhow.

Thanks - Kirk