Category color changes when changing values.
When I copy a chart I get two identical ones. When I change the values of one
of the charts and sort the values, Excel changes the colors of the categories
to a preset order, so that the color of the biggest customer in chart 1 is
not the same as this same customer (let's say now on the third place) in
Is there a way to prevent this?
...How to see calculation and heading in same cell.
I would like the cell to perform a calculation and then display the answer as
will as a heading. In other words the answer and the heading will appear in
the same cell.
Perhaps you mean something like ="Heading Name: "&A1+B1
"Jeracho" <Jeracho@discussions.microsoft.com> wrote in message
> I would like the cell to perform a calculation and then display the answer
> will as a heading. In other words the answer and the heading will appear
in...Failure to Display anything but Methods in Microsoft.CRM.Proxy.dll
I'm using both VS.NET and VS.NET 2003 to attempt to run the "Find all the
Incidents for an Account or Contact" code on MSDN
I've added the reference to Microsoft.CRM.Proxy.dll and also have attempted
to use the Microsoft.CRM.ComProxy.dll when the first failed.
I am unable to compile as the C# compiler states that both ".Credentials"
and ".Url" are not valid properties of the Microsoft.CRM.Proxy.BizUser
I used the o...How can I Enable a Check Box based on another fields value?
I have a form with a disabled check box. I need to enable it when a certain
value ("approved") is selected from a combo box.
When I am in Form Design View and I have the Check Box selected the
Conditional Formatting menu item on the Format menu is greyed out.
I am using Access 2003.
Can you tell me what I need to do to make this work?
As you've discovered, Conditional Formatting isn't availabe to checkboxes.
Private Sub Form_Current()
If Me.YourComboBox = "Approved" Then
YourCheckBox.Enabled = True
YourChe...Newbie: can't get a calculated value on the form?
I have a table with numbers and a form that shows the numbers. I have
a query that takes one of the numbers and mulitplies it. I put a text
box on the form from the query result field, but I get a "#Name" error
instead of the result. When I run the query, I get the correct
"Ed from AZ" <firstname.lastname@example.org> wrote in message
>I have a table with numbers and a form that shows the numbers. I have
> a query that takes one of the numbers and mulitplies it. I p...Converting Values to Unicode Characters
The function CHAR converts a value in the range 1-255 to to an ANSI
character. Is there a way to convert values in the range 1-65,342 to
Gary L. Smith email@example.com
You can use VLOOKUP but you'll have to create your own lookup table of
the unicode characters and I think you'll have to paste it onto the
same spreadsheet.... Maybe you can find a lookup table on the
internet somewhere that you can easily paste into your spreadsheet.
tsides <firstname.lastname@example.org> wrote:
> You can use VLOOKUP but y...Graph Data Values
I am trying to create a pick and mix graph that shows forecast spen
against actual spend by a selected business area.
I somehow want to create a graph on the fly based on the selections fo
If I choose company one and want to see the contracted data I want th
graph to pick up the forcasted contracted Labour, Passthru and Othe
and show the combined contracted actuals; See attached;
and if i then choose company 2 then graph will pick up the releven
Attachment filename: help.zip
Download attachment: http://www.excelforum.com/attachmen...Coping part of a cell content into a seperate cell
I have two cells, one containing first and middle name and another one with
surname. I want to combine the first name and surname into a separate cell,
can you advise how I can just copy the first name and miss out the middle
I assume that the midle name is separated by a space from the first name and
is in column A and the last name in column B
=TRIM(LEFT(A2,FIND(" ",a2)-1))&" "&B2
"Caz H" wrote:
> I have two cells, one containing first and middle name and another one with
&g...Passing Values from One Form to Another Including a Combo Box
Hi, hope someone can help with passing two values from one form to
another by way of a command button. I have spent a week on various
code taken from this site, but still no luck. Please ... someone help!!
The form I am passing values from is called PATIENT HISTORY-Form. On
this form, I need to pass a date from a field called DateSFESigned and
I also need to pass information collected from a Combo box, Combo91.
The command button is called Command119.
The form that the values are being passed to is called Personal Habits-
Thank you in advance for any help on this matter.
Maurita ...Adding a formula to the same cell (H5) on every tab
I have an inventory spreadsheet with 125 tabs. The tabs are numbered
1 through 125. The are identical except for the data below the column
headings. If I wanted to put a formula in H5 on every tab, can it be
done other than manually opening every tab and typing it?
One additional question: If I add a Summary Tab, how could I show the
value of a specific cell on each tab without manually entering it? I
show the formula I'm using bring B3 to the summary for every tab:
1 Unit Value
2 1 ='1'!B3
3 2 ='2'!B3
4 3 ='3'!B3
5 4 ='4'!B3
6 5 ='5'!B3
7...Pictures/Graphics won't display on website
Help, I'm new at this and have problem getting my website
that I created in Publisher posted to web.
The site will appear when I copy the index.htm file using
my ISP file manager but not sure where the index_file
folder and related graphics/pics need to be copied to.
I tried creating a folder for index_file and copied all
the files there that appear on my c drive when I published
to the web. But all that displays are the alternate text
for each pic/graphic.
A small child turns to Ed, and exclaims: "Look! Look! A post from
I'm using these formula to count,
how do i get it so bank cells are excluded from the count. The way it is now,
they are counted in the 0 to 10 range...
Message posted via http://www.officekb.com
"jeremy via OfficeKB.com" wrote:
> I'm using these formula to count,
> how do...References omit formatting and return cell address
In two cases of references between worksheets, the formatting from the
original cell does not appear in the cell that it is referenced to.
Worksheet 1, A1 contains a currency formatted number - $2,000
Worksheet 2, A1 references the Workhseet 1, A1 cell using the = sign, yet it
returns 2000 (unless I manually reformat the Workksheet 2 cell to Currency
Worksheet 3, A1 contains an apartment # - e.g. 4
Worksheet 4, A1 references this cell but returns the cell address -
Worksheet2,!A1' - rather than the number 4. I tried different formats for the
number 4,...How can I insert a cell reference in a footer (eg for variable foo
Any ideas on how to do this?
I'm trying to create a template with the doc reference number in the footer
However, I'm trying to avoid users having to edit the footer (because this
just wont get done).
only possible with VBA using an event procedure. e.g. put the following code
in your workbook module for cell A1
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim wkSht As Worksheet
For Each wkSht In Me.Worksheets
.CenterFooter = wksht.range("A1").value
Frankfurt, Ger...How do I chart the same data cell on a range of worksheets?
I have the same row of cells on numerous worksheets that I want to chart or
consolidate onto another worksheet ?
You need to create a consolidated data range:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have the same row of cells on numerous worksheets that I want to chart or
> consolidate onto another worksheet ?
...Shading cells not working
When I try to shade cells they remain white, but if I go
to print preview the color shows. Why won't the cells
change color in normal view?
If the fill colours aren't appearing, the high contrast setting may be
turned on. There's information in the following MSKB article:
OFF: Changes to Fill Color and Fill Pattern Are Not Displayed
> When I try to shade cells they remain white, but if I go
> to print preview the color shows. Why won't the cells
> change color in normal view?
Debra Dalgleish...Counting the number cells between two dates
Hope someone can help with this, I'm pretty sure it'll be quite a simple one.
Column A:A contains a list dates, I want to use a formula to count the
number of cells which contain a date between 01/01/05 - 31/01/05.
BTW - I'm using American date formats in mine.
>Hope someone can help with this, I'm pretty sure it'll
be quite a simple one.
>Column A:A con...storing value in form field
I want to get values from a pop-up date form to insert in a text box on
another form. Problem is when I close the date form, the value that the text
box was referring to is gone. Is there a quick way to save the value in the
main form until new dates are typed in?
You should be able to hide the form rather than close it.
"ryan" <email@example.com> wrote in message
> I want to get values from a pop-up date form to insert in a text box on
> another form. Problem...problem with mulit-column value list combo box
I am trying to read the values of 2 columns of the selected item in a
multi-column combo box.
cboField1 is the multi-column combo box
cboField1 Row Source Type=3DValue List
cboField1 Column Count=3D2
gives me the value for column #1 in row #2
gives me the value for column #2 in row #1
I can't find the syntax for getting the value for column #2 in row #2.
Thanks for any help!
On Tue, 24 Nov 2009 21:38:31 -0500, Dav...How do I limit the number of characters in a cell?
When try to limit the number of characters allowed in cell by going through
the data/validation menu, it still allows more than the number of characters
than I specified. I don't get it :(
...Is it possible to measure/display the column width with a cell function?
Is it possible to measure/display the column width with a cell function?
I need to adjust some columns for a report.
But I cannot find a way to display the current width in units that I can then place in a VBA macro.
Would be very good to have the macro read the values entered in a set of columns and change the width accordingly.
(This is very easy in Quattro pro.)
Have a look at ShowWidth at:
Use non-volatile INDEX(P11:IV65536,1+w,1+y):INDEX(P11:IV65536,w+y,x+z)
instead of volatile OFFSET(P11,w,x,y,z)...textbox value from a combobox in a continuous form
I have a combobox cboOperationID and textbox txtOperationDesc in a continuous
form. User chooses an operationID in the combobox and textbox automatically
displays the description of that operationID using
Me.txtOperationDesc.Value = Me.cboOperationID.Column(1)
in the afterupdate event of cboOperationID
My problem is whenever i move to the next entry in my continuous form and
chooses another operationID from the combobox, the description in the
txtOperationDesc from the first entry also changes to that of the 2nd entry.
Message posted via http://www.accessmonster.com
There's a ...Counting # of values in a group registration
I have a small DB that keeps track of community events, where people can
enroll and attend various courses. Each course is entered into the DB as well
as each enrolled individual, with name, age, etc, but most importantly, the
individual's Province. For example, Course DF102 - Gardening, has 20 people
enrolled, with each person having the same or different province (BC, AB,
ONT, MB, etc).
What I would like to do is be able to generate a query that lists each
course, and within each course, identify (count) the number of individuals
from BC, the # from AB, etc, etc, in orde...Name Display in Address Book
I think this is supposed to be an easy one but damned if I
can figure it out..
The names in my contact list appear as last, first. I've
checked each of the folders as needing to appear in my
Address Book. However, when the names appear in the
address book, they appear first last.
How do I get the names in the address book, which are fed
by the contact names, to display in the last, first format?
Posting your Outlook version is always helpful.
Depending on your version and mail support mode of Outlook, you can sort the
Outlook Address Book this way (chec...OPOS Drivers for Emax Pole Display
Does anyone know where to get OPOS drivers for Emax Universal Pole Display #
If you have the serial version, you can use the one included in RMS. Mine is
working. At least the setup seemed to work.
> Does anyone know where to get OPOS drivers for Emax Universal Pole Display #