Excel Tips - Center Text Across Cells

If I have 10 merged cells with a label centered in it, how do I get it to recenter the label when the spread sheet is moved to the left?

How do I center data across multiple cells in excel without merging the cells
together

in previous versions of Excel, you could align text as you typed it into a
cell by using "^" to center, """ (double quote) to right align, and "'"
(single quote) to left align. you didn't have to poke one of the alignment
buttons to do it.
can that feature be re-enabled in Excel 2003??
thanks

I would like to change the text of a tool/hover tip for a datalabel in a chart
using Excel 2003. As it is, I can use the

Application.ShowChartTipNames
and
Application.ShowChartTipValue

to either turn on or off the names and values. If, say, I turn on
names but not values, then the datalabels for the series named "Category 1"
would read

"Category 1" Data Labels.

That's close, but I'd prefer that the tip simply read

Category 1

or whatever else I choose. Is there a .caption property or some such
that I can change somewhere?

Can this be done?

Thanks,
Rob

I've been using Andy Pope's U.S. map located he

http://www.andypope.info/ngs/ng12.htm

I'm having trouble getting text to align in the center of states. Some states, like California, have odd shapes and it seems like Excel assumes each shape is a rectangle.

To complicate this, I would like to do the text aligning through VBA, since I want to dynamically add/remove labels.

I've messed around with manually aligning text, and this works, but I'd rather not manually do this for every state. I figure that's got to be some algorithm that will accomplish perfect aligning in VBA. Any ideas?

Hi All,

Looking for some help with a Userform, I am fairly new to VBA but have picked up some basics from this forum and others.

I have a text box that I would like to contain a help tip, such as; 'please write your specification here'. When the user selects the text box the 'help tip' disappears presenting the user with a now empty text box to write their specification.

Is this even possible in a userform? you usually see this concept on web pages where the label is "E-Mail" and the help tip is 'example@example.com'

Thank you,

Dear Forum

Is it possible to assign a screen tip to a cell?

Preferably dynamic

Thank you all for your time. It is greatly appreaciated

With KInd Regards


Paul Marks

I have a macro that output a month based upon a date that has been entered in a row on my spreadsheet. I want the macro to center the text but im not sure of the syntax, the macro code is below:

Code:

Sub calculateMonthRegistered()

' Lr = "Last Row"
    
    Dim Lr As Long
     
    Lr = Range("J" & Rows.Count).End(xlUp).Row
    
'Refers to Cells 1 = "1" and 3 = Column "C"
     
    With Cells(2, 43).Resize(Lr - 1, 1)
        .Formula = "=TEXT(J2,""mmm-yy"")"
        .Font.ColorIndex = 3
        .Font.Bold = True
    End With
     
End Sub

Can anyone help

I have got a message box which I want two lines of text on.

I am using chr(13) for the carrage return, but would like to centre the text in the message box.

Can thie be done???

Cheers,

Dave

The cells that I am working with are something like this.

PRODUCT NAME 3OZ 1473985673
PRODUCT NAME TWO 17.5OZ 1850275829
PRODUCT NAME AGAIN 12OZ 4781940093
....etc...

I need to pull the product size (3OZ, 17.5OZ, 12OZ, etc) but the number of characters of the "mid" is not consistent and some have decimals. The number of characters of "left" is also not consistent. Text to columns is not doing the trick either. I have thousands of cells to pull this from so manual is my absolute last option.

HELP! Thanks