I downloaded your VB Examples and am trying to understand how they work. I have not done any VB programming but plan to spend more time working with it in the near future.

I would like to set up a cell on the spreadsheet where I could input the email text so that when I click on the button "Click here to make PDF" the pdf will be created and an email would be generated with the text that was input on the spreadsheet.. I am able to get the email portion working but can not get the email text to work. I named a spreadsheet cell Email_body and declared it(Email_body) as a variable (Public emailbody As String).

Is there any way of pulling in the text for the email from the spreadsheet. Also, other than the help sections, is there any book that you would recommend for learning Visual Basic

Thank you







   

Glad to hear it. Well done! 

Learning VB is not too bad once you get over the concept of ParentObject.Object.Method and ParentObject.Object.Property.

For example:

• Car.Engine.Start would be a method (an action on something) and
• Car.ExternalColor = Blue (you can usually read and assign a value to a property).

    In terms of a book, I used the book that came with Visual Basic 4 way-back-when (it's dated 1995), and VB6 did not come with a book as by then, Microsoft started to rely on the online documentation. Same goes for VBA (that's the version of VB that comes with Microsoft Office programs). Their online documentation is not bad: it just takes a lot of time to go through the entire user documentation.

    Good luck! It sounds like you are well on your way though.