Hi,

I have a multipage at the top of my Userform. However, depending on what tab I pick from the multipage, I want a value to be entered into the excel spreadsheet.

For example, if I have tabs called "SingleDrawing" and "MultipleDrawings" in my multipage, then anytime i click the "SingleDrawing" tab I want the word "Single" to be entered into cell AL16 and if i click the MultipleDrawings tab, I want the word "Multiple" to be entered into cell AL16. Is this possible? If so could somebody show me some code to do it? thanks alot