Is there anyway that I can have several lists in a given worksheet so
that they act independently on each other, not simply dependent on the
primary list? I would like to select certain info from one list,
certain info from another, and so forth, without being limited to the
info soley in the row of the initial info selected. Help!
"Corey" <firstname.lastname@example.org> wrote in message
> Is there anyway that I can have several lists in a given worksheet so
> that they act independently on each other, not simply ...Randomly selecting items from a list given their statistical likelihood #4
That is basically what I did do without the sort - perhaps that wil
save time when running the macro as opposed to an additional fe
columns, but the 6 selections would not be independent cause say a 1 i
10,000 shot couldn't then be selected again with a sort. I can and hav
done this but it often overloads the ram use and crashes the computer.
I am trying to avoid doing any rand() step because it would requir
creating new lists. I will also be performing the a random selectio
based on the individual clients historic product useage, which woul
require me to restack a new 10,000 item lis...Dropdown button in a toolbar control
I'm trying to implement the dropdown button in a toolbar control. I try
to handle the TBN_DROPDOWN message with the ON_NOTIFY macro:
ON_NOTIFY(TBN_DROPDOWN, AFX_IDW_TOOLBAR, OnToolbarDropDown)
afx_msg void OnToolbarDropDown(NMTOOLBAR* pnmtb, LRESULT *plr);
and get the following error:
error C2440: 'static_cast' : cannot convert from 'void (__thiscall
CMainFrame::* )(NMTOOLBARA *,LRESULT *)' to 'void (__thiscall
CCmdTarget::* )(NMHDR *,LRESULT *)'
Does anyone know how to fix it?
Here's something to try... Change the function to be...Default view of Investment Account in Account List
I work out of the Account List in the Banking tab, which is my opening
screen. When I click on an Investment Account, the default view is the
Investment Transactions, not the Account Summary or the Cash Transactions.
This is not very logical and highly irritating. The most logical default
view would be...Account Summary. Is there any way I can change the default
view to Account Summary when I click on an Investment Account?
I know I can get this view in the Investing tab, but I must click through
even more irritating MSN ads, in the software I paid alot of money for, to
get to that ...Capability to Print Lists
Version 8.0 was released with a number of lists (Financial, Sales, etc.). We
would like the capability to print these out.
It may even be nice to export them to Excel or Word (similar to SmartList).
Please consider adding this functionality.
Thanks for the suggestion. Is there a specific reason why you just wouldn't
use SmartLists to accomplish this? Thanks.
This posting is provided 'AS IS' with no warranties, and confers no rights.
"Sharon Nolan" wrote:
> Version 8.0 was released with a number of lists (Financial, Sales, etc.)...Bold the query based distribution lists in GAL
Just curious if anyone knows of a way to make the query based distribution
lists appear bold in the GAL? Since our GAL contains query based lists and
'static' lists I would like all of them to appear in bold if possible.
On Tue, 27 Dec 2005 13:10:23 -0800, "Papa"
>Just curious if anyone knows of a way to make the query based distribution
>lists appear bold in the GAL? Since our GAL contains query based lists and
>'static' lists I would like all of them to appear in bold if possible.
I d...using new List<String>();
I wonder do I create a memory leak by using
private void myFunc()
List<String> joblist = new List<string>();
// ... add a alot of string into the joblist
and then call myFunc "repeatedly" from the main program
It feels like I should return the memory somehow, but how?
English is not my first language
so any error, insults or strangeness
has happend during the translation.
Please correct my English so that I
may become better at it!
On 5/26/2010 11:02, Anders Eriksson wrote:
> I wonder do I crea...maximum size of the block senders list (Outlook 2003)
Does anyone know the maximum size the block senders list
can be in outlook 2003? I have about 32000 block email
and domain addy's but the list keeps disappearing and I
have to replace it or re-import it. Does anyone have
reason for this? I have an antivirus program and it is
updated and no I do not have a virus or any spy ware
computer is scan nightly
POP3/IMAP or Exchange account? The reason that I ask is that I might have a
long shot of an idea for an Exchange account, but can't think of anything
locally. The long shot for the Exchange account is the last section of the
IMF...Add an option to choose multiple choices for a list/drop down.
I need to be able to assign multiple choices for a particular record. As an
example: I need to select which brands a store carries for marketing reasons
from my list of all potential brands I would select "Nike", "Addidas", "New
Balance" but not include "RBK", ...
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 M...moving range of data listed up/down to across
I have a range of data entered in range A:1 thru A:26
I would like to move the data so it appears on one long line going
across instead , say line 1 columns A - Z.
I am using excel version 97.
Thanks for your help.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
If you copy A1:A26 using paste special, check the box Transpose and this
will copy the data across the sheet.
Note you should copy this to B1 and then delete column A if this is no
Ho...OL 2007: Change priority of list of tasks
How can I change the priority of a number of selected tasks at once,
similarly as I can change their category at once? Thanks, Sven
...How can I add shared tasks to the Outllook to do list ?
I have an additional Shared mailbox in my outlook profile which I need to
keep track of the tasks. Is there a way in which I can add the "shared tasks"
to my outlook to do list?
"mark" <email@example.com> wrote in message
>I have an additional Shared mailbox in my outlook profile which I need to
> keep track of the tasks. Is there a way in which I can add the "shared
> to my outlook to do list?
The To Do pane can show data only from your default fol...Distribution List.
Is there any way in Outlook 2002 to send an email to a distribution
list where the recipients do not see who else the email has been sent
to besides using the BCC field?
No. Why would no not use the BCC field? That is its sole purpose.
<firstname.lastname@example.org> wrote in message
> Is there any way in Outlook 2002 to send an email to a distribution
> list where the recipients do not see who else the email has been sent
> to besides using the BCC field?
Russ Valentine...The address list could not be displayed ...
When I click Tools/Address Book or To: in a new email, I get an error
message saying "The address list could not be displayed ... Contacts folder
could not be opened"
The .PST file is in the default location and all of my contacts are
displayed when I click Contacts on the on the Folder List.
Only the same ones posted here every day: Configure your Outlook Address
Details on how to do so depend on your version and the steps you used to
disrupt the service in the first place, none of which you provided. There
are too many possibilitie...Drop down list #11
I want to know how when I create a drop down list the font changes instead of
just been Arial.
If you use a combobox from the control toolbox toolbar, you can change the font
(for all the entries).
Just click the Design Mode icon (also on that control toolbox toolbar), then
right click on the combobox and select properties. Click on Font and click on
the ellipses button to the right.
> I want to know how when I create a drop down list the font changes instead of
> just been Arial.
> Any ideas?
...convert a list to count by county
>From what I'm hearing, they say Excel is limited only by one's
imagination. I can't imagine how to do this, so perhaps someone would
be willing to help me!
I've got a list of 700 county names. How hard would it be to convert
that list to a count by county. In other words, when all is said and
done, I will know how many entries I have for each county. In the past,
I've used SAS - I'm trying to reduce my dependence on this software and
Take a look at Pivot Tables. See
for a good starting...Times list top 15
Here is my problem. I got some help before, but it isn't working.
I have a database with kids' times for each course that we run. Each
year they may run a course several times. The information I have in
the file on them is Name, Grade, Course, RunTime, RunYear, Male/
I am trying to get a list of all of the top 15 times in a particular
But since there are multiple entries for a kid on each course, I get
SAvannah 2006 17:30
Savannah 2005 17:32
Savannah 2006 17:45
Stepahanie 2007 17:48
Kristina 2007 18:01
Stepahnie 2006 18:03
But what I wa...HQ hanging on refreshing lists
After installing the last hotfix on HQ and at the stores, HQ manager now
displays "Refreshing Lists..." about 10 times a minutes in the bottom left
status bar of HQ Manager anywhere from 3 to 15 seconds each time, during
which HQ manager hangs. (We have 40 stores and separate comm servers)
Does anyone know how to fix this, as using HQ manager has become extremely
tedious and unstable.
u can change the list refresh rate by editing the following registry value
while the HQ Manager is closed: -
I created a KPI list based on a task list, where I added a "completed on"
column in order to compare with "due date" column.
How should I tell the KPI list to produce the percentage of those tasks
where task "compelted on" column is equal or less than "due date"?
In order to do this computation you have to know two numbers:
Number of tasks done on time
Number of tasks not done on time
Both these numbers would be an aggregation of the entire list.
SharePoint does not provide, out of the box, this sort of aggregate
comput...Backing up Master Catagories List
Hi, Outlook 2003 w/all updates on XP with all updates.
I had to repair Office, unrelated to Outlook, and in the process lost
all my custom catagories in the Master Catagories list. I manually
added them all back in, so all is fine now - but is there a way to
back up the Master Catagories list? Or, is the list included in the
..PST file? If so, can I copy my .PST flies off to an external drive,
then copy them back after doing something like an Office repair?
Marti, you wrote on Mon, 04 Jun 2007 08:42:03 -0400:
> Hi, Outlook 2003 w/all updates on XP with all updates.
&g...Creating Categories from a file listing
I'm very new to Outlook scripting (so new I've never tried it), though
have experience with VBA, and windows script host etc.
I have an excel file with a listing of some categories that I want to
'import' into my, and others, outlook. We are not joined to a domain,
though we do have an exchange server (on SBS).
The list looks a bit like this (it mirrors our file system folder
etc ad nauseum.
How would I create some programmatic way to make sure all of our Master
Category lists remain the same? A...Is there a way to build a 'master list' of holidays and have that picked up on individual Outlook calendars?
> Any suggestions?
> Thank you.
See if http://www.slipstick.com/calendar/holidays.htm#company helps.
PS: Pls post by putting a summary of your question in the subject line &
full details in the body of your message. Thanks!
Thank you for all the replay.
I followed the instructions and created the form. After I clickd on the
"Add Holidays" button, nothing is happening. Please help!!
"bj" <bj@msn,com> wrote in message
> Any suggestions?
> Thank yo...membership list
Friend of mine manages the membership list for a club, about 500 or so,
using Excel as the program.
It contains the usual; names, addresses, phone numbers, skill levels.
Presently there are five levels.
As can be expected, the list constantly changes with members moving to
different levels, coming or leaving the club. There has to be periodic
reports to the executive of the numbers in each category.
I suggested adding a couple of blank lines after each category and using the
CountA function to count the number of members in each category but I'm not
very good at Excel either.
The...Customer mailing list Labels
I want to create labels to mail shot our Customers.
This is easy enough using the Crystal Reports but I have a licensed test
copy on my Laptop that shows the Label sheet with 3 columns, as I would like
it, however, on my live system it only shows with 2 columns.
I have copied my Crystal Reports folder onto the live system and restarted
RMS Manager and it hasn't changed the format at all. I wondered if the
Administrator Configuration Paths were pointing at the correct folder and it
was but i reassigned it anyway and it still doesn't work -- any ideas
Thank...List box in tool bar
I was wondering if following is possible in a XLL using Excel
1.) I want to add a tool bar using Excel C API which contains a list
box. List box must be having some predifned values say "Item1",
"Item2", "Item3", "Item4" etc...
2.) Whenever user chooses something from this list box, value of that
item should be displayed in the message box(alert). e.g. if user
chooses "Item2" from list box
then a message box should display to the user saying "You have
choosen item2 from list box".
Is it possible to do it...