Anyone know how I can create a pull-down menu inside of a cell? Like the ones you see just above (offering font color and font size options), giving preset options? I know it can be done, I just can't point and click my way to the answer just yet.

 

This might get you there

Open the worksheet where you want to add an ActiveX control.
Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox.
Click the button for the control you want to add.
On the worksheet, drag the control to the size you want.
If you're adding a check box, text box, command button, option button, list box, combo box, toggle button, or label, enter the text you want to appear on the control.
How?

Right-click the control.
Point to the name of the object on the shortcut menu (for example, CheckBox Object).
Click Edit.
Edit and type the text.
When you're finished, press ESC.
Set the properties you want for the control: right-click the control, and then click Properties on the shortcut menu.

For information about the properties, press F1 in the Properties dialog box to display the Microsoft Visual Basic Help for Microsoft Forms.

Do one of the following:
Add VB macro code for a control to be used in Excel

Right-click the control, and then click View Code on the shortcut menu.

In the Visual Basic Editor, write your macro code.

For information about writing macro code, see Visual Basic Help.

To quit, click Close and Return to Microsoft Excel on the File menu.

Add a Web script for a control to be used on a Web page

Click the worksheet anywhere within the data that will go on the Web page.

On the Tools menu, point to Macro, and then click Microsoft Script Editor.

In the Script Editor, write your script, using the control ID to handle events for the control.

For information about developing Web scripts, click the option you want on the Help menu in the Script Editor window.

To return to Excel from the Script Editor, click Exit on the File menu.

To quit design mode and enable the ActiveX control, click Exit Design Mode .

 

Holy Schnikes! That's way more involved than I was hoping for. I appreciate the help, but I've already found a workaround that is far less complicated.

My main goal was to lock all of my formula cells and allow others to change the only 2 variables w/o them accidently screwing anything up. I finally figured out how to open up just the cells they need to change.

But seriously, I do appreciate the detail answer. I'm printing it out in case I decide to go ***** to the wall a little bit later.

 

Looks like you found a good soultion to your problem. I wasn't sure exactly what your problem was when I posted so those are very generic directions to set up any active x control including drop-down.