Adding some values on a sheet???
Hello and thanks in advance. I'm working on a calculator for some Cable TV
plants designs. Here is what I need:
I'd like to have a drop down menu with several different values of design in
it. When I click on a value, I'd like it to insert some "value specific"
numbers on this type of chart below......
Any ideas on how I go about that and where to insert and store the info for
each type of "value"
Hudson Falls, NY
Hi Doug Strinz,
Assume that you have a worksheet named 'master'. On ...How to draw 2D values to windows screen??
Suppose now I have a 2D array containing binary values only (1 or 0). I would
like to draw these values on the windows screen (created by MFC dialog-based
app in MSVC++ 2005) with 0 be black (0, 0, 0) and 1 be white (255, 255, 255).
Which MFC class and function should I use to achieve this effect??
Newbie Question wrote:
> Suppose now I have a 2D array containing binary values only (1 or 0). I would
> like to draw these values on the windows screen (created by MFC dialog-based
> app in MSVC++ 2005) with 0 be black (0, 0, 0) and 1 be white (255, 255, 255).
> Which MFC class a...OWA Issue #2
I have some internal and external client that can connect
to the owa side but get errors on the page which stops
them from accessing mail and vieng anything but the
All the clients are running eplorer 6 with all the
service packs. The look identical in every way
Sounds like there may be some issues with either the Security or Privacy options in Internet Options. I'd check the configuration of a working workstation then compare it against a workstation that isn't working. Also what what particular error message are they getting on that page?
>-----Original Messag...Cannot access macros, security settings or VBA editor in OL 2003 #2
I've run into a problem on 3 separate machines (of 75) where the user cannot
access the macros, security settings or VBA editor in Outlook 2003. The
menu items are there but clicking them has no effect.
Researching this on the net there are various options. I've tried the
detect and repair office and fully uninstalling and reinstalling Office to
If I delete the user profile from the machine, and recreate it, or logon as
it starts working again.
Does anybody have any ideas, I'd prefer not to have to go round each machine
and reset the profil...borders #2
In a spreadsheet, we have placed "broken-line" borders in red to make them
stand out. What I want to do is to make those broken-line borders crawl
while the viewer is looking at the spreadsheet on the monitor. How can I
make that happen? I think they are called "running ants" or "crawling ants."
I think you mean "marching ants" which you see around a copied but not yet
Also called a "marquee" which is the proper name for it.
You cannot replicate this with borders unless you used VBA code which would
render your sh...text value
I need to rank a column containing concatonated names and addresses. Ranking
only handles numeric values, is there any way to give text a numeric value?
It would have helped to see some test data but let's start from here.
With your data in column A starting in A2 enter this in b2 and drag down
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
> I need to rank a colum...Value Axis Scale Change Problem #2
Thanks Jon - problem solved
dp_fulcher's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=969
View this thread: http://www.excelforum.com/showthread.php?threadid=27033
...Shipping document #2
I am using GP 10 with the Country/Region Selection as United States. Since I
have a peculiar requirement for shipping documents. I came to know regarding
German Shipping documents which will suit my requirement exactly, but it
requires Germany as Country/Region Selection.
Is there anyway to use this Germany shipping documents eventhough my
installation is United States? Anyone has that chunk file which will work in
United States installation?
Thanks in advance.
...2 further: capture Event from MS Web browser (shdocvw.dll) 2
Thanks for your guidence...
>Another way, as shown by Paul Dilaschia might work for you. He
>discussed it few years ago in MSDN:
>He simply subclasses the IE window and traps some messages. I suspect
>it will do what you are looking for.
I have looked that example it was something i was looking for... But
..... My primary concern is to display MS Office documents and PDF
document. I have tried to load such documents And they were loaded but
was getting crashed In d'tor.... ?
Another thing that als...How to retrieve value from specific cell value?
Does anyone have any suggestions on how to retrieve value from specific cell
value with specific worksheet?
I would like to create a if-statement within macro,
If specific cell within specific worksheet = 1 then
process following code
Does anyone have any suggestions?
Thanks in advance for any suggestions
If Sheets("sheet1").Range("A1") = 1 Then
MsgBox "run code"
MsgBox "skip code"
> Does anyone have any suggestions on how to retrieve value from specific cell
&...Item Value List vs Item Movement History Report (including cost)
I have been trying to create reports for previous points in time, but I am so
confused at this point as to what is what. I've ran an Item Value list, which
shows the current value of items, and got an extended cost. Then I ran an
Item Movement History Report that includes cost with a filter that begins
before the store opened and ends today. The extended cost in this report was
very close, but not the same as the extended cost in the Item Value list. Is
there something that the Item Movement History Report takes into account that
the Item Value list doesn't, or vise versa? Beca...Multiple Value Lookup field
I need to add multiple values to a look up field and I just found out that
new to Access 2007 I can add multi-values to my look-up fields. I just tried
doing this, but for some reason in the look-up wizard there is no check box
that says "Allow Multiple Values", so then I went to the Lookup tab in the
field properties to see if there was an Allow Multiple Values property and
there was none. Not sure if this would mean anything, but this table was
converted from Access 2003 to Access 2007.
Why do I not have this option and what I can do about it?
On Mon, 12 Nov 2007 12:58:0...Very new to Excel #2
Thanks everyone for the help.
It worked great.
This was easier than I thought. I assumed I had to manually change the
next columns letter. Ie... B - C - D - E...
Excel did it all.
I'm learning... :-)
I'll probably have more questions as I learn. I use Excel a lot in my
Thank you all again.
...File Name and Path #2
Is there a way to add the path to a file name in an Excel
footer? We are using Office 2000. Thanks.
See John's tip on this for Excel 97-2000
Excel 2002/2003 have this option build in
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
"Stacy O" <email@example.com> wrote in message news:firstname.lastname@example.org...
> Is there a way to add the path to a file name in an Excel
> footer? We are using Office 2000. Thanks.
You can use VBA to set th...Unique Values from Access
I'm trying to create a validation list with data from access. The code
below already do it, but I have a big problem: in the field of access
database I can have duplicate data...
year_month year_quarter year
200701 200701 2007
200702 200701 2007
200703 200701 2007
200704 200702 2007
And the code below brings duplicate data. How can I solve this
I wouldn't like to bring all information to excel ...Comparing Data in Excel #2
No, I did see this link. It seems these instructions are for whe
you're looking at one column of data only. I've tried to manipulat
the formula to include two columns but I've been unsuccessful a
getting a formula that works
Pree's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1481
View this thread: http://www.excelforum.com/showthread.php?threadid=26684
You can concatenate cells with a formula like:
But I'd use a separator between those cells so you d...Default values
How can I set up default values for text box fields for new records?
Fore example: I would like to set up default value for Country so when user
creates new account - country field is populated with that vaue.
You would need to use a picklist field instead of a text field and
add a value for each country. You can then set the default country.
This is all done in Systom Customisation > Customise Form.
Other than this you could use a workflow based on Account Create.
Insert a condition to check the country field is null, and insert an
action to update the country fi...Populate cell with a value if another cell has a certain value
All, good morning. i have a issue, i need to populate cell E4 with a value
CX/025966 when cell F4 has a text Bond Street.
Is there a simple way of doin this?
If my comments have helped please hit Yes.
> All, good morning. i have a issue, i need to populate cell E4 with a value
> CX/025966 when cell F4 has a text Bond Street.
> Is there a simple way of doin this?
=IF(F4="Bond Street","CX/02...PCCharge Pro 5.7.0/ RMS 2.0 Compatibility
I am planning an upgrade from RMS 1.2 to ver 2.0. Will PCCharge Pro 5.7.0
Rel B work with RMS 2.0 or do I need to purchase a newer version of PCCharge
as well? Our RMS VAR says to check with PCCharge (VeriFone)... VeriFone says
that MS RMS tests their software with PCCharge (and others) and has a list of
...Can't Assign Value to this Object
I think I've seen this problem before but I can't remember the reason or
solution. I have a form (in add mode) whose record source is a single
table. For most fields on the form, the user will input data, but for a
couple of fields I am trying to populate them with the values of global
variables. I've got the global variables working (I can assign one to an
unbound text box on the form), but when I try to assign the variable value
to a bound text box, I get an error message that "Run-time error 2448: You
can't assign a value to this object". Here is ...Lookup a value in a table and display text if a value exists
I have a customer database form named frmMain with a field called txtAgency.
I also have a table that has a column of agency codes that are in the
Outlook Global directory. The table is called tbl_Global and consist of about
If the user inputs an agency that is within this table on the frmMain, I
want the phone number field (txtPhone) on the database form to automatically
display "See Outlook". If the agency is not within this list, I want the end
user to be able input a value on the form.
What is the best way to go about this?
Use DLookup() to get t...OWA #2
Is there a way to check external POP3-accounts with OWA (Exch 2003)?
Jocab <email@example.com> wrote in
> Is there a way to check external POP3-accounts with OWA (Exch 2003)?
Not that I am aware of.
FAQ located at http://www.swinc.com/resource/exchange.htm
Newsgroup archives at http://groups.google.com
...Need a lookup formula that matches 2 values and returns the 3rd va
I neeed to merge 16000 rows of data with some duplicate vales. Poor record
keeping lead to two lists and each was updated independantly if at all. Some
orders show up one list and not the other so I can't just sort or do a dup
search. I'm trying to recreate this data and track the status of all orders
for the past 12 months. When orders were shipped out in parts the same order
number was used and this has been a nightmare trying to sort the duplicates
and match the dates.
I need a formula for F that returns the current status based on the order
number and date. I tried a...Summing visible column values but not hidden column values
I need to write a SUM function that will add up the numbers in several
columns of data (for example, A4:S4), but I only want it to add those columns
that are visible, not those that are hidden. Is there any way to have Excel
add only the numbers in the visible columns, not in any hidden columns?
have you hiddent he columns manually?. If yes you'll need VBA
"BW" <BW@discussions.microsoft.com> schrieb im Newsbeitrag
> I need to write a SUM function that ...HELP! Chart Zero Values
I'm new to this forum...I hope someone can help. I have just become
trainee Office Trainer, and a delegate has asked me a question that
can't immediately help her with. She has a job interview thi
afternoon and has been given some Excel tasks to do.
She has been asked to create a scatter chart using 2 columns of data i
the spreadsheet. How do you get the chart to not display the data i
either the x or y axis data is null?
I know you can get the chart to not display the values if both x and
are zero, but what if just one of the axis is zero?
If anyone can help me with this ...