How To Create An Excel Data Entry Form WITHOUT A UserForm


🔥GET 250 OF MY BEST TEMPLATES HERE►
📢GET YOUR FEATURE ADDED ON PATREON ►
👉SELL YOUR OWN EXCEL-BASED SOFTWARE►
👨‍💼JOIN MY INCREDIBLE DASHBOARD MASTERCLASS HERE►
📣LEARN VBA FROM THE GROUND UP ►

In this week’s training, I will show you how to create a Contact Manager Data Entry Form.

📣30-HOUR VBA COURSE►

⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL:
💬 FACEBOOK MESSENGER:

EXCEL COURSES:
►DASHBOARD MASTERCLASS:
►MENTORSHIP PROGRAM:
► BEGINNERS VBA COURSE:

EXCEL PRODUCTS:
►The Ultimate Excel Resource Guide:
►250 Excel Workbooks:
►Automate Your VBA Programming:
►Create Dashboards & Charts In Seconds:
►Secure Your Excel Applications From Theft:

🧐Find the Best Excel Products & Courses Here:

Timestamps:

0:00 – Introduction
0:32 – Worksheet Design
26:04 – Selection Change Event
28:49 – Load Contact
41:55 – Save Contact
47:19 – Delete Contact
50:47 – Cancel New Contact
52:32 – Attach Thumbnail
58:08 – Display Thumbnail
1:05:12 – Change Event

JOIN OUR COMMUNITY:
►Facebook Group:
►Facebook Fan Page:

Follow me on my Social Media Accounts:
🐦Twitter:
🌏Website:
🔗LinkedIn:
👤Facebook:
📸 Instagram:
🎥Rumble:
👤Locals:
✉Telegram:
📲Gab:

About Us:
I help Microsoft Excel enthusiasts turn their passion into profits in so they can earn passive income using their skills without having to trade time for money.

I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep these training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.

Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing

New Training Video Uploaded every Tuesday
Thank you very much for your continued support,
Randy Austin

#exceltraining #contactmanager #dataentryform
Facebook Group Machine

30 thoughts on “How To Create An Excel Data Entry Form WITHOUT A UserForm”

  1. The fact that we delete a contact by deleting a row ends up for me with no more lines formated.
    So instead of "EntireRow.delete"
    I did .selection; and Selection.ClearContents; and sort the contact board from a to z (not creating a blank row in the middle of filled ones).
    I would be happy to know an easier way to do that.

    Thanks Randy for this usefull knowledge shared! I am currently using this video to make a Seminars multibilling platform for valet car park at work.

  2. I wish someone would make a data entry form for a daily class report drawing from a student database to import their names for attendance and incompleted homework

  3. अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का एक्सल में एक्सैस में एचटीएमएल में कोई विडियो नही बना है अतःआप एक फार्म ऐसा बनाये जिसमें आई डी हो, स्वयं हो ,पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत कुछ लिखा जा सकता है परन्तु अपन को पारिवारिक रिलेशनशिप सम्बन्ध लिंक बनाना है वो इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना

  4. This is great and easy to follow along with your instruction. One question at the 32 min mark when you cycle through the columns in the code (For ContCol = 4 To 10)… My table has 18 columns but for the data to load I only want data from a select few columns (4-7 and then 12, 13 & 14). So just data from those 7 columns is all I want to "load" the fields at the top and I feel like I have them mapped properly on the sheet. Is there a way I can do that in VBA, instead of doing the range like 4 To 14? I tried that but it errored out. I thought 4 To 14 would cycle through those columns and skip those columns that aren't "mapped" on the sheet. Didn't work. I thought maybe an Array with the selected columns but it doesn't seem to work. Hoping there's a way to select various columns to pull the data. Thanks, I'm impressed with your knowledge and teaching style and I'm looking at your courses.

  5. I really appreciate your video and it seems really good but I know nothing from excel. I will look at it later when I have a more accurate knowledge basis in this program.
    Thank you!

  6. i'm getting an error in this code:
    Sub cont_displaythumb()
    Dim picpath As String
    With Sheet1
    On Error Resume Next
    .Shapes("thumbpic").Delete 'delte thumbnail picture(If any)
    On Error GoTo 0
    picpath = .Range("m4").Value 'picture path
    With .Pictures.Insert(picpath)
    With .ShapeRange
    .LockAspectRatio = msoTrue
    .Height = 85
    .Name = "thumbpic"
    End With
    End With
    With .Shapes("thumbpic")
    .Left = Sheet1.Range("j4").Left
    .Top = Sheet1.Range("j4").Top
    .IncrementLeft -25
    .IncrementTop 10
    End With
    End With 'end sheet 1
    End Sub

    the debug occurs at With .Pictures.Insert(picpath)

    everything looks right

    help

  7. Hi Agin sir Randy. This video is really is helpful! I just wanted to know if there is way to retain a formula on a cell that is part of the Cont_save range after saving it? I tried adding formula (=sum(E5*F5) but after saving, the formula disappears. I hope I made sense of what I am inquiring about. LOL
    Thanks again!

Comments are closed.