I created a user form
in Excel VBA and created several textbox so the user can input some
data for me. For each textbox, I set the Controlsource to the cell I
want to reference in my worksheet. however, I want to validate some
fields to ensure data entegrity. For example, I have data, currency,
and text fields. I know how to do this in Access but not in Excel.

Does anybody knows how to do this?