Update a text box on a user form based on changes in another control
On my user form, I have a combo box which is linked to a named ranged. In
this range is a list of possible fare types....for now lets just call them A
to B, B to C, etc etc.
When I select one of these fares in the combo box, I want to tab to another
text box, and have the relevant fare cost appear in that box so the user can
be certain of the cost involved.
The corresponding fares are in the next column on the sheet beside the named
range, but at present, when I tab to the text box I get either no result or
an error message.
I have been trying to use WorksheetFunctionVlookup....etc but obv...copying text from an excel "box" that seems to be formatted
Operating System: Mac OS X 10.4 (Tiger)
<i>want to copy text from an excel document and paste it into a word document. when i click on the excel text, a box pops up around multiple paragraphs, and i am only allowed to copy the entire box of text. how to i unformat or gain access to the lines of text, so i can copy just SOME of it? (so when i paste, it's just lines of text and not a box...)</i> <br><br>thank you!!
The "box" that pops up is most likely the Formula Bar's edit field which is
displaying the content of the sel...Percent
How is the formula for percent change between two numbers constructed and
"Old Red One" <email@example.com> wrote in message
> How is the formula for percent change between two numbers constructed and
This will calculate the percentage increase from 30 to 45 (50% increase):
=(45-30)/30 = 50%
This will calculate the percentage decrease from 45 to 30 (33.3% decrease):
=(30-45)/45 = -33.3%
...CSV format ?
I have an sql script that writes my database table data out to a fil
and i've given the file a name with the (.xls) suffix also, the data i
delimited with a comma.
After running the script, i end up with a file in my directory and th
file has the Excel ICON, but when i select on the ICON, Excel does no
recognize that it's comma delimited of course and still requires that
import the data using the import utility.
I am quessing/assuming that there must be a setting or feature by now
that i can set that will tell Excel to assume that the data is in
comma delimited format and ...can cells apply conditional formatting using the internal clock?
I am using excell to keep track of my production schedule
and I wanted to know if there was a way to tie the cells
in a worksheet to the internal date and time in the
computer,so that the cells will update automatically.
Example: Row A10 would be my production start date, Row
A1 would be my projected finish date, I would like the
cells in between to go from green to red as I near the
finish date without manually inputting the date in each
cell. Can you help me? Thyanks
Set the normal format as desired (I selected a Pattern of Green).
Select A1:A10, then select Format | Conditional Fo...Possible to change the default cell format?
Hello - I am constantly changing the format of my cells (when they are
the number format) to include the comma separator and to use zero
Is there a way to change the settings so that by default the values
will not have decimal places (and by default they will have the comma
Thanks for any suggestions!
(FYI, I considered creating a simple macro to do this, but I believe
that it would limit me from being able to use the UNDO command as
often as I would like).
To address the "default" number format, you would have to use a template as your
default workbook...How do I copy a print format from sheet to sheet in excel ?
I would like to copy a printing format to other sheets in a workbook
including print areas and print titles. Is this possible does anyone know?
Unless I'm missing something, most everything you're asking *is* done
automatically since your print specs are for the workbook, not sheet-by-sheet.
Headers/Footers, Rows to repeat@top, margins, etc. apply to all sheets, and
Print Areas need only be set if you want to print a portion of what would
normally be output. You might want to consider Named Ranges if you haven't
already done so.
I have a small biz 2003 server environment.
I have users who can access the server re: network shares ...but can not
access outbound HTTP traffic.
1. Email traffic seems to be flowing both ways.
2. Work stations seem to take a long time to start-up - especially taking a
long time to "prepare network connections"
3. Hit or miss some work station and sever can access Http, while other can
4. Might be some conflicts w/ DHCP
Looks like a DNS issue to me. One of the first things a domain-joined
client tries to do is contact a domain controller...Aggregate data types mismatch
Using reporting services 2008.
Getting a really weird error when calculating a variance between a budget
and actual amount in the report. Both the underlying fields are of data type
'money', but when performing the calc in the report writer, i am getting the
following error: [rsAggregateOfMixedDataTypes] The Value expression for the
textrun 'Variance_MTD_ActualvsBudget1.Paragraphs.TextRuns' uses an
aggregate function on data of varying data types. Aggregate functions other
than First, Last, Previous, Count, and CountDistinct can only aggregate data
of a si...(OL2003) Importprf works for some users, but not others
I am using a prf file that I created using the Custom Installation Wizard. I
tested it on my user account and a few others and it worked fine. I tried
using the same prf file to set up some other users and it just brings up the
Outlook Setup Wizard. I tried it again on the users that it worked on
previously and it still works on them. Could someone tell me where I need to
look to find out why it works for some, but not others?
(Is this the right place to post this or is there a better place?)
I am still having this issue. I thought it may help if I gave a more
detailed explain...Personal Folders Format
I've got a .PST file that's currently listed as "Personal Folders File
- Is there any benefit to creating a new .PST file using the Outlook 2003
- What are the differences between the two formats?
"Steve" <firstname.lastname@example.org> wrote in message
> I've got a .PST file that's currently listed as "Personal Folders File
> (97-...Please help user accounts cannot log in
Hi all, well I caught a virus. I had essentials but some how it is unable to
delete the virus and the real time protection has been disabled. Upon working
with support we manage to find the problem in windows32 folder. It is a fake
security virus. Unfortunately i was unable to delete the applications. I some
how did something because now i cannot log in at all. Windows start up and
gets to the user account section. When i click on any account it starts and
then immediately logs out. This is even in safe mode under admin. I was able
to at least get into windows and now i cannot. A...format numbers
I use Office 2002 with Windows 2000 and I would like to use the format
(500.00) when it is negative instead of the minus sign when writing numbers
I do not have that option in the format cell, how come?
My friend is using the same Office 2002 with Windows 2000 and she does have
the brakets in her format.
We both have the same Service Pack for Office and Windows.
she can simply enter the same format as custom format. she probably has
different regional settings
> I use Office ...Formatting a number to look like a Percent without a percent sign
We often want a column of decimals to have a percent sign only on the first
number in the column, so:
need to be formatted to look like
where all the decimals align vertically. I can't figure out how to do this
without multiplying the second and third cells by 100, which is a bad
Any ideas? Thanks.
format custom 0.0
"David Iacoponi" wrote:
> We often want a column of decimals to have a percent sign only on the first
> number in the column, so:
> need to be formatted to look like
&g...HTML account server type API?
Is there an API available for scripting/coding HTML account
integration into Oulook similar to Hotmail? I have a web
based mail Perl program (Gossamer Mail) that I would like
to be able to integrate with Outlook but I'm not coming up
with any info on an API. I've tried searching the news
groups, Google and MS but I don't know exactly what I
should be searching for.
Any info to point me in the right direction is greatly
outlook (and OE) use webdav to access the mail server - if your program uses
webdav, you can access it using the HTTP ...Line Chart
I thought this would be easy, but I am really stumped!
I need to show the percentage in addition to the value in the data labels
for a line chart.
Series 1 5 6
Series 2 15 4
I would like the January data label for Series 1 to show 5 (25%)
I would like the January data label for Series 2 to show 15 (75%)
I would like the February data label for Series 1 to show 6 (60%)
I would like the February data label for Series 2 to show 4 (40%)
TIA FOR ANY HELP!
You need to construct your lab...Unable to launch Outlook from only 1 user in Windows XP
I am unable to start Outlook (and Outlook Express) from
only one of the users I have set up in XP (get an error
message about not having permisson rights to acces the
Outlook.pst file). Outlook works fine for the other
three users. I've tried the Inbox Repair Tool
(scanpst.exe) and it does not find any problems with the
pst file (but it does give an access rights warning that
it couldn't repair the fiel if it did find something
worng with it). The tool does not find any problems or
any rights issues if run under any of the other users.
Any ideas on how to fix this?
...Conditional Formating Based on Date #2
I need some help on conditional formating. What I want to do is change the
color of a cell based on the date, i.e. if the date in the cell is today or
greater I want the cell color to change to red, if the date is 3 days before
the date in the cell I want it to change color to yellow.
condition 1 formula is
cond 2 etc
"Roy" <Roy@discussions.microsoft.com> wrote in message
> I need some help on conditional formating. What I wa...formatting the TOC
I have a heading which is spread into almost two lines. But when i generate
the TOC, it displays the heading in a single line.
Please suggest me a solution.
Thanking in anticipation.
Are you saying that you want your TOC to use the same font as size as your
>I have a heading which is spread into almost two lines. But when i generate
>the TOC, it displays the heading in a single line.
>Please suggest me a solution.
>Thanking in anticipation.
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/...Custom Number format #2
What custom number format to use so that
1.5 will display as 1.5
1 will display as 1 not 1.0 or 1.
Any help will be highly appreciated
In article <uri1#$nAEHA.2036@TK2MSFTNGP12.phx.gbl>,
"JON JON" <conrado_capistranoREMOVE@msn.com> wrote:
> Hello, NG
> What custom number format to use so that
> 1.5 will display as 1.5
> 1 will display as 1 not 1.0 or 1.
> Any help will be highly appreciated
Based on your examp...Moving user account between domains
I am planning on moving a user account from a child domain to a parent
domain. I need to ensure that the user's Exchange mailbox is migrated as
well. I have ADMT 3.0, but I would appreciate feedback on whether this is the
best method to use. I am looking to keep downtime to a minimum. Any advice
would be appreciated. Thanks.
The ADMT will NOT move the mailbox. You will need to use ADUC or Exchange
System Manager to do that. ADMT should move the Exchange specific
attributes of the user account, though.
- MostlyExchange Blog: http://mostlyexchange.blogspot.com
- E...How to delete the word I typed on the excel page?
How to delete the word I typed on the excel page?
On Mon, 10 May 2010 16:53:01 -0700, Loan Duong <Loan
>How to delete the word I typed on the excel page?
Uh, select it with the cursor, then hit <delete> ?
Or, use the backspace key.
"Ron Rosenfeld" <email@example.com> wrote in message
> On Mon, 10 May 2010 16:53:01 -0700, Loan Duong <Loan
> Duong@di...Excel date formatting
Operating System: Mac OS X 10.5 (Leopard)
I have formatted the cells to yield a date in the form 14-Mar. If I input 3/4 or 3-4 the cell yields 4-Mar. It will not allow me to enter the data in the same format I want it the data output. If I enter 30/11 I expect to get 30-Nov, but I do not. It seems logical to me that I should be able to input the date in the same format as I want it output. Can this be done?
It's a matter of your System Preferences settings - Excel takes its cue from
that. Change your International preference for Formats & Excel wi...sort/format this spreadsheet
hi, following the failure of my last post....hoping somebody here can
help me with this.
i have a spreadsheet that looks something like this (except with about
10 000 rows)
DOT1 AGENT1 NAME1A
DOT1 AGENT1 NAME1B
DOT1 AGENT1 NAME1C
DOT1 AGENT1 NAME1D
CLPM AGENT2 NAME2A
CLPM AGENT2 NAME2B
U788 AGENT3 NAME3A ...cannot type in greek in publisher 2007 #2
it enters text only in english the settings of the greek language are ok