TEXTBOX ON SHEET

ROBINSYN

Board Regular
Joined
Aug 19, 2002
Messages
188
I presently have a dropdown menu in 8 cells on my sheet that are linked to different cells and different ranges each.
Could I replace these with a text box that the user could enter part of a name and the textbox would search the range and return a matc. If not found my userform would open so they could add the name to the list. How do I get the textbox on the sheet?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can use a Combo Box from the Control Toolbox to do this.

1. Right click any toolbar and choose Control Toolbox from the list.
2. Click on the Combo Box icon and click and drag on the sheet to position and size it.
3. Make a list of items on your worksheet thatyou wish to appear in the Combo Box and name it say MyList using Insert, Name, Define.
4. Right click the Combo Box and choose Properties.
5. Set the ListFillRange property to MyList.
6. Set the MatchEntry property to fmMatchEntryComplete.
7. Set the MatchRequired property to True.
8. Close the Properties window and click the Design icon on the toolbar (the first one that looks like a geometry set).
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Not - it can be anywhere - because you are using a named range (mylist) it doesn't matter where in the workbook mylist is stored.
 

ROBINSYN

Board Regular
Joined
Aug 19, 2002
Messages
188

ADVERTISEMENT

I tried you suggestion but I do not see the combobox edit in the control toolbox. Just combo box. Would you have an example you could email me. I work better if I can see things in action. If not can you suggest a site that may have examples.

syndee@sympatico.ca
 

DonkeyOte

MrExcel MVP
Joined
Sep 6, 2002
Messages
9,123
Draw a box - then right click on the box you have drawn and you should see a sub menu - edit is on that.
 

Forum statistics

Threads
1,144,768
Messages
5,726,179
Members
422,660
Latest member
mrsteele

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top