Trying to add a Text box onto an Excel sheet from Access

  • Thread starter trevorC via AccessMonster.com
  • Start date
T

trevorC via AccessMonster.com

I'm using the code from an excel macro, i've done this for Lines, to Split
and make Lists, then converted the code for Access, but the line below wont
work.
Any Idea's ?

This line fails
Current_Worksheet.Shapes.AddTextbox(msoTextOrientationHorizontal, 100, 155,
165, 75).Select
(This line won't accept the `with`..., `end with` )

This line works ok.
With Current_Worksheet.Shapes.AddLine(10, 50, 250, 290).Line
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

Top