Anyone know how to make this object?

[Samadhi]

I ran across a spreadsheet that has some nice dropdown objects in it. I can copy and paste them and change their ranges but they don't work the way they do in this. I can't set the relationship between the ranges the same.

Anyone know how to create them?
http://members.cox.net/samadhi69/Demo.xls

[SaberKitty]

Add an ActiveX control(right from excell help)

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 .

[Porro]

Looks complicated

[ctrlaltdel]

porro did you actually read it or just scrolled down for the size of the instructions?

i just scrolled... still looks complicated

[Porro]

I read halfway then went crosseyed

[SaberKitty]

ok
go to view- to add toolbars- add the "controll toolbox"
pick the icon that looks like a drop-down box,if you read the mouse-over, it says "list-box"
click it and click where you want it to go, if you double click the box that shows up, it takes you to a window-thingy where you can input the code- which you said you know how to do
yay, thenk click the icon on the box that popped up in a rondom new toolbar, and you're done

[Beartalon]

The dropdown uses the Material Table range is it's source. The cell above the drop-down is filled with the index of the choice in the drop down.

[SaberKitty]

that easier?

[Samadhi]

Can't believe I missed the control toolbox in View. I read the Help too!

[Porro]

[Samadhi]

The main thing I wanted was that when you make a choice from the ComboBox it would update the Material_Level field. Now that I know how to get at the properties, I should be able to do that.

[Porro]

I should think so too.

[SaberKitty]

heh, i've been more oblivious many-a time
like how i dind't see the forum discriptions for like a year...

[Samadhi]

Are you able to edit the one already on the spreadsheet? I can't seem to do that.

[SaberKitty]

i dunno, if you go back to that toolbar- with the drop-down selected, you can select the "view code" or the "properties", but maybe they made it so you can't edit that specific one, becasue i cna't see any code when i choose that option...

[Samadhi]

What type of object is that? It's not a regular ComboBox. And the Range "Material_Level" has to have code because that and the drop down are linked (change one, the other changes)

[HyToFry]

I tried to make one, and even made it, but I couldn't get it to leave design mode.

[Beartalon]

Samadhi - the whole workbook is protected. If you try to unlock or unhide the formulas, you have to enter a password. Start from scratch and create the sheet, then in the selection_change event subprocedure for the drop-down in VBA, give the cell above the value of the drop down index.

Range("A4:A4").Value = drop-down.index (or something like that)

[Samadhi]

BT: It's not protected. That's what bugs me. Unless you're talking about something other than Tools--->Protection----->Worksheet etc

[Beartalon]

Create the ranges.
Create the combo box, and in it's properties:
Set LinkedCell = Material_Level
Set ListFillRange = Material_Table
Set BoundColumn = 0 - This puts the combo boxes selection index in the Material_Level cell

[Samadhi]

Cool. Thanks. Dumb thing won't activate (typing in value into Material_Level makes the associated value from Material_Table appear but nothing can be chosen from the drop down). But I'm sure I can get it from here. Thanks for being patient with my weekend brain death.

[Samadhi]

Just realized why it wouldn't activate.
No more code for me on the weekends.

[JediSoop]

~peeks into thread~

~runs screaming in other direction~

I have a VG and ActiveX test for my job this week...I suck at both

[JediSoop]

so much so that i messed up the acronym

[HyToFry]

I'd rather have a VB test. VG is way too complicated for my puny mind.