check box value
Help. I am creating an order form for my customers. We have a standard
product and then a few options. Rather than have my customers type the price
of the options in (& risk holding up an order due to incorrect pricing), I
want them to select a check box. When "red hats" are checked I want $1.00 to
show up in AE20 and when "green hats" are checked I want $2.00 to show up in
I guess I want a set value to populate a cell when a box is checked.
right click on your check box and go to format control
select ad20 and ad21 as your cell link,in ae20(and similar ...Excel Automation problem
I have a problem in my MFC class library (VS2003) w.r.t excel automation.
I open an excel file to grab some data and close it. When the user
clicks the button to open another excel file, the file that I previously
used is show in an excel window that opens... (i NEVER want excel to
My interface to the excel automation is implimented through a singleton
I think that the focus of excel (even though the visible property is
FALSE) is being propagated to the top when focus is lost on my app
(focus going to the open dialog). Trying to set breakpoints i can se...Hiding rows based on cell value
I have a spreadsheet with a column of dates. I need to write code to
hide all rows that are outside of a range of dates that I input as a
"start date" and "end date" via 2 input boxes.
*** Sent via http://www.automationtools.com ***
Add a newsgroup interface to your website today.
One simple answer would be to use a 'helper' column at the end with a formula
that looked at the dates and based on your criteria either returned an OK or
HIDE. Then just do Autofilter on that column selecting OKs. The HIDE value
would prompt you to redo the filter if dat...excel to merge for labels in windows
I have been given a Excel spreadsheet and need to print labels with the
information and i am new to excel. I am trying to get the ionfo to word,but
the information doesn't not transfer over.
Find a tutorial here:
In article <227EEA8C-C116-4FEB-B660-9E8578673EF3@microsoft.com>,
"water" <firstname.lastname@example.org> wrote:
> I have been given a Excel spreadsheet and need to print labels with the
> information and i am new to excel. I am trying to get the ionfo to word,but
> the information doe...Visible by code
I have a form called sfrm_status_of_lif_notes. In this form there is a text
box called status. This text box is bound to a previous form.
In the Detail of the form I have a text box called approved_dt. I have the
visibility set to No.
I would like approved_dt only to be visible if the status is "Approved"
I tried this in the On Open event of the form:
Dim blnVisible As Boolean
blnVisible = (Me.status = Approved)
Me.approved_dt.Visible = blnVisible
It did not work.
Does anyone have any suggestions?
Message posted via AccessMonster.com
http://www.accessmonster.com/...Creating A Total Based On Multiple Conditions
I'm working on a spreadsheet and my head has nearly exploded fro
The problem is, i need the spreadsheet to count cells in one column bu
only if they hold certain data from another cell.
I found one sample formula which is:
but it doesn't seem to work, i'm quite new to excel so maybe i jus
don't understand it, so explaining what it means would be good.
Erm...... does that make sense????
Can anyone help before i go totally insane? :confused
Message posted from http://www.ExcelForu...only visible if...
I'm self-teaching on Access as I develop a client tracking database
for my facility. I'm probably going to say this wrong, but here goes.
I have a report where I only want to have a particular field
(control?) visible if the data in the field it is boud to says a
The control is in the Detail section of the report, and it's called
Discharge Reason" It refers to a field with the same name in the
query the report is bound to. There are 8 possible entries for this
field, plus "Contract Change" That's the only one I want to see in my
repo...Arabic text in Word
> Ce message est au format MIME. Comme votre programme de lecture de courriers ne comprend pas
ce format, il se peut que tout ou une partie de ce message soit illisible.
I am using the French edition of Word 2004 for Mac (version 11.3.8)
under Mac OS 10.4.11. When I paste Arabic text into a Word document, from
TextEdit for instance, it exits unexpectedly. If I write directly into Word,
the letters are not attached. Would you know how to solve this problem ? I
reprodu...Combining Text with Formula
Is is possible to have a cell contain text information and
then a lookup to another cell.
"The age of this person is " plus the result of another
cell that calculates his age so that cell would read:
"The age of this person is 72."
Thanks for any help you can give me.
=The age of this person is "&B1&"."
where B1 holds the calculation.
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com
"DebraAnn" <email@example.com> wrote in...Set number format based on cell contents
I have a cell B3 which shows a Data Validation list of £ or %
Having selected £ or % in B3 the user then enters a number in C3. I want to
have cell C3 formatted to General if B3 = % and formatted to Currency if B3 =
I'd really appreciate some help
You need VBA for that. Paste the following macro into the sheet module for
the sheet you are working on. To do that, right-click on the sheet tab,
select View Code, and paste this macro into that module.
Note that this macro does exactly what you asked. That is, it will change
the format of C3 if you select $...Pop up
I have a pop up form from the main form to key some additional info in the
same field that's on the screen in the main form. I have filtered it for the
secondary form incident no to match the main form incident no - when I try to
save the record in the pop up form I get an error - changes I requested would
create duplicate value - can't save.
Can anyone help?
On Fri, 25 Jan 2008 08:43:02 -0800, Bonnie <Bonnie@discussions.microsoft.com>
>I have a pop up form from the main form to key some additional info in the
>same field...>> Visible and not visible
Hi, using Access 2003. I have 2 groups of controls on a form. Based upon user
selection either one or both groups of controls may be visible. Layout
1. one group next to the other group. Visually it looks strange if only the
right side group are visible (ok when only left side group visible).
2. one group below the other group. Visually it looks strange if only one
group are visible (ok when both groups visible).
Is there a way to close the gap when only one group of controls are visible?
Any ideas or suggestions appreciated :-)
you can wri...repeated text
how can i find repeated text on a spreadsheet, for example, i have a list of
names that and i always update it with new names. Some of the names are
repeated. how can i find the repeated names without looking in the entire
"maria" <firstname.lastname@example.org> wrote in message
> how can i find repeated text on a spreadsheet, for example, i have a list
> names that and i always update it with new names. Som...Borders with aligned text
I dont think this is possible but I have changed the alignment for the text
in some cells to 60 degrees but I want the borders to remain around the
original normal cell rather than the aligned one. Does anyone know if there
is an option I caan change to make this happen?
I don't believe there is any standard option to do what you ask. There are
not 2 cells in place of 1 when you apply the rotation alignment. The cell,
itself is actually rotated and the rectangle that appears when you select one
of those cells is simply a 'placeholder for the rotated cell. Per...text wrap in merged cells #2
Thanks in advance for you help,
I am creating a template which will be used to track large accounts. Text
will be entered directly into cells, and most of the text will not require
the row to expand in size. For the cases where I need an unlimited amount of
room for text entry, I merged the cells across most of the printable field
and then checked text wrap, and align left, but I can't get it to work. In
addition I have formatted the rows to allow autofit, so then can expand
automatically. What do I need to do to fix this simple problem?
It's not all that si...how do I prevent Excel from spilling text into adjacent columns?
When I have columns that are skinnier than the text they contain, the text
spills into the adjacest column(s). How do I prevent this? It makes the
spreadsheet very messy looking when I squeeze the columns to get an overview
of the spreadsheet.
format these cells with word wrap ('format - Cells - alignment')
> When I have columns that are skinnier than the text they contain, the text
> spills into the adjacest column(s). How do I prevent this? It makes the
> spreadsheet very messy looking when I squeeze the columns to get an overview
> of t...Limit rows in subform based on field in main form
I have a main form that has a number field (this field inidcates the number
of seats available). I want the subform to only allow the user to enter data
in rows that are equal or less than than the number field in the main form.
please help with code and best place to enter.
>I have a main form that has a number field (this field inidcates the number
>of seats available). I want the subform to only allow the user to enter data
>in rows that are equal or less than than the number field in the main form.
>please help with code ...Graph in Excel has one data label missing
I havea very simple chart made into a graph. There is one data label that
does not show. All of the others are fine. How can I get it back. I checked
the table and the data is there... the bar is even there but no label.
Thanks to anyone that can help.
Single click the series, then single click the data point. Then choose
Format, Selected Data Point, activate the Data Label tab, and turn on the
check box beside the option you want displayed.
> I havea very simple chart made into a graph. There is one data label t...Trying to Change a Value in the Item Type Drop-Down on Item Maint
I have been trying to change the string displayed for one of the values in
the Item Type field. I'm trying to replace "Kit" with something else because
of some of the confusion that word causes. I can get to the list of values
for the Item Type field and replace the "Kit" value with something else, but
then I can never save the change.
Any ideas? Thanks in advance.
Open Modifier and locate the word "Kit" under the String resources. You can
replace this word system wide.
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
...Text in cell is not visible! 8(
My cell is formatted to accept string type data. However, if
the text length is bigger than the cell length then all I see are
a bunch of "##################" characters in the cell.
Can't Excel just show the text that fits in the cell and
possibly clip off the text that extends beyond the cell??? How
can I do this?
Try changing the format to General.
Excel has trouble strings between 256 and 1024 characters in cells formatted as
Robert Crandal wrote:
> My cell is formatted to accept string type data. However, if
> the text ...Can you input multiple series names and values with a single defined name ?
In Excel 2007, is it possible to create a dynamic chart with defined
names without having to enter each individual series ?
For example, the Horizontal (Category) Axis Labels can be input with a
single defined name.
A defined name could be used to specify B1:D1.
However, it appears that if you want to enter in the Legend Entries
(Series), you have to do them one at a time.
Series Name = A2 and Series values = B2:D2 (this part could be a
Is there an easier way to enter multiple series at once ?
A B C D
1 May 1 May 2 May 3
2 Apple 1 3 6
3 Orange 2 6 18
4 Peach 3 9 27
E...LOOPKUP 2 values in array
The table has dates in the columns and names in the rows
An x indicates who's on duty that day.
.............01-10-2004 ... 02-10-2004 ... 03-10-2004 .....
Katia .................................................. .x
When I type a particular date, Excel should show the name with the x
Who can help me solve the problem?
I have no knowledge of VBA code
digicat's Profile: http://www.excelforum.com/member.php?actio...creating labels
hi, how can i create labels so I can input about 100 names and they will
print off in a label style, Ive tried everything please help!!
\m/ O_O \m/
Laura, I would do a mail merge with word,
For help on Word mail merge using Excel as the data source have a look here
Always backup your data before trying something new
Please post any response to the newsgroups s...Printer fonts not visible
I did a report a while ago set to Epson LQ-1050 and using the hardware fonts
to speed up printing. Recently I had to make some changes to report but the
problem is that the hardware printer fonts do not display in the fonts drop
down in report designer even though I select the Epson LQ-1050 printer. What
is the problem and how can I fix it?
...peak to peak values
I have a line chart with many peaks. What I would like to determine is
the peak to peak values. I have tried this forum but no luck. Can
Do you want to identify where the peaks are? what the magnitude is of
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> I have a line chart with many peaks. What I would like to determine is
> the peak to peak values. I have tried this forum but no luck. Can
> anybody help?