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

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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).
 
Upvote 0
Not - it can be anywhere - because you are using a named range (mylist) it doesn't matter where in the workbook mylist is stored.
 
Upvote 0
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
 
Upvote 0
Draw a box - then right click on the box you have drawn and you should see a sub menu - edit is on that.
 
Upvote 0

Forum statistics

Threads
1,218,899
Messages
6,145,095
Members
450,590
Latest member
Naneng

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
Back
Top