Replies

1. 
   The_Tennis_Court_Builder_...on_t | Aug 20, 2001 11:11pm | #1

   *
   Finally decided to use all the software I own. I am making a form that needs drop down lists like Quicken has. How do I do it?

   Thanks,

   aj

   I may try Frontpage next and make a web type form if it is easier.

1. 
   Mark_Dikeman | Aug 21, 2001 12:05am | #2

   *I don't know Quicken, so this may not be what you want.Click on View>Toolbars>Control Toolbox. Click on the Combo Box and draw the shape of it on your spread sheet. Right click on the combo box and click on properties. ListFillRange is the range of cells that contain the items in the drop down box. If you want a cell on the spread sheet to receive the selected value of the combo box when it changes, use the LinkedCell property.Hope this helps.I have attached an example.

1. 
   Mark_Dikeman | Aug 21, 2001 12:05am | #3

   *Sorry

1. 
   JohnD_ | Aug 21, 2001 12:05am | #4

   *Go to help and look up "forms". You can place dropdowns, radio buttons and the like into Excel from there. Also, turn on the Forms toolbar.For further help, you might want to look at http://www.wopr.com/ which has a LOT of good information about Windows and Office.

1. 
   GACC_DAllas | Aug 21, 2001 02:23am | #5

   *William,Just think........when your mother board crashes, what fun you'll have trying to remember everything!!Don't laugh.......it happened to me, it'll happen to you.Near the pen and pencil.Ed.

2. 
   Novy_7 | Aug 21, 2001 03:17am | #6

   *AJ, Wait untill the day when you learn to copy formulaes ! What a rush !

3. 
   blue_eyed_devil_ | Aug 21, 2001 03:41am | #7

   *John, I was fired up with excitement when I saw your link. I immediatly went there and couldn't find anything but advertising for things that I don't even know what they are talking about.Sometimes the web really gets me down....blue

4. 
   darrel1 | Aug 21, 2001 04:00am | #8

   *If these are forms to be printed (ie, not databased) you may also want to look into Acrobat. It can make forms such as that in PDF format. Actually, if you are just making them to print out, the FrontPage solution isn't a bad idea...However, if you need to store the data, you'd be better off with Excel or Access.

5. 
   Greg_Richard | Aug 21, 2001 02:53pm | #9

   *AJ: Glad to finally help the Breaktime guys with my area of expertise.In an out of the way part of your spreadsheet, create the list of options you want for your drop down list. For example, in cells i1, i2, i3, enter "low" , "medium" and "high" respectively.Then go to the cell where you want to create your drop down list. Go to the DATA menu and select VALIDATION. Under "Allow", select "LIST", then enter the range of cells that contains your list (in this example i1:i3)You will now have a drop down menu that gives you the option of selecting low, medium or high.See the attached example.

6. 
   JohnD_ | Aug 21, 2001 07:08pm | #10

   *Sorry I was not more detailed in my message, but I was rushed.From the WOPR site, go to the discussion board where they have some really good information about Windows and the various Office programs. And, b THEIR search program works really well.I also recommend that you sign up for the newsletters. Woody has been well ahead of others when describing problems with Windows, Word, and the like. He has been especially accurate regarding security problems, something that Microsoft is really slow to acknowledge.I have been receiving the newsletters for a couple of years now and they are very good (in spite of the fact that one of the authors lives in Oz -- sorry Mark). And, they do NOT spam. I have found them to be as ethical as the Taunton press in that regard.

7. 
   The_Tennis_Court_Builder_...on_t | Aug 22, 2001 03:56pm | #11

   *First off, Thanks all for the amazing dropdown tricks! I just worked all night on my second page of the Tennis Court Cost Calculator. I have it adding up lines and lines of variables and then presenting all nicely with totals and subtotals.Next trick now is to tackle making it look simpler and easier to use by adding the Features I refer to as Quicken Dropdown speed list handy dandy brain savers.near the books and the Excel stream,aj

8. 
   The_Tennis_Court_Builder_...on_t | Aug 22, 2001 03:58pm | #12

   *Mark, Your dropbox is just what I am shooting to add next. I am going to open it somehow in excel and see if I can read the code it uses or whatever it takes to do same,near the learning stream,aj

9. 
   Mark_Dikeman | Aug 22, 2001 08:31pm | #13

   *To see how it works, go to View>Toolbars>Control Toolbox. There is an icon with what looks like a blueish triangle and a pencil. That icon toggles in and out of design mode. In design mode, you can resize or edit the properties of the box (or other control object). To edit the properties right-click and select properties.In case you are interested, you can include several visible columns in the combo box if you need to. Or you can set the column widths to 0 to hide the columns. The user selects values from the visible list and values from the hidden list appear in the linked cell.I'm not an expert, but I will try to answer any questions.Here's another example with another combo box. I also added a button. That gets into a little Visual Basic programming, but nothing too fancy.Mark

10. 
    Mark_Dikeman | Aug 22, 2001 08:32pm | #14

    *I can't get the spell check to work with an attachment. Sorry.You will have to allow macros to run to get the button to work.

11. 
    blue_eyed_devil_ | Aug 22, 2001 08:37pm | #15

    *Okay John, I'm forgiving you. I'll give it another try...blue

12. 
    The_Tennis_Court_Builder_...on_t | Aug 22, 2001 09:25pm | #16

    *Wow Mark thanks...I feel like I just learned the secret handshake for dropdown form inside info!I made my first buttons and i bluetriangled your work Mark. I used to program Fortran and Basic On punch cards in College. The trouble I have with modern progamming is that I just am getting to where I see what modern programs do to hide and automate all that i used to have to punch one card at a time. Remember when we tried to write ten card programs and also bazillion card programs just to tap the limits out a bit!?The quicklist guy near the stream,aj

2. 
   The_Tennis_Court_Builder_...on_t | Aug 22, 2001 09:25pm | #17

   *