How to concatenate multiple values in text boxI'm trying to code a control source for a text box to concatenate and
handle various possible values. There are three fields I need to
handle:
For example, if the values for the three fields are ...
Person_Relation = "Parent"
Person_Relation_Other = <NULL>
Person_Relation_Type = "Biological"
.... my text box should show:
Parent :Biological;
(The ":" and ";" will be replaced by "(" and ")" but for now it's
easier to use something other than parentheses for testing.)
If instead the values for the three fields are...
custom function to convert numbers stored as textHi everyone,
I know you can convert text to numbers with the whole paste multiply by 1
thing but I was wondering if anyone had seen code (or would know what code to
use) to convert numbers stored as text to numbers using a custom built VBA
function?
Any help greatly appreciated!
Josh
Not sure what you mean, but here is a function that will convert a string
value digit to an integer value.
Function MakeNum(rng As Range)
MakeNum = CInt(rng)
End Function
To use it, assume a string value of "123456" in cell b5:
In an empty cell put formula =MakeNum(b5) >...
How do I set up an automatic delete or move of a row of data?I have a job summary that lists the status of my projects. I want to move
the data and close up the gaps in the spreadsheet as I change the status to
"complete".
You need to provide more information. For example, how do you change the
status to complete and where do you want to move the data to?
Regards
Rowan
"Zo" wrote:
> I have a job summary that lists the status of my projects. I want to move
> the data and close up the gaps in the spreadsheet as I change the status to
> "complete".
I have a list that identifies the "status" of th...
Send email automatically in excel ctu1...@gmail.com Mar 23, 8:23 am show options
Newsgroups: microsoft.public.tw.excel
From: ctu1...@gmail.com - Find messages by this author
Date: 23 Mar 2005 08:23:40 -0800
Local: Wed, Mar 23 2005 8:23 am
Subject: Send email automaticly in excel
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi there,
I add some finance data from http://finance.yahoo.com to a excel file.
The finance data in my excel file will change every minutes.
I am monitoring Nasdaq index. I expect it will go to 1900 soon.
Because of my job, I can not access ...
Hidden tabs on my worksheetI can't figure out how my settings changed or how to change them back. When i
go to Tools: Options: View: Tabs - it is checked. Anyone have any other ideas
on how to get my tabs to show? Have even tried changing the color of them...
Thanks!
hi
have you tried..
on the menu bar>window>unhide
Regards
FSt1
"Courtney" wrote:
> I can't figure out how my settings changed or how to change them back. When i
> go to Tools: Options: View: Tabs - it is checked. Anyone have any other ideas
> on how to get my tabs to show? Have even tried changing ...
Automatic mail checking to ISPHow can i set up Outlook 97 to automaticly dial my ISP to
check for mail on a PC with windows 2000 on??
...
Using =sum to add values of vlookup formula
Is it possible to add the values given by a vlookup formula?
Eg.
I've 2 colums - Month 1 & Month 2
The values for month 1 & Month 2 are taken using a vlookup formula - s
when u try & do an =sum to add month 1 & month 2, it give 0 as there i
no value in either column, just a formul
--
loscherlan
-----------------------------------------------------------------------
loscherland's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=27237
It should give the sum.
Are you sur...
How do I get email to show up automatically on the in-box screen?I want new emails to show up automatically instead of having to hit the
'send/receive' button to see if there is any new mail. Is this possible to
do? I'm using Outlook 2003
Ctrl+Alt+S - is automatically send and receive every xx min enabled?
--
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
mailto:dailytips-subscribe-request@lists.outlooktips.net
EMO - a weekly newsletter about Outlook and Exchange:
mailto:EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH....
fill formulas and values
Not sure how to fill down formulas, with either dragging or CTRL-D,without
taking along formats, colours, borders (especially) etc with them.
A real pain having to re-format a sheet every time I auto-fill...surely
there is an easier way to do this.
Cheers!
M
Have you tried copying and using Edit > Paste Special >
Formulas?
HTH
Jason
Atlanta, GA
>-----Original Message-----
>
>Not sure how to fill down formulas, with either dragging
or CTRL-D,without
>taking along formats, colours, borders (especially) etc
with them.
>A real pain having to re-format a sheet every...
Re: Text and numbersUsing Excel 2003 I want to get the sum of cells containing numbers, but the
these cells also contain some text. I only want the sum of the numbers.
Please help. P
Hi Paul,
=SUM(A1:A20)
or any other range will ignore cells with text values, and ignore empty cells
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"paul" <WEBB234@prodigy.net> wrote in message news:tmd5g.500$zR3.124@newssvr33.news.prodigy.com...
&g...
Looking for Outlook add on programHI all
I recently had a hard drive fail and lost a program but i am sure somebody
will point me in the right direction.
It was an add on for outlook that was as far as I am aware freeware and was
called something like AOPEN
It sat it's self in the options panel of Outlook and allowed you to chose
what files/attachments could or could not be downloaded.
Do any of you have an idea what it was called or as to where i can download
it again ????
Many thx
Steve
This was to open attachments blocked by security? Was it called Attachment
Options maybe? See http://www.slipstick.com/o...
MSN Stock Quote Add-In (msnsq.exe) doesn't installRunning Win2000SP4, & Excel 2002SP2 on a Dell Prec. Workstation. I have
tried installing this add-in from the web and also from a folder, always
with the same result. It appears to be installing until I get a dialogue box
stating "Failed to download settings from the internet." After thias
attempt to install, the add-in shows as available from within Excel but is
non-functional, and has an abreviated tool-bar associated with it.
Help?
Thanks,
Richard
...
Stop Recording ToolBar dissappeared in my Excel WorkSheet?I used Macro function in Excel WorkSheet.But now the Stop Recording/Relative
Reference Button ToolBar for Macro does not appear any more?Can someone help
me restore this option again?
Regards
Select Tools-Customize-Toolbar tab - Click 'Reset' and 'Ok'
"Aamir" wrote:
> I used Macro function in Excel WorkSheet.But now the Stop Recording/Relative
> Reference Button ToolBar for Macro does not appear any more?Can someone help
> me restore this option again?
> Regards
Once you click record macro, click right button on the tool bar, select 'Stop
reco...
How to add "Add existing..." button link in custom entity form?Hi, I created a custom entity called ClassSchedule which has a parental,
1-Many relationship with Contact. Now, when I add new ClassSchedule, in the
form, and click the Contact link, I want to have a button "Add Existing
Contact" instead of just adding new contact in my ClassSchedule. Please
advise on how to go about it.
Thanks!
...
How to add Multiple Online Accounts from same online broker?Hi All:
I have two different accounts, with two different logins, etc., but with the
same broker. When I try to add the 2nd account, for automatic online
synchronization, the broker's name no longer appears in the list of available
online brokers? It's as though Money figures there can only be one account
per broker. How can I add the 2nd account?
Thanks!
Ev,
Which version of Money are you using and what is the brokerage in question?
Try any suggestions you get here on a copy of your Money file.
Something that you might try is to stop using online services for that
partic...
Installation add-in?Hello
A friend of mine programmed a com- or vb6 add-in and saved it as dll-file.
Now I'd like to install it but I don't why. My friend is on holiday and I
can't contact him. I only know that I have to install this dll with the
Windows Explorer using the command "open with", but I don't know the file to
be chosen.
It would be very kind if anybody could help me 'cause I need this add-in.
Tom
...
Showing argument descriptions as an XLL worksheet function is typeHi,
Apologies if this is wrong newsgroup, I wasn't sure if this or
microsoft.public.excel.sdk is better.
We're developing a set of XLL worksheet functions that have 5-8 difficult to
remember arguments.
While the argument descriptions passed to the registration function display
properly in the function wizard, they do not appear in the common case of
typing the function in the formula bar.
In addition, I have these related (but lesser) concerns:
- My worksheet function description does not appear when my function
name is being typed in the Formula Bar.
...
Inserting pictures into Word textI want to put a picture in text and have the text wrap around the picture
filling up the white space to the margin but can't figure out how to do it.
The picture is about 5 lines long and the text doesn't start again until the
last line at the bottom of the picture.
Set the text wrapping on the picture to Square.
--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
http://word.mvps.org
"socr1st" <socr1st@discussions.microsoft.com> wrote in message
news:72B1208D-5D78-4DA1-AF0B-FA43762CC5AB@microsoft.com...
>I want to...
full text searchHello,
It does not look like vista is full text indexing word documents.
I have set the option:
Indexing Options in the Control Panel and click Advanced,
then clicked the File Types tab. Add the .doc, doxc file types
and clicked the option to "index properties and file contents."
However I still cannot full text search word document.
any ideas?
thanks
The answer to Vista's lame search is:
www.mythicsoft.com
FileLocatorPro. There's also free AgentRansack but like most free things,
it's not superb.
WindowsXp search was slow but WORKING, especially...
Printing vertical text (or not!)Hi, I've got another printing question. I need to print some vertical
text on a printout (entire line of text rotated 90 degrees, not just
horizontal letters stacked vertically). I set nEscapement and
nOrientation to 900 in my CFont, and the font is rotated correctly,
but I can't figure out how to place it on the page. Using DrawText()
with DT_CENTER and DT_VCENTER doesn't work - the text prints, but not
centered. I also see that if I do a DrawText() with DT_CALCRECT, the
resulting rectangle does not correspond to the text if it were printed
vertically. That is, it will return...
rounding of numbers in worksheetHelp! How do I keep formulas in a worksheet from rounding
up or down. Do I need to do a different formula than =sum
(b2+c2)?
Audrey,
What leads you to believe that Excel is rounding? You might just
need to increase the number of displayed decimal places.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Audrey" <anonymous@discussions.microsoft.com> wrote in message
news:2e4af01c46aa0$9ed494e0$a301280a@phx.gbl...
> Help! How do I keep formulas in a worksheet from rounding
> up or down. Do I need to do a different f...
How does misspelled text get red lined?I have set up Outlook to check spelling before sending and perform auto
correct options but it is not underling the misspelled word in red to show
the misspelled words. What am I missing?
Thanks
Are you using word as your editor? if so, does it work in a word document?
--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join ...
Convert Text Time to Time
I have text in the following format:
800
830
900
930
How can I convert these text to 8:00 AM, 8:30 AM etc...
Thanks,
M
--
mdalb
-----------------------------------------------------------------------
mdalby's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=705
View this thread: http://www.excelforum.com/showthread.php?threadid=26248
Hi
try:
=INT(A1/100)/24 + MOD(A1,100)/(24*60)
>-----Original Message-----
>
>I have text in the following format:
>
>800
>830
>900
>930
>
>How can I convert these text to 8:00 AM, 8:30 AM etc...
>...
filtration of worksheets tallying 2 million seperate phone numbers #2Hi, I am a loan officer at a mortgage brokerage. We have
recently put the new nationwide no-call list on an excel spreadsheet.
I
have 2 questions for you. First: is there a way to make excel have
more
rows than 65,536 (preferably like 2 million) as the colorado part of
the
national no-call list is about 2 million. And second;can you tell me
how to
filter one workshet against a second with 30 columns and 65,536
rows(the
filter feature I use only takes into consideration the left-most
column)
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com...
copyright and worksheet protectionI have two questions. The first is about getting copyright or some other
protection for a worksheet. The second is about incorporating a disabling
feature in the worksheet.
BACKGROUND: I have developed an excel worksheet that would be used as a
selling tool for a specific type of loan. The worksheet would be used by
representatives of companies that offer this type of loan. The worksheet
incorporates the use of the Excel template: "loan calculator with extra
payments". The calculator has been modified. It is my intention to sell the
worksheet to companies that offer the loan....