VBA: User form Validation for Mobile Number input

  Рет қаралды 24,643

PK: An Excel Expert

PK: An Excel Expert

Күн бұрын

#UserformValidation #MobileNumberInput #VBAtips
Hello Friends,
In this video you will learn how to put the validation in VBA user form to validate a Mobile Number.
Please download this excel file from below given link:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkan-excel-expert-9748...
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert

Пікірлер: 18
@sandeepnitc
@sandeepnitc 2 жыл бұрын
Thanks a lot
@PKAnExcelExpert
@PKAnExcelExpert 2 жыл бұрын
Most welcome
@amirahmed6716
@amirahmed6716 3 жыл бұрын
Very usefull. Thanks
@golurajput456
@golurajput456 3 жыл бұрын
Thanku bhai is video khatr
@channel-ry4xq
@channel-ry4xq 2 жыл бұрын
Very good sir ,fix digit number ke liye code bataye sir help hogi
@medkari
@medkari 6 жыл бұрын
Great Thank's
@veereshmaanvi8828
@veereshmaanvi8828 6 жыл бұрын
I would like to learn about addins in excel and total options in excel in depth. could you please make such videos please.
@davidtostenson4083
@davidtostenson4083 4 жыл бұрын
Do you have a video for validating data from a known list without using a drop down? I need an error message for unavailable part number.
@samanyugamingandtorialvide9658
@samanyugamingandtorialvide9658 4 жыл бұрын
i like it
@PKAnExcelExpert
@PKAnExcelExpert 4 жыл бұрын
Thanks for your valuable feedback
@himadrichakraborty7509
@himadrichakraborty7509 5 жыл бұрын
Hi, I want to create a textbox that will accept input as date and the date should not be earlier than yesterday's date. Can yo please help me for such coding in excel vba.
@radheprajapati2036
@radheprajapati2036 6 жыл бұрын
sir i want userform dtlicker validation not greaterthan today date how can i do
@Ishuknowledgemantra
@Ishuknowledgemantra 4 жыл бұрын
Sir, i want prevent duplicate entries in mobile numbers. Please tell me. How possible
@Rakesh_Tech_Times
@Rakesh_Tech_Times 4 жыл бұрын
Request you to please also confirm how to use special characters with numbers?
@samtan20
@samtan20 5 жыл бұрын
This seems partial validation. We need to check few more checks in this. As below: -All 10 numbers can be zero's. We need to restrict that along with mentioned next point below. -Mobile number should be more than 6000000000 as there are only 6,7,8,9 series in India as per Wikipedia. en.wikipedia.org/wiki/Mobile_telephone_numbering_in_India
@nepalbhitrakokayonepal.7479
@nepalbhitrakokayonepal.7479 5 жыл бұрын
I want to enter number of my mobile which is in hard copy and enter it in EXCEL. There are lots of repeated mobile number. I want to enter INCOMING NUMBER OF SMS. OUTGOING NUMBER OF SMS. INCOMING NUMBER OF CALLS. OUTGOING NUMBER OF CALLS. I want that, when i enter the number in excel it automatic count how many times it is repeated. , How many times INCOMING SMS NUMBER REPEATED? How many times OUTGOING SMS NUMBER REPEATED? How many times INCOMING NUMBER OF CALLS REPEATED? How many times OUTGOING NUMBER OF CALLS REPEATED? One number is repeated many times . I mean one number is used for SMS [INCOMING AND OUTGOING SMS] SAME NUMBER IS USED FOR INCOMING AND OUTGOING CALL. I WANT TO COUNT ALL HOW MANY TIMES , INCOMING AND OUGOING SMS IS FOR EACH NUMBER?? OUTGOING AND INCOMING CALLS IS FOR EACH NUMBER??
@rkexcel2686
@rkexcel2686 6 жыл бұрын
sir school programme ka kya hua please Bataye Na
@LalitYadavspider
@LalitYadavspider 6 жыл бұрын
Hi this is lalit here i just this video...i think this will help me in my project.. on e more think sir i want to contact u then how can i reach to you. Because i have one more query.. please provide me ur no. Or email id so that i can reach to you. Thanks this is very nice video
Demo - Task Management System V1.0
23:22
PK: An Excel Expert
Рет қаралды 21 М.
VBA: Multilevel dependent drop-down in User Form
10:30
PK: An Excel Expert
Рет қаралды 111 М.
Caleb Pressley Shows TSA How It’s Done
0:28
Barstool Sports
Рет қаралды 60 МЛН
How to run UserForm in Full Screen Mode in Excel and VBA
11:00
TheDataLabs
Рет қаралды 41 М.
5 VBA UserForm Super Tips
15:12
PK: An Excel Expert
Рет қаралды 46 М.
How to Create a Data Entry Form in Excel
34:30
Excel Macro Mastery
Рет қаралды 315 М.
Data Entry Application in Excel VBA - Part 2
16:02
PK: An Excel Expert
Рет қаралды 62 М.
UserForm with Multiple Option Buttons in Excel and VBA
18:33
TheDataLabs
Рет қаралды 107 М.
Creating Dependent Combo Boxes in Excel User Form with VBA
22:28
Dinesh Kumar Takyar
Рет қаралды 109 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 1,1 МЛН
6 Ways To Disable Text Or Numbers in Userform TextBox - ExcelVbaIsFun
32:08
Incident Report Tracker in Excel
20:26
PK: An Excel Expert
Рет қаралды 3 М.
Caleb Pressley Shows TSA How It’s Done
0:28
Barstool Sports
Рет қаралды 60 МЛН