I have a Userform which contains TextBoxes loaded with the chosen data from a database.
Typically there are from 1 to 4 records which the choosing procedure picks up.
I want the user to select one of these for passing on to the rest of my application.

I had thought that some code along the lines of
Choice = UserForm.ActiveControl.value
would do the trick, but ActiveControl does not have a Value property.
How should I proceed?
John