You can use:
You can use:
MATCH returns the position of the match, so since your data starts in row 1,
will return the row number.
Can you late bind the code and skip the reference altogether?
Depends how you want to be able to use it. A scroll bar is easier if you want the option to make big changes, or have a visual indication of your current selection vs the max.
You only use brackets when calling a routine if:
1. You are using the Call keyword; or
2. You are using the result of a Function; or
3. You are explicitly trying to evaluate/dereference the argument you are passing.
In this case, none of those are true, so your calling line should just be:
Just as an alternative, you could use:
which is less volatile (not that it will make a lot of difference with a simple formula like that).
Glad to help.
Reformat the cells as General. What you describe is what that formula does.
Try something like this:
Still no birth date info in that file.
Where is the tie breaker information?
You can use TypeOf or Typename to determine the type of an object. (Strictly speaking, TypeOf actually checks if an object implements a specific interface, rather than testing its actual type, but it should work for your purposes).
As I said, June and November have the same number of days, so that should work fine; only months with different numbers of days have issues.
Will the dates always be the end of a month?
DATEDIF has always had problems with this calculation with months that have different numbers of days in them.
You can use the camera tool to create pictures linked to a range. Just be aware that this can slow down VBA code if you are using it and have a lot of pictures.
I'll try to explain.
Starting from the combo drop down click. I'm getting the combobox as a string and I can't convert that into a combobox object.
You're getting the string using Combo.Name but Combo is the object itself, so pass that.
Can you please clarify why you can't pass it as an object?