Office 2003 Excel question... - DodgeIntrepid.Net Forums - Dodge Intrepid, Concorde, 300m and Eagle Vision chat
Reply
 
LinkBack Thread Tools Rate Thread Display Modes
post #1 of 16 (permalink) Old 01-24-2006, 02:00 PM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
Office 2003 Excel question...

I can work my way around most Excel problems, but this has me stumped. I need to make a drop-down cell that contains two choices, YES and NO. I think I'm supposed to make a Combo Box, but I can't figure out how to enter the info that I need into it. Am I going to have to learn VBA to do this simple little task? Please help.
jossimbyr is offline  
Sponsored Links
Advertisement
 
post #2 of 16 (permalink) Old 01-24-2006, 02:28 PM
TJ
Intrepid Modder
 
TJ's Avatar
 
Join Date: May 2004
Location: Tulsa, Oklahoma
Posts: 293
Feedback: 0 / 0%
                     
Somewhere on the worksheet, enter the word "Yes" in one cell and "No" in another cell. Create a Combo Box. Once you create the box, right-click and select Format Control. In the Input Range field, designate the two cells where you put Yes and No. Also, change the Drop Down Lines to "2" so you do not have a bunch of extra space.
TJ is offline  
post #3 of 16 (permalink) Old 01-24-2006, 03:10 PM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
Bless you. Now, how do you make the thing stop "floating" above the spreadsheet? Is there a way to actually enter the info into the cell itself and accomplish the same thing? As soon as I can rep you again, you've got some coming your way.

EDIT: I forgot to mention that the Combo box is just slightly too big for the cells that I'm trying to put them in. Is there a way to easily resize the cells, maybe by anchoring the combo box to the cell? That's what I was trying to get at in the paragraph above.

Last edited by jossimbyr; 01-24-2006 at 03:32 PM.
jossimbyr is offline  
Sponsored Links
Advertisement
 
post #4 of 16 (permalink) Old 01-25-2006, 11:22 AM
TJ
Intrepid Modder
 
TJ's Avatar
 
Join Date: May 2004
Location: Tulsa, Oklahoma
Posts: 293
Feedback: 0 / 0%
                     
I will be away from a computer with Excel '03 today and my memory is failing on that particular point. This link has instructions on it that sounds right. Looks toward the bottom of the first page.

Its been a while since I have done it, so I don't remember exactly how I did it before - its not exactly a feature I use everyday. If you are still stuck, let me know and I will find a machine with Excel and figure it out later today.
TJ is offline  
post #5 of 16 (permalink) Old 01-25-2006, 12:04 PM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
That last part is exactly what I was looking for! I can't thank you enough. Like I said, everytime I'm able, you're getting rep for that.
jossimbyr is offline  
post #6 of 16 (permalink) Old 01-25-2006, 02:10 PM
TJ
Intrepid Modder
 
TJ's Avatar
 
Join Date: May 2004
Location: Tulsa, Oklahoma
Posts: 293
Feedback: 0 / 0%
                     
Glad to help. And the happy little world of DINET spins on..........
TJ is offline  
post #7 of 16 (permalink) Old 01-25-2006, 03:10 PM
 
Join Date: Aug 2003
Posts: 2,536
Feedback: 3 / 100%
                     
If case you're interested, the whole of the openoffice.org suite, including the spreadsheet, can be automated/programmed with Python. Pretty damned handy.
'98-ESer is offline  
post #8 of 16 (permalink) Old 01-25-2006, 03:40 PM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
I wish I could program, but the farthest I ever got in one of those classes was one semester of C++. I hated it so much that I changed my major from CS to Finance. :p
jossimbyr is offline  
post #9 of 16 (permalink) Old 01-26-2006, 06:28 PM
Intrepid Pro
 
Join Date: Mar 2002
Location: Massachusetts
Posts: 4,083
Feedback: 0 / 0%
                     
Quote:
Originally Posted by jossimbyr
Bless you. Now, how do you make the thing stop "floating" above the spreadsheet? Is there a way to actually enter the info into the cell itself and accomplish the same thing? As soon as I can rep you again, you've got some coming your way.

EDIT: I forgot to mention that the Combo box is just slightly too big for the cells that I'm trying to put them in. Is there a way to easily resize the cells, maybe by anchoring the combo box to the cell? That's what I was trying to get at in the paragraph above.
When you start getting into this kind of stuff you need to chuck Excel into the dust bin and fire up Access.
alderran is offline  
post #10 of 16 (permalink) Old 01-26-2006, 06:51 PM
Intrepid Pro
 
sc.intrepid's Avatar
 
Join Date: Aug 2004
Location: Charleston, SC
Posts: 4,600
Feedback: 5 / 100%
                     
Hey Joss, I didn't follow TJ's link so this may be what you found there.

For something like that I use Data validation.
It's available from Data menu.
sc.intrepid is offline  
post #11 of 16 (permalink) Old 01-27-2006, 10:20 AM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
Quote:
Originally Posted by alderran
When you start getting into this kind of stuff you need to chuck Excel into the dust bin and fire up Access.
I don't have access to Access. *rimshot* We've only got the big three here at work: Word, Excel and Outlook (although I don't see how Microsoft gets away with sticking Outlook in there as one of the programs.) It would be nice, though.
jossimbyr is offline  
post #12 of 16 (permalink) Old 01-27-2006, 10:27 AM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
Quote:
Originally Posted by 04IntrepidSXT
Hey Joss, I didn't follow TJ's link so this may be what you found there.

For something like that I use Data validation.
It's available from Data menu.
Data Validation is what I used. The link gave very good instructions on how to do it.
jossimbyr is offline  
post #13 of 16 (permalink) Old 01-28-2006, 06:47 AM
Intrepid Pro
 
Join Date: Mar 2002
Location: Massachusetts
Posts: 4,083
Feedback: 0 / 0%
                     
Quote:
Originally Posted by jossimbyr
I don't have access to Access. *rimshot* We've only got the big three here at work: Word, Excel and Outlook (although I don't see how Microsoft gets away with sticking Outlook in there as one of the programs.) It would be nice, though.
Tell them to break down and get you the developers version of Access. Then you can build your little database and distribute a run time version to the rest of the asshats at work.

Access is good to know. Since 1998, I've been pulling in 30 to 50K per year extra $$$ doing database work for small companies on the side. So many small companies with unique needs that you can charge $100 an hour to build them a solution.
alderran is offline  
post #14 of 16 (permalink) Old 01-28-2006, 10:59 AM Thread Starter
 
Join Date: May 2002
Posts: 1,258
Feedback: 0 / 0%
 
Quote:
Originally Posted by alderran
Tell them to break down and get you the developers version of Access. Then you can build your little database and distribute a run time version to the rest of the asshats at work.
What I had to do was a very simple task that didn't need too much work done to it. Basically, they had a spreadsheet that had a list of capital items on it in column A, with all the hotels in our region in row 1. Quantity ordered, total cost, and budget were all in row 2 under each hotel. They didn't want each hotel being able to see what everyone else was doing or what their budgets were, so I was tasked with making individual sheets for each property, plus I had to add in a couple of extra columns. All in all, it was simple to do, I just had never done a combo box before. Speaking of Access, I don't even remember what all it can do. It's been about seven years since I last took a class in it, and that was for Access 97, so I don't remember squat about it and wouldn't know where to begin.

Quote:
Access is good to know. Since 1998, I've been pulling in 30 to 50K per year extra $$$ doing database work for small companies on the side. So many small companies with unique needs that you can charge $100 an hour to build them a solution.
Wow. I remember you saying that you did a side-job involving databases, but I had no idea it was so profitable. I'm curious as to what these jobs consist of, so could you provide a general example? It really sounds as if Access could be beneficial to learn.

Last edited by jossimbyr; 01-28-2006 at 11:37 AM. Reason: Access 97, not 98. Oops.
jossimbyr is offline  
post #15 of 16 (permalink) Old 01-28-2006, 08:31 PM
Intrepid Pro
 
Join Date: Mar 2002
Location: Massachusetts
Posts: 4,083
Feedback: 0 / 0%
                     
The only real change since Access 97 is that Access now has a second optional file format (.adp) which lets you directly bind the database to an SQL Server. Instead of Access tables and queries you are using SQL Server tables, views, functions and stored procs. I use .adp for all the databases I am building at work.

An example of a job that I am working on right now is a waitlist for a low income housing project in Boston. So when they receive an application someone in the office types it into the database. The database then generates a receipt letter. If they don't qualify then it prints a reject letter. As apts open up people are selected off a waitlist sorted by bedroom size, income tier, preferences and finally a random number. When you select someone off the waitlist the database prints a interview letter. I got 10K to put this system together and have been getting money pretty regularly adding reports to it.

I think it's pretty fun. Learning about people's jobs and desiging a structure to capture their data.

alderran is offline  
Sponsored Links
Advertisement
 
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DodgeIntrepid.Net Forums - Dodge Intrepid, Concorde, 300m and Eagle Vision chat forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

Member names may only be composed of alpha-numeric characters. (A-Z and 0-9)

!!ATTENTION ADVERTISERS!! If you intend on advertising anything on this forum, whatsoever, you are required to first contact us here . Additionaly, we do NOT allow BUSINESS NAMES unless you are an Authorized Vendor. If you own a business, and want to do sales on this site via posting or private message, you will need to follow the rules. Shops, Stores, Distributors, Group Buys without being authorized will see your account terminated.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes Rate This Thread
Linear Mode Linear Mode
Rate This Thread:



Similar Threads
Thread Thread Starter Forum Replies Last Post
OTIS Install Question for 2003 SXT mkbruns Performance / Modifications (Second Generation) 19 02-23-2005 05:53 PM
New racing games coming out soon!! 01redMS Whatever 11 09-16-2004 12:33 AM
OTIS Install Question 2003 SXT mkbruns Intrepid R/T and SXT 0 06-18-2004 01:11 AM
Help- 2003 options/features question Champcar General Discussion (Second Generation) 15 08-27-2002 09:27 PM

Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome