search a text cell CONTAINING matching text in a dynamic range (not exact match)
I use the following, currently, to mark a row for exclusion
I'm looking for a way to use an exclusion keyword list on a separate
sheet in a dynamic range
so users may add to or delete exclusion keywords
rather than have the 'hardcoded' exclusion keywords in the formula
And I'm ho...What is controltip text? Looking for a field to store some text
I need a field in the properties to store a descriptive name of a textbox's
If a required field, which has "R" in the Tag field in the properties, has
not been entered a message box appears:
MsgBox "Please enter a value for " & ctl.Name
Where ctl.Name is the name of the text box. l need to be able to say, for
example, "Department Number" instead of "txtDeptno". I could put
"Department Number" after the "R" in the tag and parse up tag but is there
another field? How about ControlTip Text or Validation Text?...Horizontal Scrolling
Whilst I was using Excel the other day, the Scrolling facility of my Wheel Mouse changed to Horizontal, and I was unable to scroll up or down, unless i moved the cursor over the scroll bar at the side of the page.
In addition, poreesing the wheel button, which normally brings up the pan facility, only allowed panning left to right.
Can anyone tell me how this is turned on/off?
Kev - were you able to get an answer to this. I am having the same problem
> Whilst I was using Excel the other day, the Scrolling facility of my Wheel Mouse changed to Horizonta...default font when converting handwriting to text
I'm using OneNote 2007. I set my default font for the page. When I convert
handwriting to text it doesn't use my default font. Is it possible to set the
font for text when converting from handwriting?
I sent a newsletter in Office 2003 Publisher, but who receives it can´t copy
and paste the text into word, is there a way?
No, there is no way unless the person you are sending the *.PUB file has the
> No, there is no way unless the person you are sending the *.PUB file has the
> same version.
...Importing text file
I'm attempting import a text file into excel. In the first
Step of the Text Import Wizard, I need to define the File
Origin as "Nafitha" (Arabic Font), but the only options
available are MS-DOS, Windows and Macintosh. Without this,
i can only read numbers but not the arabic text. Where can
i get/download/install that from ?? (i'm using Office 2000)
...How to keep the original format of copied text
When I copy text in MS Word 2003 it arrives at the new location with an extra
(empty) line at the end. When I try to delete this line it causes the just
moved text to revert to the defalult text of the current document.
FOR EXAMPLE: I copy a paragraph that is Arial 10pt into a document that is
Arial 12pt. The copy brings an extra line at the end. When I try to delete
that extra line it causes the just pasted text to change to Arial
12pt......my problem is that I want to keep the original format.
when you paste text in a word document from a different file, at the bottom
of th...Using text as argument
I have the following problem.
I have the following list in cell range A1 to A3
( Note :- The text strings may differ from the above. It is no
possible to include any Hyphen, colan, Semicolan & Underscore etc. I
is also not possible to give numbers. )
Now I want a formula in Range B1 to B3 which gives threee differen
values or performs three different calculations based on the value i
cell A1 to A3.
ie - If cell A1 equals Milling then value in B1 is 1 ( or a formula)
If cell A1 equals Drilling then value in B1 is 2 (or a formula) & I
cell ...Adding Superscript Text to a Distribution List Name
We have a user who would like to add superscript text to a distribution
list name. He is currently calling it (BC)2, but he would like the 2
to be superscript and would like to get rid of the parenthesis. I
didn't think this was possible since you really can't put html in the
title, but he swears he has seen this before. Anyone have any ideas?
It's not possible.=20
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
and Microsoft Outlook Programming - Jumpstart for=20
Administrators, ...How to change button text color in a CToolBarCtrl
I have a CToolBarCtrl that contains text only buttons. I want to know
how to change the text color of these buttons? Or even further, to use
the theme color for menu items.
Did you try NM_CUSTOMDRAW as mentioned earlier? That should do it. Its
not straight forward but it will work.
Thank you very much. I think that is what I need.
Ajay Kalra wrote:
> Did you try NM_CUSTOMDRAW as mentioned earlier? That should do it. Its
> not straight forward but it will work.
> Ajay Kalra
> aja...Adding Text To Text
I have a long list of projects names and I need to add the same tex
addition to the lot. Currently the project names are simply displaye
I need to change each entry to:
Can anyone suggest a means of doing this which doesn't involve goin
through each and typing the  and.xls?
SamuelT's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2750
View this thread: http://www.excelforum.com/showthread.php?threadid=48481
If yo...Calendar Invites Arrive as Plain Text
Exchange Server 2003 SP1 Clustered Active/Passive
Windows Server 2003 SP1 Clustered Avtive/Passive
Exchange Server 2003 SP1 Non-clustered/Standard
Windows Server 2003 SP1 Non-Clustered/Standard
Exchange 5.5 SP 4 Clustered Active/Passive
Windows NT 4.0 SP6a Clustered Active/Passive
Exchange 5.5 SP 4 Non-Clustered/Standard
Windows NT 4.0 SP6a Non-Clustered/Standard
We have identified that any calendar invite request, when sent outside of
the Exchange Server Environment arrives at it's destination as plain text
instead of the standard invite format in Outlook. ...How do I group text to graphic?
In my document I'm trying to embed a graphic into the text. How do I do this
to where when I delete text before the graphic it moves with text instead of
me having to redo embedding?
BeanieBrain <BeanieBrain@discussions.microsoft.com> was very recently
heard to utter:
> In my document I'm trying to embed a graphic into the text. How do I
> do this to where when I delete text before the graphic it moves with
> text instead of me having to redo embedding?
Which version of Publisher are you using?
Ed Bennett - MVP Microsoft Publisher
i'm using both 2000 and...how to mirror text from one text box to another
im trying to mirror one text box to another text box but flipped the other
way so they are not facing the same way horozontally (hopefully that makes
Microsoft MVP - Publisher
How to ask a question
"Amber Van Berkel" <Amber Van Berkel@discussions.microsoft.com> wrote in
> im trying to mirror one text box to another text box but flipped the other
> way so they are not facing the same way horozontally (hopefully that makes
...Converting Text Date to Date/Value
Im having trouble converting a Text date to a DateValue, I have tried Text
to Columns and also the =Datevalue(A1) formula with no avail.
My date is written in a cell as e.g Wednesday 14th October 2009
Obviously as its in this format i cannot perform date calculations on it. Is
there a way i can convert this? I have a whole long column worth which
needs doing so typing over every one is not really an option!
Am Wed, 14 Oct 2009 22:40:10 +0100 schrieb Alex Barrow:
> My date is written in a cell as e.g Wednesday 14th October 2009
> Obviously as...Combine text from a field in multiple records
I have a database that tracks projects. Included in the tracking is a list of
the product(s) effected by the project. In a summary of a project I would
like to include the products effected as a single continuous text string
rather than a list column.
Project: 123 (project control number)
Date: 1/16/08 (start date)
Description: Change Color (Desc)
Products Effected: ABC, MNO, RST, XYZ (from a second table that relates back
to the first by the project control number field)
>I have a database that tracks projects. Included in the tracking is a list of
>the produ...Text Cut-off
The text of my document is getting cut-off, especially the letters g and p.
I am using CG Times, font size 12 with a row height of 14.5 in Excel on MS
Any tips on how to get it to stop??
Click on the row, the double click on the bottom edge of the row nuber (=
the left hand side)
This will ensure that the screen row is adjusted to fit the characters.
Of course, now I ask is this on screen or on printout ?
If it is on the printer - suspect that the priver driver may need to be =
On Fri, 01 Sep 2006 16:25:02 +0100, kath0178 =
<kath0178@disc...Text to Columns?
In my spreadsheet, from cells F1 to CA1, I have a list of
titles. At the beginning of each of these titles is the
words Out of Stock/. I would like to know if there is an
easier way to get rid of these words other than text to
columns. Right now, I insert a column next to one with
text and use Text to Columns and choose "/" as my
separator, and then I have to go back and delete all of
the unwanted cells. I didn't mind doing this once, but
now that I have to do it weekly, I need to find a faster
This is what it looks like now.
F1 ...cannot Paste text to a text box
It seems that the standard Paste function doesn't work under any
circumstances when trying to copy to a text box in a chart... Has anybody
noticed this? Is there a fix? XL2002/Win2K.
have you tried using the keyboard shortcut "ctrl + v
MajorGeneralDes's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=370
View this thread: http://www.excelforum.com/showthread.php?threadid=31514
These are fighting words, General! :-)
Of course; have you?
z.entrop...TEXT = text
I have some data in an Excel table which uses case sensitive codes. Does
anyone know of a way to perform case sensitive VLookups.
A1 contains "TEXT", A2 contains "One".
B1 contains "text", B2 contains "Two"
If I enter "text" in cell A4 and the following VLookup in B4:
I get the answer "One", but I would like to see "Two".
I have found a work around by converting a number of characters to their
ASCII codes, but this is very messy.
I know that the FIND function is case sensitive whe...macros for text
I have a spread sheet that contains six diferent peoples names in a schedule
format throughout the workbook I would like to change each name to a
different text color with out having to change each one. I would like a macro
that would change the text of each name I select aand chage it in the entire
wookbook. so if I have the name steve inthe schedule 70 times it will go
through the spreadsheet and change every steve to a red text. (hope this
Have you considered using conditional formatting? You could set this up for
one cell, and then copy the con...Merging text files with excel
How can I merge several text files with the same format into one Excel sheet
in one go ?
I am importing them singly but it would be much better to merge them
together before opening.
Many thanks for any help !
Maybe you can use some old DOS commands.
Shell to a command prompt and issue an old DOS command to concatenate the Text
Windows start button|Run
(or flying windows r as a shortcut!)
Go to that folder:
(to change to that drive)
to change to that folder
copy *.txt All.Files
Ren All.Files All....Mouse Scroll Wheel in Memo Fields
How can I get my mouse wheel to scroll down a Memo Field control?
(it works fine on combo boxes)
...Having a row adjust in height to accommodate text entry
In a form that I'm developing I have 4 columns and 5 rows. I would like for
the row height of all rows to automatically adjust to accommodate the text
entry in any given colum/cell. Is there an easy way to accomplish this? Will
it make a difference whether the worksheet is protected or not?
On Thu, 7 Jan 2010 10:50:06 -0800, John wrote:
> In a form that I'm developing I have 4 columns and 5 rows. I would like for
> the row height of all rows to automatically adjust to accommodate the text
> entry in any given colum/cell. Is there an easy way to ...How Do I create an overline for text
How do I create a line on top of the text
Click the topline button
For a more convenient technique on an on-going basis:
Customize your toolbar and drag the topline button from the Drawing menu to
Does that help?
"Etienne Erasmus" wrote:
> How do I create a line on top of the text
Actually, when customizing the a toolbar, the topline button is in the Format
category of the Commands tab.
"Ron Coderre" wrote:
> Try this: