sending sms from excel vba

I have a working excel vba program, which allows to invoice the services and to take the appointments of the customers. I would like that each time an invoice is issued, the customer receives a thank you message for the amount of the invoice by sms. Also when a client's appointment is recorded, he gets an acknowledgment of receipt.

A similar problem has already been dealt with here. However there are items below that I did not understand in this code.

My knowledge of vba is really basic. Can you help me please.

Below is the code, as well as the lines which I don't understand.
thank you in advance



THE CODE

Please Login or Register  to view this content.

The lines i dont understand

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

so the (xyz as integer) is basically telling the Subroutine to take whatever value is passed into it and place it in a variable called "xyz".

those 3 lastrow lines are working out what the last populated row is in the first 3 sheets of the workbook. Basically to make it better code rather than doing loops to say 100000 or something and then weeding out blank rows.

That last line appears to be taking a value from a form (frmmain) and then doing something with it. A lot of that code will be different for yours. The important bit you need is the bit following the Else statement that's where the SMS magic happens.

Just a quick daft question though, you do have an account with a relevant SMS provider set up etc? you'll need that before you can do anything.