Excel Tips - Format Text In A Cell

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

First thank you for taking the time to read about my problem. Secondly
I'm not an xml or excel hotshot. I can barely write a macro.

My problem is this.
When exporting my xml data, the time/date values lose their readable
format. A time of 01:30 am, for example, becomes something like
0.001353 for example.

What do I need to do to keep the same format as is in Excel? It would
sure be great if you could help.
Kind regards

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,

Hi,
Using excel 2003, I am looking to add Macro for a range of cells (A6:BW5000)
The macro needs to check through each cell in the range or ranges and check for special characters or characters that are not the following string (1234567890abcdefghijklmnopqrstuvwxyz.@) once found format cell's to red font.

Hi,
I have a cell in a worksheet that contains long text (500 characters). It has Word wrap set. The data gets displayed fine if the cell format is General. But if the format is set to Text, then the data gets displayed as #######

Here's the problem. I'm loading data for this cell using an XML Map (by calling ImportXML from VB code). This seems to automatically reset the cell format to text. In the XML Map, I've mapped this field using the following definition:


Currently the workaround I've done is to reset the cell format in VB code after importing the XML Map, as follows:
Range("Comments").NumberFormat = "General"

Is there a better way to solve this? I would like to avoid writing this kind of code, if possible.

Thanks,
Sam

Hello.

Is there a way to format a cell based on the format of another cell?

I want my cell C3 to automatically be filled in blue when cell R3 is filled Blue or Red when C3 is filled in Red.

Alternatively, it could also be based on the text within R3. So if R3 contains text (Apples) then C3 would automatically turn red or blue if it contained (Bananas).
Can anyone help?

I have a spreadsheet of around 600 rows.

In column R is a list of data, which is seperated by a comma.

Example:

Name, Address, Address2, Post Code

I want to create a macro that runs through each cell in column R and formats the data so it appers like this in each cell:

Name,
Address,
Address2,
Post Code

In otherwards, doing exactly what you would do if you were manually pressing Alt and Enter after every comma?

Is this possible?

Thanks

I am using the following formula where Cell A6 contains a date in TEXT format (i.e. 10-01-10)

=IFERROR(SUM(INDIRECT("'"&A6&"'!C3:E3")),"")

I want to have this same formula work with a cell that contains a date in a DATE format.

I had to put A6 as text as I couldn't get it to work as a date format.

Attached is a sample.

Columns ABC are a working copy in TEXT format. Columns EFG is an example of what I want to work with.

Thanks for any help.

Nick

Hi Everyone
I have tried searching the forum but can't quite find a solution to my problem.

In the spreadsheet I have cells that hold values which represent 'targets'.
These can all be different and can change from time to time i.e. number, percent, string etc. depending on whether they are quantitative or qualitative targets.
The format of these are set to suit at setup or when the targets change - no problem

I can display the contents of these cells in a VBA userform using text boxes OK.

I need a way of detecting the cell number format in the spreadsheet to automatically set the format of the text box in the userform so that the values display correctly in the userform.

I don't want to 'hard code' the text box formats each time the target type change - there can up to 70 of them!

I have read up on the FORMAT function but it seems you need to know the format required first in order to use it.

Any help gratefully received?

WTIA

barry

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......