Converting text to uppercase
This is Excel 2000. Cell C2 in a worksheet called 'NOTES'
contains '34 West Street, somewhere-in-England'
=UPPER ( NOTES!C2 )
is supposed to produce ' 34 WEST STREET, SOMEWHERE-IN-ENGLAND'
In fact it gives:
What is going wrong?
Have you spelt UPPER( correctly? There is no space before the open
Hope this helps.
On Apr 24, 3:53=A0pm, Alan Secker <a...@asandco.co.uk> wrote:
> This is Excel 2000. Cell C2 in a worksheet called 'NOTES'
> contains '34 West Street, somewhere-in-England'
> =3DUPPER ( NOTES!...Check box to click on in excel or word
I am needing to add a shadow outlined box that you can click on in a document
in either word or excel. I did it in the old excel but I'm having difficulty
in the new Microsoft Office.
The old and the new Office?...which versions would that
be...nevermind...actually you should ask this in an Excel newsgroup this one
is for Publisher (a desktop publishing program).
Microsoft MVP Expression Web
"ThePools" <ThePools@discussions.microsoft.com> wrote in message
news:24A86070-537B-404A-A39B-CFC06CAECBA0@microsoft.c...Returning cursor to first cell, next line down
I am using a handheld scanner to record asset/serial numbers of hard ware. I
scan 4 cells worth of data (across) and I would like to find a shortcut or
macro to return the cursor to first cell, next line down. Any ideas ?? I have
scoured the Excel help on the web etc. with no luck. I am using Excel 2000.
Make sure you save a copy of the file to try this as I am not sure what else
you are doing... right click on the sheet tab and select 'View Code' and
paste the code in the window that pops up.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersec...Displaying Message from event sink to Edit control in dialog box
I am working on FTP Software using MFC and i have to write the ftp
server request and response to tracer window.
The server request and response were caught by Eventsink and i donot
how to pass this text to edit control in dialog box which is another
Here is coding of Event Sink
/ EventSink.cpp : implementation file
#define new DEBUG_NEW
static char THIS_FILE = __FILE__;
extern long gnResult...Starting Outlook #8
I have a hotmail account, but want to use the outlook program for my Hotmail
email. Is this possible, and how do I configure the system to do it?
Your hotmail account must be a POP3 type of account, i.e., paid account.
"email@example.com" <firstname.lastname@example.org> wrote in message
>I have a hotmail account, but want to use the outlook program for my
> email. Is this possible, and how do I configure the system to do it?
Chuck Davis <newsgroup at anthemwebs dot com...Showing all data in tabular form boxes
I have a columnar form with tabular subform. The data was all imported from
Works and therefore some of the fields have a great deal of data. In the
tabular subform I would like to keep the boxes with just first row of data;
i.e. small, but be able to show all the data in a separate box elsewhere
should it be wanted. I would be really appreciative if someone could come up
with a suggestion as to how this could be done.
Move the cursor to the text box and press SHIFT + F2 and see if that
will do what you want.
On Thu, 17 May 2007 03:20:01 -0700, Sadie
<Sadie@...MS Excel Combo Box
I currently have a Combo Box which have drop down numbers, 1-5.
I would know like to select any one of the five and it should be displayed
in the required cell.
Is this possible and how?
Link a cell to the combobox. If it is a forms toolbar combo, right-click it
and select Format Control, select the Control tab and define the cell there.
If it is a control toolbar combo, go to design mode (the blue-green triangle
button), double-click the control which takes you into the VBIDE. make sure
the properties window is open (F4), and set the LinkedCell property.
(remove n...Start up hang-ups
When starting up Windows/XP with any user in the system brings up the user
page but hangs. The disk is running something. The internet modem is always
disabled. I bring up the task manager and I am in idle 99% with no visible
processes running. I select shut down and get two messages. The first is
ccSvcHst running and it won't close, so I end it. The second in exployer.exe
and I also have to force it to end. Rebot and everything is ok that day.
> When starting up Windows/XP with any user in the system brings up the user
> page but hangs. The disk is runnin...Using Adobe starts trying to load publisher
Start Adobe Publisher tries to Reload itself. If I shut Publisher two or
three Adobe is able to load up and display. A pesty little problem.
...change font in a forms control combo box
Am trying to change font in a combo box in Excel 2003 but cant figure out how
to. The font appears to be a default size and style regardless of how large
I make the combo box. I have canged the size of font in the linked list but
this does not work. Any help welcomed.
I suspect you are trying to use a combobox from the 'forms' toolbar. The
font in these is fixed.
If you use the 'controls' toolbox you will get an activeX control in which
you can change the font attributes. You also used the 'linkedcell' property
and 'ListFillRange' to fill and dis...Clicking on report
Can i click on the report so that a pop-up data of the record that i just
Message posted via http://www.accessmonster.com
"Benjamins via AccessMonster.com" <u39077@uwe> wrote in message
> Can i click on the report so that a pop-up data of the record that i just
> click appear?
In Access 2007, reports have a new view (called Report view) that allows for
this kind of thing.
You can't do that in other views, so not in previous versions.
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Acces...Pulsating Cursor #2
Can someone tell my how to eliminate the on - off pulsating which occurs
when my cursor is in either of the Address Windows and the Subject Window
of a new message? I am not speaking about the Insertion Point, which should
be pulsating, but does not interfere with my typing.
I think this would be best posted in an Outlook Express news group since that
is the news reader you are using for this posting.
Gord Dibben Excel MVP
On Thu, 6 Jan 2005 14:29:54 -0500, "Bernie Beal" <email@example.com> wrote:
>Can someone tell my how to elimi...How do I have numbers (1,234) show as text (A,BCD) for coded costi
I would like to display certain columns of numbers as coded in text, rather
than the numbers that they are.
>I would like to display certain columns of numbers as
coded in text, rather
>than the numbers that they are.
...enter data in cell but cannot save until click off cell in excel
When I enter values into a cell in Office 2003 I cannot click the save button
to save the change until I click on another cell that I have not modified.
This funcion used to work but has not for the last week. Can anyone help me?
When you edit a cell, Excel is in Edit Mode, and many functions,
such as Save, are disabled. Simply press Enter after typing in a
cell and you should get full functionality back.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"T70McCains" <T70McCains@discussions.microsoft.com> wrote in
mess...link employee start date to accrual schedule
Employees earn different accruals depending on their start date - It would be
helpful is Great Plains looked at the start date and then updated to the
propoer accrual schedule.
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.
I change the Cursor of my mouse in WM_SETCURSOR handler. That doesn't cause
any flicker in XP, but causes a flicker in 98. Moreover the flicker is
strange, I don't see the arrow cursor in between, It is just that my new
cursor disappears for a few (fraction of) seconds, before reappearing. Any
I tend to work in the model of
HCURSOR cur = GetCursor();
if(cur != desired)
cur = desired;
which minimized flicker. The problem with SetCursor is that it &qu...Setting cursor for Disabled Button
I have created a custom button control class derived from CButton.
Everything works fine. I want to change the cursor of control when it is in
disabled stated. I am handling WM_ENABLE message to handle changing the
cursor. I set my custom cursor there. but it has no effect. Am I doing
>I have created a custom button control class derived from CButton.
>Everything works fine. I want to change the cursor of control when it is in
>disabled stated. I am handling WM_ENABLE message to handle changing the
>cursor. I set ...Excel
I have 2 sets of data -
name date Start # End# Price Qty
DDA 3/1/2007 100 150 $75.00 4
DDA 3/1/2007 151 200 $45.00 4
DDA 3/1/2007 201 250 $25.00 4
DDA 8/1/2007 251 300 $90.00 8
DDA 8/1/2007 301 350 $20.00 9
BBD 8/1/2007 351 400 $55.00 21
BBD 8/1/2007 401 450 $58.00 54
BBD 7/7/2008 451 500 $60.00 28
BBD 7/7/2008 500 550 $74.00 9
Name1 Date1 Number
DDA 3/1/2007 115
DDA 3/1/2007 121
DDA 8/1/2007 254
DDA 8/1/2007 345
DDA 3/1/2008 388
BBD 8/1/2007 229
BBD 7/7/2008 458
DDA 3/1/2007 298
BBD 7/7/2008 508
I am trying to write a lookup function that will tell me...mailto syntax for text to display
I am successfully using the following: -
Private Sub lblFeedback_Click()
Link = "mailto:firstname.lastname@example.org?subject=Subject"
On Error GoTo NoCanDo
ActiveWorkbook.FollowHyperlink Address:=Link, NewWindow:=True
MsgBox "Cannot open " & Link
Is it possible to hide the email address and put e.g. "ADMIN" with something
similar to the text to display used in the Outlook address book?
Not that I know of. Why not protect the VBAProject?
Why is my cursor jumping all over the page and putting in the letters at
places not designated? Annoying.
Laptop? Disable the touchpad or reduce its sensitivity.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
wrote in message news:CF344F8E-7805-476F-A13B-FCC32D0A75C4@microsoft.com...
> Why is my cursor jumping all over the page and putting in the letters at
> places not designated? Annoying.
...Vlookup,format general, format text
I am having a pull the hair out problem with excel. I have a workbook that I
use vlookup to get data from a datasheet in the same workbook. The data is a
combination of text and numbers and text and numbers combined. Excel
sometimes returns the values I want and sometimes doesn't. Sometimes I have
to format the data as text and vlookup will work and sometimes not. Then I
switch the data to general and it will work and sometimes not. This is
extremely frustrating. Now I have a few cells that will not return anything
but N/A no matter what format I have it in. I know that that dat...About Cursor
I create two views using splitter window in MFC, while the left one is used
to set options and the right one draw the scene according to the command of
the left one with openGL.
Now I want the cursor of the mouse is visial in the left view and unvisial
in the right one.That means when the cursor falls in the rect of the right
view it disapeared and in other field it works all right! How can i do that?
Have any ideas?
Probably the simplest way is to have an OnSetCursor handler in the RH window and do a
SetCusor(NULL) to hide the cursor.
On Fri, 24 Jun 2005 09:44:27 +080...Protecting sheets with drop down boxes
I have an excel spreadsheet that has drop down boxes and formulas. I want to
be able to protect this spreadsheet so that other user will not delete my
formulas. I password protected the spreadsheet, however, when this sheet is
protected i am not able to select from the drop down list. Is there a macro
that I can incorporate into my worksheet that would help me with this
problem. If so, can you please give me the codes needed?
Unlock the cells that have the data validation.
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your f...Cursor disappears 11-25-09
Today installed Office 2010 Beta. Am running Windows 7. While using Word from
this suite (which I understand is actually Word 2007), if I hold down the
spacebar the cursor disappears while it is advancing. I can't tell where it
is until I release the spacebar. Very troublesome and I can't find a way to
Word in Office 2010 is Word 2010, but its behaviour in this regard is the
same as it was in 2007, which was a change from earlier versions. The cursor
does not disappear, but it does not stop flashing and, so, is not always
If you must do ...Formatting a Sentence With TEXT Function
I have what is essentially a simple formatting question that involves
combining a TEXT function within a sentence. Before I get to my
question I ought to provide some context.
I built a table that uses VLOOKUP to list the number of cases sold by
month.Then I need to show the net difference in cases sold between the
current month and the same month a year ago. The table works fine. My
problem lies in building a sentence that states this difference. The
heart of the problem is that forces beyond my control insist that the
difference in the number of cases be expressed as XXXk rather...