Active X text box control
I want to put a text box in a cell. I have followed all the instructions I
can find and it still isn't working. I try to type in the box and then go to
another cell and the text shows up in the cell behind the text box. What am
I doing wrong?
The Active X textbox control comes from the control toolbox. To adjust it's
settings you need to put the sheet into Design mode by clicking the first
button on that toolbar (looks like a triangle, pencil and ruler). Right click
the text box and select Properties. Add a cell address to the Linked Cell and
then Exit Desing mode. T...Averaging a column that contains text
On my worksheet I have a column of12 cells that I need to average.
Unfortunately cell B6 contains text (see below). As shown the dreaded #DIV/0!
displays in cell B13 until any rates are inputted into the column. After
inputting the first rate the formula works great. I’m using the formula;
=AVERAGE(B1:B12). Is there another formula I could use that will not display
the #DIV/0! in cell B13 ? I’m using Excel 2007.
...How to get the text from another window?
For example, In MSDN help program, there are many items in the left list box
when you type whatever key word. Can I get these itmes' text in anohter
program? I did a test, put a CListBox in a dialog and then , in another
program, get the handle of this list box and use list.Attach(handle) , then
you can get all text by the list. But in msdn help program, it is not a
CListBox, how to do that? Is possible?
What exactly do you mean by the MSDN list box? Are you talking about
the part of the Index where the topics are listed?
alec <@> synetech &l...How do I count the amount of text in a column and then add them
For example I would like to count the number of Mondays inserted into a
column and then sub total.
Peter Curtis wrote:
> For example I would like to count the number of Mondays inserted into a
> column and then sub total.
...text wrap problem
I'm importing address info into Excel from our in-house database. Th
addresses comes as a block with line breaks which show up as a squar
in Excel (when text wrap is off). I need to change these marks int
commas. Is there any way to do this automatically?
I dont have VBA knowledge but suspect this is where the answer lies.
Apologies if this is an innane question to some but Im stumped.
Message posted from http://www.ExcelForum.com
From a previous post:
Chip Pearson has a very nice addin that can help identify those funny
http://www.cpearson.c...Add Text To Multiple cells
I am working on this project & I cant figure out how to add a letter in front
of each number in a cell without clicking in to each individual cell and
typing it in. (very time consuming and tedious) The problem is - it's not all
the cells but a majority, all of the numbers are in the same column. To
explain, these are documents in storage. Each item is assigned a number (not
in any particular numerical order but they have to stay in the order they are.
The last three numbers need the X in front of them.
Any ideas? Thanks so much...sum text box porblem
I have a text box for sum a group of text box in sub form. When I run the
form, it works. But when I run the form using another form” run the form from
other form by using a button” the sum text box does not work. Can any body
tell me what is wrong?
your help is highly appreciated.
Can you post the formula you are using as the control source as it may refer
to the main form - and of course - if open the subform on it's own the
reference will not point to anywhere.
Post the formula and someone will no doubt be able to help
"ghost&quo...Problem copying from one text box to another.
I am trying to copy the contents of a text box in one spreadsheet and
paste it in a text box in another spreadsheet. But when I do this in
the normal manner (Ie selecting the old text and clicking the paste
button to replace it), the old text is still visible under the new
text, sort of like a double exposure on a photograph. Any idea why this
should be or what I can do about it?
...Excel "Text to column"
I need to export data from a database I am working with, to an exce
file, to make it easier for me to edit certain changes.
For one part of this, all of the data appears in one cell (seperated b
I use the "text to columns" function, to change the data into multipl
columns to make it much easier to read, work with, and edit.
My problem, is changing it back to the one cell, so that I may the
import it back to my database.
Part of my excel sheet looks like this after the text to column:
where the large blank space is two empty cells. I know the correct ...Attachments are being added to plain text messages
Last month there was an exchange of postings about a change in the behavior
of Outlook for messages in "plain text" format. For a period of several days
(in my case, from December 15 to December 19), every message received by
Outlook in "plain text" format had an attachment added to it. The attachment
is a .TXT file. The name of the file is the same as the subject line of the
message. The text of the .TXT file is the same as the text of the message.
Although this odd behavior stopped on December 19, it's Baaaaack. Beginning
yesterday (2005/01/09), all plain text ...Receiving in Plain Text
I have tried to change to receive my e-mail in HTML
format and the box to check is grayed out so I cannot
choose it. Is there a way to change this. I have
Are you using Word as the editor? What happens if you turn off Word?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, Mike Shrout asked:
| I have tried to change to receive my e-mail in...Truncated text when copying text from one excel doc to another
launch two excel documents
Enter a long text string into any cell >500 characters
Copy the cell and paste it to any cell in the other document
Result: the pasted text is truncated losing the end of the original text
How can I fix this?
Should'nt happen as you described - except there is a problem with
cell formatted as TEXT and a cell data length 512 to 1024 characters
(the cell is displayed as ##### symbols)
From a worksheet, if you Move & create-a-copy a worksheet there is
limit on the contents of a cell size, but Excel will tell you of thi
at the time of the copy....Can't Access E-mail Addresses in Text of messages
I can't access E-mail addresses in message text such as
Subject: Payment for ebay auction
Amount: $9.03 USD
Shipping & Handling: $2.00 USD
I need to access the e-mail address
firstname.lastname@example.org from the message itself.
Does anyone know if and how this can be done?
Is the message sent as plain text? If so, you can't click on it.
Note - if you've posted a valid address here, that poor person is going to
get flooded with spam and SWEN viruses. Never ever post valid email
addresses in usenet posts (and a...format a formula to general (not text)
I am importing a text (.csv) file into excel and formatting it via a Macro.
in one column I have to insert a formula but when I do so, the formula is
showing, i.e. "=TRIM(Z4)". I have tried to format to "general" but it
doesn't work unless I click inside the cell and press enter. How do I apply
the "General" formatting without have to manually click inside the cell? I
want to do it in my macro.
Here is my code:
ActiveCell.Formula = "=TRIM(Z4)"
Selection.NumberFormat = "General"
Tempe, A...Shared calendar does not show text in appointments
I've had a request for help because a user on our network, who has access
permission to her bosses calendar, has a problem. When the PA sets new
appointments she can see botht he new item and all the other appointments,
whether she set them up or her boss did.
However, when the Boss looks in the calender for herself, the ones set up by
the PA show as blank spaces, but the subject line does not show the text.
The PA knows how wto do this and IS using the subject line properly to
detail what the appointment is for.
Honestly, I'm baffled - I've never heard of this before. Any ideas ...how to activate text to speech
how to activate the text to speech bar ????????
frsm's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=31231
View this thread: http://www.excelforum.com/showthread.php?threadid=519641
View > Toolbars and check text to speach
This requires a recent version of Excel
> dear friends
> how to activate the text to speech bar ????????
> ---------------------------...Difference between Text Area and Text?
Can anyone tell me the answer to this question?
A textarea accepts multi-line text values. A text accept single-line text
Jeffry van de Vuurst
"Saira" <Saira@BayonetVentures.com> wrote in message
> Can anyone tell me the answer to this question?
i assume when we make attribute for text area we use (ntext) . The
max length is 5000.
Jeffry, thanks, but am i being a bit dense.
Is the difference something to do with lin...Clicking on text box that not revisable
Hi. I have a text box on a form that is not editable by the user. It
displays an automated number from the associated table. It's shaded so the
user gets the hint that it's not enterable or editable. However, it is
enterable if you click on it. It also becomes unshaded when you click on it.
You still can't revise the number but I'd like it to not be enterable at
all. Any suggestions?
Set its Enabled property to No.
"Sue" <Sue@discussions.microsoft.com> wrote in message
news:18EBC3C9-6F3A-4F7F-AC1F-80DA5593...how do I concatenate text that has a quotation mark
how do I concatenate text that has a quotation mark in it like th
following html: <img width="76" height="25" src="blah"
sparkroms's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2503
View this thread: http://www.excelforum.com/showthread.php?threadid=38564
Replace the quotation mark with its ASCII character equivalent: 34.
I put 76 in A1, 25 in B1 and blah in C1.
Then I used this formula:
="<img width="""&A1&&...Summing an array based on text condition
I have the following columns I would like to create an automatic formula to
The formula should detect a person's initials (e.g. AL or AS in this
example) and only sum if they are either wholly or partly involved with the
sales. Where they are jointly allocated (e.g. AL/AS) only half of the sales
revenue should be added.
So the correct formulas would return:
I was trying to use the sumproduct function with an embedded Left() and
Right() functions. However the left/right functions do...How can I get text to equal a numerical value in Excel?
I am developing a scheduling program for my workplace. The program will
automatically calculate total time scheduled based on times entered (i.e.,
8:00AM start time in one cell, 5:00PM end time in the next cell calculates to
9 hours in a third cell). However, we need to indicate days off, vacations
and leaves of absences. When we enter text into the first cell, it obviously
destroys the calculation in the third cell. I need to be able to have Excel
assign a value of "0" for any cell that has text. Thanks, Mike
I fixed similar problems in my files by using the if &am...Text Box
I have a report that pulls from a cross tab that comes from a make table
querey. In the report I need the ability to have a text box where the agent
can enter certain data when promoted. For example =[Enter End Date] or
=[Enter Reporter Name] However, when I enter this into a text box I am
recieving a error that states that it is not reconginzed as a valid field
name or expression. How do I get around this?
Omit the = sign at the start of your expression.
"awalker" <email@example.com> wrote in message
news:3D99E055-67DC-42FE-B88D-35...Publisher crashes when I touch the last text block
I use multiple pages for my websites, continuing the text
from page to page. For some reason, the very last page
is extremely sensitive, so that if I put a cursor on that
text block, the program crashes.
What to do?
What version of Windows and Publisher are you using?
Update your video drivers from the website of your video card manufacturer
and that will fix your issue.
...text to columns #3
I have an invoice that I cut and paste whole network application screen
onto to fill out the invoice. It works really well using the text t
columns feature (delimited, spaces). However, when I close the exce
session, it no longer will be delimited. How do I fix this?
Message posted from http://www.ExcelForum.com
If you want to save the de-limiting, SAVE the workbook
If you don't, don't.
"Vato Loco >" <<Vato.Loco.firstname.lastname@example.org> wrote in message
news:Vato.Loco.19fyvo@excelforum-no...Can excel display text in CHART's data table?
All my text are displayed as "0".......just want to keep some comments nicely
in there.Not sure whether excel can do this. Or anybody knows other better
something like this:
para1 1.2 1.3 1.4
para2 1 7 100
comments bad good excellent
The chart data table is very limited in terms of formatting.
You would be better using cells to display the information you want. And
position the chart above them
Andy Pope, Microsoft MVP - Excel