Conditional formatting in text boxes
I have textboxes on a userform.
The text boxes read (and write) to cells A1:A60
Adjacent to these cells I have a comments column which is filled in for
Depending on whether the adjacent cell in column B has an entry, is there a
way to make the textboxes change their font attributes? For example, become
BOLD when there is a comment.
Can anyone help?
You should have posted your code..Within your loop add a line something like
Dim intCount as Integer
For intCount = 1 To 60
Me.Controls("Textbox" & intCount).Font.Bold = _
No...A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no
Does anybody know how to turn the "A program is trying to
automatically send e-mail on your behalf." prompte off?
It pops when one of my MS Access apps is emailing one of it's reports
It happens on the Citrix server that one of my MS Apps is running on,
but it does not happen when the app is running on my own PC.
Consequently I'm hoping for some user-configurable setting that
How do I set the default format for comments?
See this page for all info about comments
Regards Ron de Bruin
"TonyL" <TonyL@discussions.microsoft.com> wrote in message news:C2F9F095-CF0F-4A03-83CE-B01F934E4826@microsoft.com...
> How do I set the default format for comments?
Thanks Ron that was easy!!!
"Ron de Bruin" wrote:
> See this page for all info about comments
&...Format Cells #9
Is there any way to prevent text from extending into
adjacent blank cells? (as the default setting)
use 'Format - Cells - alignment' and check 'word wrap'
"KPK" <firstname.lastname@example.org> schrieb im Newsbeitrag
> Is there any way to prevent text from extending into
> adjacent blank cells? (as the default setting)
We actually do not want the text to wrap, we just want it
>use ...Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to
send a report to Microsoft. Also my account list shows most accounts with a
status of 'Update In Progress'
I've done a complete reinstall after removing it and power cycling my
machine. I thought it may have been something with removing 2004 and
installing 2006, but got same problem
Has anyone else been having this problem? I really just want to go back to
What's the error message?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq f...Automatic CC
Is there any way to create a template where a contact is
automatically CC in the email. So I dont forget to cc them
every time I send an email.
...Automatic axis format
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
Have a look at Jon's examples of dynamic charts.
> I'm need to make a automatic axis format within excel.
> The number of rows is depending of a imported file.
> No problem to g...Column format to override row fomat in FrX
In FrX the row format overrides the column format for font styles eg. bold
etc. it would be useful if it was possible to have the option for the column
format to override the row fomat
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesss...Mail format problems Exchange 2003
I am running OL2002 on Win XP Pro on both a desktop and laptop in a large
network. The network was recently converted from NT Server to Exchange
Server 2003. At that time, all of my mail began being converted from plain
text to html. This appears to be only on both machines accessing my
account, not on other accounts in the network. If I send a message in plain
text mode, it is received by others
as plain text, but converted to html in my Sent folder. Plain text sent to
me is converted to html upon receipt. Since this happens on both machines,
I think it is something to do with the serve...I open the MDB, the form runs automatically
I have an MDB file with 20 files and 7 forms in it.
When I open it up, the form runs immediately an access goes into some
sort of protected mode. I can't view the tables, queries etc. I can
see the code by pressing Alt F11 but not the data.
I created a blank db and imported the mdb so I could see the tables.
But how do I open the original without it running the code?
When I look at the code. I don't see anything that sets properties or
invokes the code automatically.
There are no macros in this, just the forms and associated code with
...Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself.
2nd day now onecare popped up to tell me the updates turned themselves =
I'm thinking what malware would want to turn the updates off ?
Any idea what's going on here ? Did I AUTOMATICALLY install an update =
caused this ?
<email@example.com> wrote in message
> Automatic updates, automatically disabling itself.
> 2nd day now onecare popped up to tell me the updates turned themselves
Drop OneCare and install Microsoft Sec...Conditional Formatting #43
Looks easy doesn't it? Hah!
Any instructions as to how I can do the following:
Column M cells are already formatted to show the date as (in the cas
of M2 for example) =A2+28 (so, 28 days after the date that is entere
into A2). I want the date that is calculated & shown in M2 to turn re
7 days before that date. If the date in A2 is 01/06/04 then M2 wil
read 29/06/04 but I want it to turn red on 22/06/04 (I use dd/mm/yy a
I'm in Europe) and then I want it to turn bold red two days before th
date - in this example 27/06/04.
I also need a similar effect to make the date generated in co...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...Loss of formatting when saved as .xls file
I have created a document in Excel 2007 with some normal cell formatting,
such as bold text, merge & center, and border lines. When checked for
compatibility no errors or messages appear. When the file is saved as an .xls
file, closed, then opened again all of the formatting is completely gone and
all that is left is text. I had this problem with another file but it was
fixable becuase it did show compatibility issues that could be fixed. Any
help with this problem would be greatly appreciated.
...Having numbers automatically appear bold
Had such great advise last time, thought I'd try again.
I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.
What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.
Thanks again in advance.
Message posted from http://www.ExcelForum.com
select the range you wa...Format date in excel 2000 like '31st January 2005' #3
Trying to set up field in Excel Data Source file so that the current date can
be input in letters typed in this format '31st January 2005'
Is it possible or am I stuck with dd/mmm/yy format?
Why not just format it as you want, but input as standard dd/mm/yyyy. You
can't (easily) get the 1st 2nd etc, but a format of dd mmmm yyyy is quite
"Malcolm Agingwell" <MalcolmAgingwell@discussions.microsoft.com> wrote in
> Trying to set up field in Excel Data Sour...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <firstname.lastname@example.org> wrote in message
> Is it possible to automatically move data entered in columns into rows?
How can I automatically forward messages received from a
specific sender to another's e-mail person?
...CE6: How to Disable SIP popup automatically
I know SIP popup can be disabled by the following registry setting in CE5:
But It doesn't work in CE6.
How to disable SIP auto-Popup in CE6?
The SIP Auto Deploy in CE is due to Windows Controls invoke SHSipPreference
(exported by AYGSHELL.DLL).
So the easiest way is to avoid including AGYSHELL (SYSGEN_AYGSHELL)
But if excluding AYGSHELL is not an option, you may need to modify the
SHSipPreference (PRIVATE\SHELL\SHELLPSL\HAVEAYGSHELL\shellpsl.cpp) to supress
SIP s...Automatically format charts with range of dates
What I am trying to do is I have 4 charts that are linked with data from
another spreadsheet. They are basically week totals for my business and make
a chart compared to say last year.
What I want to do though is have an option on my report that I can enter in
a specific date or a range of dates and have the charts automatically filter
the new data in and change. Instead of having to go into the chart data and
changing what series of data I want to have a chart for I want to be able to
just enter eg. "April 12-April 18" and have the charts bring up that data to
reflect the ...Automatic Database Backup
Is it possible to right code to automatically backup a database? And if so
how, or where, can I get information on this?
There are a few way to do this. I have windows scheuler doing this on all
my databases (at 1 min past midnight each day). Open Scheduled Tasks (it's
in the control panel). It's very simple and not likely to go wrong
> Is it possible to right code to automatically backup a database? And if so
> how, or where, can I get information on this?
So I take it that, there is no way t...excel chart to tiff or eps format
I have created several detailed charts in excel for a paper that I am
sending to a journal. The journal requires that my files have eps or
tiff extensions. How do I convert the excel chart into tiff or eps? I
have tried to 'print' to tiff with microsoft office document image
writer , but the quality of the chart is too low. I also tried to copy
and paste the graph into paint shop pro and to save it as .eps , but
agai the quality is too low. Any other suggestions would be much
In VBA you can use
ActiveChart.Export "C:\test\MyChart.tif"...automatic output from known data
i have 2 spreadsheets of data: 1=english, 2=metric
each spreadsheet has 3 columns, with the first column being an ID #.
on my output spreadsheet i have 4 blanks.
in blank 1 i enter a "1" or "2" for english/metric
in blank 2 i enter the ID #
i want blanks 3 and 4 to automatically be filled with the other tw
numbers from the id#'s row.
1 123.8 9.8
2 122.7 10.3
1 1983 9.8
2 1965 10.3
blank 1 = english <----- manual
blank 2 = 1 <----- manual
blank 3 = 123.8 <---- automatic
blank 4 = 9.8 <---- automati
...Insert date automatically
I have a column with values such as:
And wish to automatically add todays date if the value of the cell is blank
in the mm/dd format. I have used an =If(Column:Column="",TODAY()) in a
column next to it and formatted it in mm/dd to get the desired result. But
how can I take this value (todays date) and insert it back into the original
column automatically and without changing the other valuse?
As always thank you!
Hi, Rick: Here's one way.
Step 1 is to make a backup of your original file so you have a fallback
in case something goes ...