Autofill userform textbox

  • Thread starter Thread starter Mark
  • Start date Start date
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
 
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?
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
 
Back
Top