Drop down box problem
Please can someone help me!!! I am trying to inset a drop down box int
an excel spreadsheet but haven't got a clue whether I use a list box o
a combo box. I want it to display first, second, third, fourth in th
drop down menu so that the user can sleect one of these. The thing is
don't know how to put the values in the box! Your help would be muc
Message posted from http://www.ExcelForum.com
use the Data / Validation - List option ...
click in the cell where you want the drop down, choose Data / Validation
from the menu, choose List, and in the source line ty...update the same cell into another column forming a list on opening
i have made a spreadsheet to enter data and then view the resulting
statistics that are generated, i have one cell that changes in value after
entering the data, and i would like to keep a record of what values this cell
has been, i was after a formula that would update that single cell's value
into a column forming a list each time the spreadsheet was opened or the
value in the cell changed, like a field perhaps, this would fill up the
column with a list of results from which to generate more stats and a graph
any help would be great, thank you
thank...Is Version Updated after sp-1 is updated on Money 2007
After you get the automatic software downloaded is it necessary to click onto
the sp-1 to install?
No it is automatic. If I recall, after the SP1 is downloaded, you are
prompted to close Money and restart it. After you restart Help > About
should give you a version number ending in .1024.
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specifically asked for.
"Rebelleheart" <Rebelleheart@discussions.microsoft.com> wrote in messa...Tick box how do i? plz
I have a spreadsheet that I want to put a tick box coloumn into to show
whether I need to reprocess an item. Can some kind person tell me how thank
Got it sorted thnx
> Hi Folks,
> I have a spreadsheet that I want to put a tick box coloumn into to show
> whether I need to reprocess an item. Can some kind person tell me how thank
...conversion file dialog box
Every time I open Outlook 2002, the file conversion
dialog box opens along with Word and eventually an error
message. Does anyone know how to turn this off?
What file conversion dialog? Post the exact dialog that appears.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, frustrated asked:
| Every time I open Outlook 2002, the file conversion
| dialog box opens along ...Check box problem
I want to include a check box in a form I have created. It appears that to
make the box checkable by users, i.e. by clicking on it, I have to lock the
table/form. However, doing this prevents anyone entering text on the others
parts of the table/form.
Is there any way to make the box checkable without rendering the rest of the
form locked please? (One workaround is to double click the box and click on
the Checked option. However, this is not really a very user friendly
solution for what surely should be simple.)
For a form that includes check boxes, you must add text f...create a drop down list with the source from a different workbook
I tried to create a drop down list (Data > Validation > List) with the
source from a different work book (If you type the list in a different
workbook, define a name with an external reference to the list.). I followed
the instructions given in the Microsoft Online Assistant.
Iam not able to create the same as iam a getting a message stating that "You
may not use references to other worksheets or workbooks for Data validation
Try Debra Dalgleish's web site on this subject:
Scroll down to "D", and see ...Scroll to specific list box entry
I am trying to scroll to a specific line entry in a multi-select list box in
response to a user-input search criterion (in a separate text box) so that
the desired record becomes visible to the user. I can locate the matching
record and determine the line number, but I can't find a VBA method to scroll
to reposition the record.
My intent is to enable a user to enter the beginning character(s) to locate
the section of entries that begin with the user search criterion. From that
position, the user can then select the entries of choice.
I will appreciate any help.
Here a...Count unique names in a list
How do I count a list of names, some names appear more than once. I only
want to count unique names.
I use excel 2007
Microsoft Excel MVP
"Cassie" <Cassie@discussions.microsoft.com> wrote in message
> How do I count a list of names, some names appear more than once. I only
> want to count unique names.
> I use excel 2007
For ...Need quick way to build distribution list
Hi. I need to build a distribution list quickly which has as it's
members people sending me emails (people not currently in my
contacts). But the emails aren't coming from the individuals, they are
coming from a form on my website.
- all the emails come from the same address (my web form)
- all emails are formatted the same
- all contain an email address for someone who filled out the form
I'd like some kind of drag and drop or automated way to "dump" all
those addressed into a list so I can reply to them en masse.
Anyone know of a way to do this using ...company split
hoping to get some advice on this, the company i work for consists of two
divisions who are effectively looking to split, and do there own thing. But
initially will continue to share resources such as IT. Is it possible in
exchange to allow them both to have there own email addresses such as
name@company1 and name@company2 and to hide these so that relevant
individuals only see the names of users relevent to there division/company in
their address book. Effectively what i need to be able to do is run 2
seperate companies from one exchange box. bearing in mind that both compani...Bring in list of accounts in the Quick Journal setup
when setting up a Quick Journal, allow for an option to bring in a range of
accounts by any segment of an account. For example, all salary accounts, all
postage accounts.. rather than selecting each one individually or using the
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree"...Form with an unbound combo box.
I´m trying to create a database but I take some examples from Inside Out 2007
by Viescas.I create a tblTeams ( TeamID,TeamName) tblPlayers(PlayerID) and
tblTeamPlayers(TeamID,TeamName,PlayerID). I create a form based on qryplayers
and I need a combobox "unbound?" called TeamName based on qlkqTeams but
when I try to open the combobox always shows the TeamID instead of TeamName.
In the sample database "Contacts" from Viescas the CompanyName is display
in the combobox CompanyID. I don´t really Know how this happen.Can anybody
give me an idea of how this...Import CSV from Open Dialog box Confirmation
Hi. I got my command button to bring up an open dialog box, where the
user will select the CSV file to be imported.
After the user finds the file to be imported, I want a MsgBox that
asks the user to confirm that the specific file be imported. For
example, the user selects SCO.csv to import and clicks a okay. A
Msgbox should popup "Are you sure you want to import SCO.csv" with a
Yes button and a No button. I'm not sure if this is even possible, but
if so could someone please guide me. If they click No, then the
process should just cancel.
Assume strFileName is the variable wit...updating and underlying table field with a combo box selection
I want to use an ID value from a combo box on a subform to update the same ID
value in the form's underlying table.
My main form is: frm_Street_Joiner_Main
My Subform is: frm_Street_Joiner_Sub
My Subform table is: tbl_Street_Joiner
My Mainform is: frm_Street_Joiner_Main
The combo box on my subform is called: StreetName, with a column count of
two but the bound column is the actual street name.
QRY_Street_Names_Joiner_Master ORDER BY
QR...Randomly selecting items from a list given their statistical likelihood #5
In case anyone in the future happens to stumble on to this post in th
future with similar issues, here's what I came up with:
where a6:a129 are the product names
c6:c129 are the relative frequency
selected 10,000 times in column k.
from which I added 6 columns of rand() along side k and had a ro
that selected the highest in each column and gave the correspondin
product name which was then value pasted, placed on the side repeatedl
for a random sample.
' Macro1 Macro
' Macro recorded 9/13/2004 by Douglas
Dim ...Exporting Exchange mailbox List
I need to get a full list of all users mailboxes sizes in exchange, i did
that by entering each store ,opened mailboxes folder and export the list that
appears, the problem that the total number of mailboxes in stores is less
than the users in active directory which have a mailbox, can any body tell my
why this is happining, and if there is a way to export all users names with
their mailbox sizes for statistical reports without the need to open each
The farm we have are windows 2003 active directory, no SP1 installed, and i
have Exchange 2003 with SP1.
It is possible for a...Recordset Not Updateable
I have set up an access database to track technical support and training
services. I'm pretty new to Access and Very new to VB programming. I have
hit a wall with something and have found no solution in help or on these
discussion groups. Here's what I'm attempting to do, from the user's
perspective. This process works great up to the very end, then things fall
Let's say the user wants to look at all open support cases. The user
presses a button called "All Open Cases." A very basic query runs, and the
results are shown in a read-only (contin...Data Validation Lists
I have been searching the web all day, and I am not sure how to
approach this problem. Here is a basic worksheet:
ID Name Serial #
1 Joe ck9033n2389d
2 Joe 349-283fjrjh55
3 Bob c90320j34n5kjdf
4 Joe kgho95injhs
5 Bob 2353gdf745
Step 1: I have a drop down list with only one instance of each of the
Step 2: Upon selecting that name, I would like another drop down box
with all the serial numbers associated with that person.
Step 3: Then, based on the serial number, display stats in the same
row for that i...Online Updates
When trying to complete online update, the computer states the Money has
encountered an error and must shut down. Have upgraded to 1415. Help!
BTW: I'm using Money Plus Deluxe and XP
> When trying to complete online update, the computer states the Money has
> encountered an error and must shut down. Have upgraded to 1415. Help!
I want to use a consistent shape in many pages. Is there a
way to create a master copy such that when I update the
text on a master copy all copies are updated. I created a
new stencil and new master but updating the master doesn't
seem to update the copies (after i save the file).
You have to update the master in the local, or "Document Stencil"
Every Visio drawing contains a "hidden" Document Stencil, that carries
copies of masters from "external" stencil files. When you drag a new shape
into a drawing, the master gets copied from the external .v...windows update fail...... What now?
ok so I had a problem with windows update downloading but not installing.. I
did go to the windows file in the C: drive and manually installed it myself.
Thinking that it would fix my install problem.. I was wrong.. I next have
found out that in my event logger that my IIS6 is not working properly or
something. It doesn't look right and in my event logger it says my security
assessment tool 4.0 error 1303 I am the administrator and logged in already
so what the heck? And I also would like to say that my computer is old and
it's a IBM think pad running windows xp perfessio...Filename list into Excel
I would welcome help with the following problem:
I need to generate a spreadsheet that contains the filename, date created
and date modified (at least) for all files in a folder. I'm not interested
in the content of theses files, I just need the file properties in a
Any suggestions as to how to achieve this will be greatly appreciated.
I do this all the time
Go to DOS prompt,
Use Excel to open this file
Text to column
PY & Associates
"Fred" <Fred@discussions.microsoft.com> wrote ...Updating Money Deluxe 2007 question
Will Microsoft keep the Money updates available permanently, as they do with
updates for old operating systems like Windows 98? The reason I ask is
that, at least in my experience, Money updates have never been a manually
downloadable file, but rather once you install the program, Money calls out
on the Internet and looks for updates. If Microsoft doesn't keep the
updates online, is there any way to download the update files now for
I did a test. I installed Money 2007 Deluxe on my Virtual PC. As soon as I
went into the program after installation, it updated ...IE auto complete list
does nyone know how to delete auto complete information of IE or where it is
stored? I am writing a small mfc app and need to clear the autocomplete