Autofill userform textbox

M

Mark

Hi again!

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?


Regards

Mark
 
B

Bill Manville

Mark said:
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?
Click to expand...
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
 
Top