Send Whatsapp Message from Excel Sheet through VBA

Channel Link : https://bit.ly/2YMu8U2

Whats App Mobile Code if Number is Not Saved :
Go to Mobile Browser and Type -- wa.me/91 (Any 10 Digit Whats app Number)

VB Code
Sub Customer()
On Error GoTo errorhandler:
mobilenumber = Selection.Value
Set myrange = Sheet1.Range("B:B")
rowno = Application.WorksheetFunction.Match(mobilenumber, myrange, 0)
Description = Sheet1.Cells(rowno, 3).Value
Rs = Sheet1.Cells(rowno, 4).Value
ActiveWorkbook.FollowHyperlink Address:="https://wa.me/" & mobilenumber & "?text=" & Decription & Rs & ""
End
errorhandler:
Err.Clear
MsgBox "Select Proper Mobile Number "
End Sub
Note: For every new Sheet u should create new VB Code accordingly u will change Sheet Numbers. You Can insert as many Coulmns but when u insert sheet no in the cell specify row numbers properly.

Excel Steps:
1. Click at the cell B1 and Type Heading as Mobile (anything which u want)
In the cell B2 type any mobile no with Code like – 919000000000 & if problem arises like select proper mobile number or if displayed in any other format. Press Alt + O + E or go to format cell and change type either to general or number or text
2. Click at the cell C1 and Type Heading as Decription (anything which u want) & in the cell C2 type any message
3. Click at the cell D1 and Type Heading as Rs. (anything which u want) &in the Cell D2 type any amount
4. Go to file Options  Customize Ribbon Developer  ok
a) Go to developer tab click on Visual Basic
Or
b) Press Alt + F11
5. Click on Module 1 and Select all or Ctrl A and paste your VB Code and save yes
6. Click on Insert Tab & insert any Shape & write send or send sms any text on the button
5.Right Click on Your Rectangular Shape Box and assign Macro  select Customer Ok
6. select any mobile Number and Click on Send .
7. Click either on Whats app link or Continue with Contact.
excel, microsoft excel, excel vba, vba scripting, microsoft office, whatsapp, whatsapp messages from excel, computer excel, send messages from excel, excel tutorial, WhatsApp Message from Excel, WhatsApp VBA Message, How to send Whatsapp message from Excel Sheet Using VBA, Excel Sheet Using VBA, vba, how to send excel data by whatspp, how to send excel files on whatsapp, KAISE EXCEL KI FILES WHATSAPP SE SEND KARE, COMPUTER TIPS,excel, microsoft excel, excel vba, vba scripting, microsoft office, whatsapp, whatsapp messages from excel, computer excel, send messages from excel, excel tutorial, WhatsApp Message from Excel, WhatsApp VBA Message, How to send Whatsapp message from Excel Sheet Using VBA, Excel Sheet Using VBA, Gaming & Technology, vba, how to send excel data by whatspp, how to send excel files on whatsapp, KAISE EXCEL KI FILES WHATSAPP SE SEND KARE, COMPUTER TIPS,Advance Excel in Hindi, Userform in excel, userform in hindi, send sms using excel vba on any mobile, vlookup using vba, pivot table, send bulk sms to mobile, send sms, sms, sms sms sms sms,vba, whatsapp, automation

Видео Send Whatsapp Message from Excel Sheet through VBA канала IQ Classes