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
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 Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards
J-O
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.......
Is there an option to select only numbers or only text from a given cell with mixed data
Hello,
I have a feeling this is very simple but having searched can't find any help on this.
Basically I want to set focus back to a specific cell (easy enough) and then select the content of the cell.
I can't work out how to put the cursor inside the cell and select all the text it contains.
Any suggestions?
Thank you
Hy guys,
I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help
Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.
-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?
Thank you.
Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub
what i'm trying to do is have a dropdown list linked with a selected column, when i select a item from the drop down list, it displays text from another specified cell, or for it to display an abbreviation of the text selected in the drop down list? any help would be most welcome
I am hoping someone can help me. I need to extract information from one cell into another, in the same worksheet. Ex: A cell might show 1234 ABC. I want to take out JUST the ABC part of the cell and leave the numbers. I know how to tell a cell to copy, for example, the first 4 characters to the left or right of a cell or what ever number you want, but I have thousands of cells with a sequence of numbers then a space and the name of some particular client. I am working on a project for my boss and this would be a great help if someone could help me as soon as possible. - Thanks so much !!
