tick boxes that link to another data sheet

rich ashcroft

New Member
Joined
Nov 6, 2002
Messages
1
hi

i am new to the forum and wondered if anyone can help me with a problem that i am having... :)

i need to design a drop down list or tick box based on peoples names that checks a data sheet to see if the data belongs to those people.

any help would be greatly appreciated!

rich
 

Some videos you may like

Excel Facts

Who is Mr Spreadsheet?
Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
This should get you started:

1. Make a list of the items you wish to appear in the dropdown and name it, say MyList (Insert, Name, Define).

2. Right click any Toolbar and check Control Toolbox.

3. Click the Combo Box icon and drag it onto your worksheet.

4. Right click the combobox and choose properties. To the right of ListFillRange type MyList and close the properties window.

5. Right click the combobox again and choose View Code. Put you code in the Click event procedure stub, the press Alt+F11 to return to your worksheet.

6. Click the Deisgn icon (top left) in the Control Toolbox to exit design mode.

Post back if you need more help.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,318
Messages
5,600,918
Members
414,416
Latest member
Nobu

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