| Author |
Message |
| HyToFry |
Posted: Tue Aug 12, 2003 4:36 am Post subject: 1 |
|
I'd rather have a VB test. VG is way too complicated for my puny mind.  |
|
 |
| JediSoop |
Posted: Tue Aug 12, 2003 3:42 am Post subject: 0 |
|
so much so that i messed up the acronym  |
|
 |
| JediSoop |
Posted: Tue Aug 12, 2003 3:41 am Post subject: -1 |
|
~peeks into thread~
~runs screaming in other direction~
I have a VG and ActiveX test for my job this week...I suck at both  |
|
 |
| Samadhi |
Posted: Mon Aug 11, 2003 7:11 pm Post subject: -2 |
|
Just realized why it wouldn't activate.  No more code for me on the weekends. |
|
 |
| Samadhi |
Posted: Sun Aug 10, 2003 10:08 am Post subject: -3 |
|
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.  |
|
 |
| Beartalon |
Posted: Sun Aug 10, 2003 8:07 am Post subject: -4 |
|
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 |
Posted: Sun Aug 10, 2003 6:48 am Post subject: -5 |
|
| BT: It's not protected. That's what bugs me. Unless you're talking about something other than Tools--->Protection----->Worksheet etc |
|
 |
| Beartalon |
Posted: Sun Aug 10, 2003 1:48 am Post subject: -6 |
|
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) |
|
 |
| HyToFry |
Posted: Sun Aug 10, 2003 12:30 am Post subject: -7 |
|
I tried to make one, and even made it, but I couldn't get it to leave design mode.  |
|
 |
| Samadhi |
Posted: Sat Aug 09, 2003 10:48 pm Post subject: -8 |
|
| 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) |
|
 |
| SaberKitty |
Posted: Sat Aug 09, 2003 10:44 pm Post subject: -9 |
|
| 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 |
Posted: Sat Aug 09, 2003 10:40 pm Post subject: -10 |
|
| Are you able to edit the one already on the spreadsheet? I can't seem to do that. |
|
 |
| SaberKitty |
Posted: Sat Aug 09, 2003 10:20 pm Post subject: -11 |
|
heh, i've been more oblivious many-a time  like how i dind't see the forum discriptions for like a year... |
|
 |
| Porro |
Posted: Sat Aug 09, 2003 10:19 pm Post subject: -12 |
|
| I should think so too. |
|
 |
| Samadhi |
Posted: Sat Aug 09, 2003 10:19 pm Post subject: -13 |
|
| 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 |
Posted: Sat Aug 09, 2003 10:17 pm Post subject: -14 |
|
 |
|
 |
| Samadhi |
Posted: Sat Aug 09, 2003 10:16 pm Post subject: -15 |
|
Can't believe I missed the control toolbox in View. I read the Help too!  |
|
 |
| SaberKitty |
Posted: Sat Aug 09, 2003 10:12 pm Post subject: -16 |
|
| that easier? |
|
 |
| Beartalon |
Posted: Sat Aug 09, 2003 10:11 pm Post subject: -17 |
|
| 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 |
Posted: Sat Aug 09, 2003 10:11 pm Post subject: -18 |
|
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 |
|
 |
| Porro |
Posted: Sat Aug 09, 2003 10:08 pm Post subject: -19 |
|
I read halfway then went crosseyed  |
|
 |
| ctrlaltdel |
Posted: Sat Aug 09, 2003 10:07 pm Post subject: -20 |
|
porro did you actually read it or just scrolled down for the size of the instructions? 
i just scrolled... still looks complicated  |
|
 |
| Porro |
Posted: Sat Aug 09, 2003 10:03 pm Post subject: -21 |
|
Looks complicated  |
|
 |
| SaberKitty |
Posted: Sat Aug 09, 2003 10:01 pm Post subject: -22 |
|
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 .
|
|
 |
| Samadhi |
Posted: Sat Aug 09, 2003 8:37 pm Post subject: -23 |
|
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 |
|
 |