how do I automatically update a text box in a chart?
You can link the textbox to a cell. When you update the cell the textbox
should reflect this.
Select the textbox border and then in the formula bar enter the complete
cell reference, for example,
Andy Pope, Microsoft MVP - Excel
...data input in text box
We have a form which the operator enters data in a text box. Currently we
have a 'done' button on the form that the operator clicks to send the text
box info to a vba program. How can we send the text box info to the vba
program when the operator hits the enter key @ the end of the data entry for
the text box? TIA
In Christ's matchless name
ted & colleen
Use the control's AfterUpdate event.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"ted" <n6trf@arr...Word 2010 beta: Cannot save my Normal.dotm file
Using the Word 2010 beta on Win7. I cannot save my Normal.dotm file - at
least not usefully. I can open the file, edit it, add macros to it, whatever,
and it will save (in the folder directory, the .dotm file will show a change
in file size). But when I close Word, or if I open a new document in Word, the
Normal.dotm file is reset to the default, losing any changes I've made.
I can save and use other .dotm templates; but not the default Normal.dotm
please reply to the newsgroup...Outlook 2003 and "Check Names"
We are testing Outlook 2003 at our office now and there is
one very frustrating "feature" that is bugging all of us.
When we create a new e-mail message and type in the first
name of a person from the global address book and hit ctrl-
k to check the name...we get a response that Outlook
doesn't recognize the name and there are "no suggestions".
The only way Check Name will successfully resolve the name
is if we type it last name first (ie, Gates, Bill). This
was not the case in Office XP or Outlook 2000. You could
search by first name (or partial first name)...Excel 2007
When I select cells to copy as a picture in Excel 2007, the resolution is
terrible. Text and objects with shadow's are very blotchy when pasting the
How do you change the resolution of a 'Copy Picture'?
...Parsing data from one spreadsheet into another format
The data that we dump out of one machine comes in like below.
%AT_1300 Bottoms|Conductivity| (Water Out) InputRange VDC1to5
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Low 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) Custom_Range_Hi 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MinScale 0.0
%AT_1300 Bottoms|Conductivity| (Water Out) MaxScale 20.0
%AT_1300 Bottoms|Conductivity| (Water Out) EngUnits mhos
%AT_1300 Bottoms|Conductivity| (Water Out) StepResponseTime 1.0
%AT_1300 Bottoms|Conductivity| (Water Out) DigFiltTimeCnst 0.016
And I need to convert this data to this f...Rollup 2 and Office 2007
I already have Roll Up 1 and the Office 2007 compatibility patch installed.
If I now install roll up 2 will I have to reinstall the office 2007
MS CRM Certified Professional
Chat with me on MSN / Gmail / Skype : ID Is :.. firstname.lastname@example.org
> I already have Roll Up 1 and the Office 2007 compatibility patch installed.
> If I now install roll up 2 will I have to reinstall the office 2007
...Outlook 2003 keeps crashing #2
I get this message when I look in System information. Outlook keeps
crashing quite often. I cannot for example delete two messages without
outlook crashing. My colleagues do not have this problem. We are using
the Microsoft mail exhange server.
Faulting application outlook.exe, version 11.0.5510.0, stamp 3f1380f0,
faulting module mso.dll, version 11.0.5606.0, stamp 3f334cce, debug? 0,
fault address 0x003b6e16.
Does anyone has a solution?=20
1) I would definitely apply Service Pack 2for Office 2003 + applicable
critical security updates.
2) Have you tried starting O...Password Issue with MS Money 2003
I am not familiar with newsgroups but I hope it is a forum
to seek assistance. I am unable to reach MS support via
email from my home computer on this issue. My Money 2003
requires a net passport password to open my account in
Money that I have successfully accessed for approximately
12 months. It does not recognize my password now. I
have attempted several times with my existing password,
changed my net passport password, even uninstalled and re-
installed MS Money 2003 to gain access to my account.
Nothing has worked. Each time it states I have failed to
enter the corr...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...Auto-format in Microsoft Excel.
Each time i try to enter a number range, for example, 8-
10, in Excel, it constantly re-formats it to a date. If I
change the formatting to "General" it turns it into a
random number, usually 38209. I would like to turn off
ALL auto-formatting, but that's probably asking too
much. How do I disable this frustrating feature?
When you enter "8-10" in a cell, that's not strictly a number but Excel
thinks you mean a date so converts it as such.
A date is a number and in your example the number 38209 represents August 10
2004 which is not a ra...How to keep format when importing Excel into SQL.
Can anybody help me please?
When I import Excel file into SQL, a field that formated as 0000000000
(custom), loosing leading zeros. I tried to change data type in SQL after
importing. No luck.
I appretiate any help.
See if using IMEX=1 helps:
I tried this, but got an error: "The OLE DB provider
"Microsoft.Jet.OLEDB.4.0" has not been registered."
Thank you very much for looking into this.
"Plamen Ratchev" wr...How to change font size on formula bar in Excell 2007
I don't find Tools>Options>General (as suggested in other post answers) in
Excel 2007. On the Office button there is an Excel Options but it doesn't
provide a method of changing font size on the office but. My font is so
small I can barely see it.
Office button>ExcelOptions>Popular tab>in the "When creating new workbooks"
section, choose font and font size
Microsoft MVP - Excel
"jimwillie" <email@example.com> wrote in message
news:588AAC05-0F52-404E-AA01-128E70E02D0B@microso...Radar chart in Access 2007 report
Can you add a Radar chart to an access 2207 report?
...[Exchange 2003] Mail enabled public folder and sender address
I have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
How can I accomplish this?
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...Outlook 2003
we have one client pc with Outlook 2003 where the following problem
if a mail is replied from a user created sub folder of the inbox, the
reply will not appear in sent mails, but will end up in the same sub
folder, sender and recipient appear as identical. The mail goes out
properly though, it's just that Outlook sets internally sender =
recipient and bounces the reply back to the subfolder in which the
original mail is stored.
This happens on a Win 2000 machine with SP4 and all updates, the other
clients use Outlook 2000 or XP and there is no such problem.
There are no ru...Install Exchange 2003 Server on new Hardware with same name
I got a new server to move my Exchange Server Installation. I want to
keep the name I'm using now for my Server. Already read TechNet Article
"How to Move Exchange Server 2003 to New Hardware and Keep the Same
Server Name". Is there anything else that I should be aware of that is
not on this TechNet article? I'm using a different Disk Configuration,
does this matters? Should this be a smooth process?
Thanks for any help you can give.
The drive letters MUST match, because the paths of the databases are at the
Active Directory. The disks can have different sizes than the or...formula based on format
Is there a way to have a formula that is based on a cell colour or based on
the way a cell is formated? I need it to count the number of occurrences
that this happens.
Thank you for your time.
you'll need VBA. See for an example:
"James Kendall" wrote:
> Is there a way to have a formula that is based on a cell colour or based on
> the way a cell is formated? I need it to count the number of occurrences
> that this happens.
> Thank you for your time.
> Windows NT
> Office 97
This ..."Save" preferences getting lost
I work on long documents and want to save my work frequently.
Every time I set the "Save" preference to a brief interval like
five or ten minutes, the preferences seemingly resets itself to a
default of thirty minutes.
I'm using Word 2008 for the Mac on an Intel running 10.6.2.
Thanks in advance for any thoughts.
- Mark Pavlick
That indicates that your user ID does not have permission to write to the
preference file that Word is using, or that something is replacing the
With the help of your System...Addressing within Exchange 2003
We are running Exchange 2003 SP2. We setup an MX record for a external
email(alumni.cup.edu) these mailboxes do not exist within our exchange org.
But when we send email to these externals email mailboxes we are getting the
#5.5.0 smtp;550 Mailbox unavailable.
Is there a way in exchange to ignore these email address so that we don't
get the NDR from within our Exchange Org?
On Fri, 4 Aug 2006 08:08:02 -0700, Sabo, Eric <firstname.lastname@example.org> wrote:
>We are running Exchange 2003 SP2. We setup an MX record for a external
>email(alumni.cup.edu...how do i add "Software Digrams" Folder in my Visio 2003
how do i add software diags folder in visio 2003 version. Like if i go to
File->New it shows folders like brainstorming, project schedule, block
diagrams but in my case its missing the Software Diags folder which contains
activity diags, web mock ups, use case diags etc. please let me know how to
get that template. thanks.
What edition of Visio are you using? Check by going to the About Microsoft
Office Visio dialog from the Help menu.
"Ankur" <Ankur@discussions.microsoft.com> wrote in message
> how...Phone number normalizing and auto-formatting
I really appreciate the way that Outlook auto-normalizes phone numbers -
for example, here in the US, I can enter 5555555555 and Outlook
automagically formats that to (555) 555-5555.
Why CRM 3.0 doesn't do this out of the box is strange but if anyone has
ideas on how to implement, that'd be greatly appreciated. I've worked very
hard to normalize all my data before import, but I know it's a matter of
time before our users (ok, our sales people) destroy all that hard work by
entering garbage into every phone field entry that the system cannot
auto-normalize and error ch...Grammar check not working
I am using Word 2007 and have a problem with grammar and punctuation errors.
I deliberately put two spaces between words, do not put space after a comma,
write long sentences and finish a sentence without a verb but the green
underline never appears. The spell check is functioning properly, no problem
with that. In Word Options > Proofing, "Mark grammar errors as you type" is
selected. I changed that selection and tried again but it still did not work.
I used different languages as default language but no change.
I would be grateful if someone could come...Lookup text with multiple search criteria
I know how to look up data and text using vlookup and hlookup, what I'
like to know is whether there is a way of looking up data based on mor
than 1 search criteria; for example
If I wanted to look up an item in a 4 column database, I'd us
something like this:
But that only looks for Apples. Say I wanted to lookup data based on
subcategory of Apples, e.g. colour.
If it was a number, I could use SUMPRODUCT and (assuming named range
were in use) do it like this:
But obvio...Office 2003, Outlook (Outlook Today)...
OK, this is driving me nuts.
I note that w' 2003 (and XP (2002)?) the default install sets the
startup folder to the Inbox.
IIRC, one of the earlier Offices installed Outlook to startup w' that
"all in one view" - Outlook Today.
So just as a wee test - I thought I'd try that for a while, and indeed I
found it quite handy to be able to see all pertinent data on the one
*However* (and I'm wondering if this is the case with others), I *HAVE*
to use my mouse, whenever I switch to the Inbox, or Calendar, or Tasks
to get the damn focus onto a 'sujbect&...