EAF 45 - Manage Athlete Notes using Excel VBA Userforms

preview_player
Показать описание
Use this quick and easy Excel trick to make a CRM database of all your athlete notes.
EXCEL, VBA, USERFORM

See my channel for Excel Tips for Fitness Trainers, Sports Analysts and Sport Scientists
Use functions and built in features of excel 2010 to make your life easier
  1. ExcelTricksforSports
  2. Excel
  3. VBA
  4. Userforms
  5. John Lythe
  6. johnlythe
Рекомендации по теме
EAF 45 - 0:17:50

EAF 45 - Manage Athlete Notes using Excel VBA Userforms

EAF #46 - 0:15:49

EAF #46 - AthleteManager - VBA Userforms Part 2 - Manage all your athlete data

EAF 45 & 0:01:37

EAF 45 & 46 Update - Mac Userforms

EAF#75 Using Excel 0:17:06

EAF#75 Using Excel to Create a Basic Athlete Load Monitoring Tool

EAF #109 - 0:22:38

EAF #109 - RANKING SCORES WITH NEW DYNAMIC ARRAYS

EAF 44 - 0:15:07

EAF 44 - Dynamic Chart to Display Athlete Wellness Data by Days, Weeks or Months

EAF #41 - 0:15:07

EAF #41 - Using Excel Like SportsCode

EAF# 56 - 0:17:50

EAF# 56 - Composite Radar Profile

EAF #96 - 0:46:16

EAF #96 - Athlete Performance Dashboard Project - Part1

EAF #51 - 0:07:45

EAF #51 - VBA Timer for Athlete Substitutions

EAF #59 0:24:21

EAF #59 Fitness Testing Database using Excel Table References

EAF #40 - 0:08:50

EAF #40 - Updated Body Composition Manager

EAF #79 - 0:26:56

EAF #79 - Use Excel to send multiple athlete reports with 1 click via Outlook

EAF #80 - 0:10:34

EAF #80 - Use Excel VBA to personalise an athlete report with a photo

EAF# 58 - 0:15:10

EAF# 58 - Listbox Selector

EAF# 61 - 0:10:26

EAF# 61 - Part D - Building a Strength Load Monitoring Tool

EAF# 94 - 0:15:46

EAF# 94 - Performance Analysis Sportscode Project Finished File - Momentum

EAF#77 - Practical 0:10:08

EAF#77 - Practical Exercise in Excel - Intermediate Charting with Training Load Example

EAF #92 - 0:22:15

EAF #92 - Using Excel to Code Sport - Part 4 - Using Reference Data

EAF# 61 - 0:15:48

EAF# 61 - Part A - Building a Strength Load MonitoringTool

EAF# 66 - 0:16:26

EAF# 66 - Create Strength Template and use VBA to store and recall programs

EAF #89 0:09:07

EAF #89 - Using Excel to Code Sport

EAF #84 - 0:11:07

EAF #84 - Use Excel to Automatically Create Reports - Part 2: Extract Multiple Records

EAF# 61 - 0:27:03

EAF# 61 - Part B - Building a Strength Load Monitoring Tool

Комментарии
Автор

Thank you for a GEAT POST!! Have been trying to dublicate this one with some additional rows but I keep hitting the wall with a Runtime 1004 error message? Apparently the this is the problem code,
Cells(pasterow, 1) = CDate(datumbox.Value)
Cells(pasterow, 2) = namebox.Value
Cells(pasterow, 3) = ratebox.Value
Cells(pasterow, 4) = GoalsAgainstBox.Value
I have changed the names compared to your example but it SHOULD match what you did.
PLEASE HELP!
Thanks again

maciejszwoch
Автор

hi that was very very useful video, thank  you so much
please carry on, we will learn from your videos..!!

nazefali
Автор

Hi great video!
I am having trouble with 1 line of code that is not working though. Could you please help?
pasterow = Cells(Rows.Count, 2).End(x1Up).Offset(1, 0).Row

When I go to test it gives me a runtime error and then debig highlights that line of code. I copied it exactly from yours. When I hover over the highlighted line of code it says pasterow = 0 which I assume is meant to say pasterow = 2?

jakejennings-exerciselibra
Автор

Awesome stuff mate. Do you have a website?

Teskeman