Solved

Date entered in userform used for looking up date range

Posted on 2014-10-03
8
135 Views
Last Modified: 2014-10-06
I am using an Excel userform with various entry fields and listboxes for spreadsheet data entry.  One of the entry fields is a date.  I want to use the date entered to search a worksheet with date ranges to obtain the Academic Year and Academic Term that the entry date belongs.  I have a formula in the attached file to do the lookup, but want to use VBA to obtain the information.
DateLookupExample.xlsm
0
Comment
Question by:deedeheard
  • 4
  • 4
8 Comments
 
LVL 29

Expert Comment

by:gowflow
ID: 40361472
You mean in the Form you want to select the student on the list then put a date and you want to get Academic Year and Academic term show up ? if yes you want this in a mesagebox or ?
and are you referring to the information you have in the sheet Adjustments ?

Like you want to eliminate this sheet completely and simply have the form to querry this info ? is this what your looking for ?
gowflow
0
 

Author Comment

by:deedeheard
ID: 40361605
The student is selected in the user form and a date is entered. When the dad button is clicked, I want to use the entered date to lookup the corresponding academic year and academic term and write a record (with student name , student number, date, academic year and academic term) in the worksheet. I hope this makes sense.
0
 

Author Comment

by:deedeheard
ID: 40361619
I have two academic year and academic terms in the adjustments worksheet, but don't want to use the columns with the formulas - I want to determine and populate the Academic Year Value and Academic Term Value from vba..
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 29

Expert Comment

by:gowflow
ID: 40361845
ok then you want to update the Sheet 'adjustments' with the values from the form (for sure adding year and term) right ?? In other words we will be overriding the formulas ??

gowflow
0
 

Author Comment

by:deedeheard
ID: 40362147
Yes
0
 
LVL 29

Accepted Solution

by:
gowflow earned 500 total points
ID: 40362305
ok here it is.
I added a button on the sheet Adjustments to display the form anytime you want.

Just choose several combinations of dates
System will check for dates outside the listed ones and advise you
also system will check if the combination already exist and will advise you.

Let me know.
gowflow
DateLookupExample-V01.xlsm
0
 

Author Closing Comment

by:deedeheard
ID: 40362665
This is awesome!  Thank you so much!
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40363153
Your welcome glad I could assist.
gowflow
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lync meeting or Lync conferencing is what many organizations would like to deploy to allow them save money. But companies are now giving up for various reasons, one of which is that they cannot join external meetings (non-federated company meetings)…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

829 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question