Mark wrote:
Using Excel 97 is there a way that when entering some text
into a textbox in a userform. The worksheet tabs are
looked at and the textbox is autofilled?

Sounds like you need a ComboBox not a text box.
Then you can set it to AutoComplete

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup