Groups > comp.lang.basic.visual.misc > #104

Re: VB6 to Excel

From	GS <gs@somewhere.net>
Newsgroups	comp.lang.basic.visual.misc
Subject	Re: VB6 to Excel
Date	2011-04-24 14:58 -0400
Organization	A noiseless patient Spider
Message-ID	<ip1rnr$8gn$1@dont-email.me> (permalink)
References	<aiUsp.26$2z7.14@newsfe15.ams2> <ip194v$a7k$1@dont-email.me> <eZWsp.41064$5t2.32770@newsfe06.ams2>

Show all headers | View raw

> .Select - That's the bit I was missing. Got it now

Thanks to a handy tip from Steve Rindsberg I've been able to remove the 
need to select the button as was coded using the macro recorder. This 
also serves as an example of what I meant by 'cleanup' to code 
generated by the macro recorder. Revised code follows:

With xlSheet.Shapes.AddFormControl(xlButtonControl, 100, 100, 100, 100)
    .OLEFormat.Object.Caption = "ButtonCaption"
    .OnAction = "MacroName"
End With

-- 
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc

Back to comp.lang.basic.visual.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

VB6 to Excel "Ivar" <ivar.ekstromer000@ntlworld.com> - 2011-04-24 13:01 +0100
  Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 09:40 -0400
    Re: VB6 to Excel "Ivar" <ivar.ekstromer000@ntlworld.com> - 2011-04-24 16:04 +0100
      Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 10:54 -0500
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 12:28 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 14:58 -0400
    Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-24 12:51 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-24 13:44 -0400
  Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 12:23 -0500
    Re: VB6 to Excel ralph <nt_consulting64@yahoo.net> - 2011-04-24 12:30 -0500
    Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-25 15:57 -0400
      Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-25 16:38 -0400
        Re: VB6 to Excel Steve Rindsberg <steve@rdpslides.com> - 2011-04-26 19:54 -0400
          Re: VB6 to Excel GS <gs@somewhere.net> - 2011-04-26 23:06 -0400

csiph-web