tick boxes that link to another data sheet

[rich ashcroft]

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

 

[Andrew Poulsom]

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.