asked on

Date entered in userform used for looking up date range

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

Jacques Geday

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

deedeheard

ASKER

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.

deedeheard

ASKER

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..

Jacques Geday

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

deedeheard

ASKER

Yes

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

deedeheard

ASKER

This is awesome! Thank you so much!

Jacques Geday

Your welcome glad I could assist.
gowflow