Text Box hide & unhinde with mouse?
How do i Attach th text box on the right hand side corner of the sheet and
hide it their and when i take mouse their it comes out.
Cannot be done in Excel with just a 'mouse-over'. Could be done with VBA
(macro) using Worksheet_SelectionChange() event. You would have to click on
a particular cell to make it come out (become visible).
"Anand vijay" wrote:
> How do i Attach th text box on the right hand side corner of the sheet and
> hide it their and when i take mouse their it comes out.
how do i do that with the help of cell
> C...find column with text data in row 1
I have the following macro which bounces me back and forth between b:k
Private Sub Workbook_SheetBeforeDoubleClick( _
ByVal Sh As Object, ByVal target As Range, Cancel As Boolean)
If Not Intersect(target, Range("B:J")) Is Nothing Then target.Offset(0,
If Not Intersect(target, Range("M:U")) Is Nothing Then target.Offset(0,
Now I would like to build on that. My K Column is my delimiter with
the static text 'Totals'. I would like to be able to have the
functionality of the above without have the number of columns static,
so...Copy and Paste #6
I would like to copy from one spreadsheet that has hidden rows, and paste to
another without pasting the rows I had hidden.
Is there a way to have text flow around the outline of a
graphic so the text takes the form of the image?
A small child turns to Ed, and exclaims: "Look! Look! A post from Brian
> Is there a way to have text flow around the outline of a
> graphic so the text takes the form of the image?
Use the "Tight" wrapping option?
Ed Bennett - MVP Microsoft Publisher
Before reading this message, view the disclaimer:
I'm not really looking to wrap the...Email in plain text?
Does anyone know if CRM can send emails in plain text?
HTML seems to be the default.
...Copying Border Formatting
I have a large spreadsheet which is essentially a diary.
I want to format the days and weeks, with thin and thick borders to
distinguish between them. The spreadsheet already has lots of varied fill
formatting for meetings that are held.
I can't see a way of either format painting, or paste special-ing, just
Is it possible?
Stanley: It's not gonna end like this.
Gabriel: Oh, come on, Stan. Not everything ends the way you think it should.
Besides, audiences love happy endings.
True enough that...typing text onto two lines (one above the other) in one cell
What is the command and syntax to do the above?
Press the Alt-Enter keys at the same time in a sentence to go to a different
line within the same cell.
"Will Naylor" wrote:
> What is the command and syntax to do the above?
> Thank you.
...keep fill color when copying down a formula?
Hello. I've got a spreadsheet where every other row is
filled grey or white. This makes things a bit easier to
read in print, but the problem is, when I copy a formula
down a column, the fill color comes along with the
formula. Is there any way I can ``lock'' the fill color
to the cells so that this doesn't happen?
Thanks for any help that's out there -- I really
go to the edit menu, choose paste special then check formulas and number
~~ Message posted from http://www.ExcelTip.com/
~~...Use a picture as text
I recently saw a brochure made with MS Publisher that had text that was made
from a photograph. Does anyone know if this was done in publisher and if so
how it's done? It was a picture of a truck on the road seen as several
letters to form the picture. The letters looked like word art. Thank you
>I recently saw a brochure made with MS Publisher that had text that was
> from a photograph. Does anyone know if this was done in publisher and if
> how it's done? It was a picture of a truck on the road seen as several
> letter...Number Stored As Text 11-18-09
What property of a cell should I check to determine whether that cell
contains a number stored as text?
I have some cells which Excel 2007 tells me, via the office assistant, are
numbers stored as text. I want to loop through all the cells in the used
range testing for and correcting this.
On Nov 18, 12:11=A0pm, "Paul W Smith" <p...@NOSPAM.twelve.me.uk> wrote:
> What property of a cell should I check to determine whether that cell
> contains a number stored as text?
> I have some cells which Excel 2007 tells me, via the office as...Display text as date
Hey guys :)
I use this formula =">="&DATEVALUE(Files!D3)+TIMEVALUE(Files!D3) to
display and use as filteroption.
(Dont ask why I have to do this exercise....)
However the formula works all right but the display appears as
decimalnumber in this text expression:
Actual displayed: >=40170,6145833333
Wanted displayed: >=23.12.2009 14:45:00
I KNOW that there is some way to transform the expression displayed,
but have not found anything useful on the web - so far.
Are there anybody called to give me a hand on this one?
Best regards Snoopy
(Wish you a Happy ...Credit Card Receipts 2 Copies
How do I get 2 copies to print when I run a credit card?
...Copy descriptions into notes
My customer is unhappy about the 5000 character limit on description fields
and would like to use notes instead.
Is there a sensible way to copy his current description field into notes?
you need some form of data migration tool. Either write a utility using the
SDK or look at a tool like scribe
Microsoft CRM MVP
"Marcin" <Marcin@discussions.microsoft.com> wrote in message
> My customer is unhappy about the...copy a cell value not its function
ce11 A1 value=500
Cell B1 value=600
Cell C1 value=2000
Cell D1 value=50
Cell E1 value=C1-D1-B1-A1
use contrl+D to copy cell E1 value all the column down to cell E100
What I wnat is to use contrl+D to copy E1 value not its fuction.
Please if someone could help.
To copy down the snapshot value of E1:
Select E1 | Copy | Select E1:E100 | Paste Special | Values | Ok
-- OR --
To copy down a value which wll equal E1 and reflect any change in E1:
Select E1 | Select the entire formula in the formula bar and hit F4 to
convert to an absolute formula | drag down
Reg...Copy and Paste changes colour
When I copy elements from one Publisher 200 file and
paste them into another Publisher 2000 file they change
colour. Red goes blue, and green goes yellow. Bizzare!
Can anyone explain this please.
John the issue you describe is unknown in any version of Publisher.
I would suggest you need to update your video driver from the website of
your video card manufacturer. Make sure you get the correct version for
your video card and operating system.
I am sure that will fix your issues.
The US should free all those
illegally held prisoners they are
torturing, abusing and denying
human right...outlook 2003
since upgrading to Outlook 2003, my rules don't work property anymore. when
i specify a message to "move it to specified folder", Outlook always leaves
behind a copy of the message in the original folder it arrived in.
sounds to me like a bug. anyone know how to fix this?
Darchon <email@example.com> wrote:
> since upgrading to Outlook 2003, my rules don't work property
> anymore. when i specify a message to "move it to specified folder",
> Outlook always leaves behind a copy of the message in the original
> folder it arrived in.
...Regarding field data disappears from CRM Task when copying to Cale
I've created a workflow rule so that a TASK is created, whenever I've made an
ORDER in CRM.
In Outlook, I sometimes schedule or time register by copying tasks to the
Outlook Calendar, thus converting them to an Appointment in the process.
Hereby, the field "Regarding" (placed just right of "Track in CRM") which
refers to the ORDER from which the TASK was created, is emptied, and I have
to point to the order again manually.
Does someone know of a method to solve this problem?
How can i make words in the shape of a heart (for example) I want my words to
illustrate a shape. Please help.
You really can't, Publisher can add text to a shape,
but only as a rectangle. If you have patience I have a
method on my web page that shows how to do text in
shape of a heart. Takes some work. Scroll way to the
bottom of the page.
"ShapeUser" <ShapeUser@discussions.microsoft.com> wrote
...Copy range to different columns depending on cell value
What I would like to do is look at a range (A6:IXXX), where XXX is the
last row of the range, and if there is NOT an "X" in I6, copy that row
to another range (K6:S6), this would look at each row and copy to the
new range if "I" is empty.
Is this possible to do?
Dim I As Long
Dim aLastRow As Long
Dim dLastRow As Long
Dim ws As Worksheet
Dim aRange As Range
Dim dRange As Range
Set ws = Worksheets(2)
aLastRow = ws.Cells(Rows.Count, 1).End(xlUp).Row
For I = 6 To aLastRow
Set aRange = Range(&q...two identical copies of the same file in Excel
When I open Excel from our network I get two identical copies of the same file. What ever I do to one happens in the other. If I close, for example, WireList.xls:1, WireList.xls:2 closes. If I change WireList.xls:1, WireList.xls:2 changes. What causes two copies of the same file to open
Running in Windows 2000 Professional, Excel 97 SR2(I
Press Ctrl + F4 to close one window, then save the workbook. This happened
saved the workbook while 2 windows were open.
"Clint Eastwood" <firstname.lastname@example.org> wrote ...Text print size
here is my problem,
when printing an excel sheet, the size of texts seems to be bigger than on
The effect is that some of them are cutted : they fill in the cells only on
On the printed page (or on the print preview) the text is bigger, and does
not fit anymore.
I do not understand why the text size is not the same on the screen and when
I tryed with True Type or not / I tryed qith auto-scale of the page or not
/ always the same result.
What's the matter ? How to change that ?
any idea ?
any one ?
Are you writing about text in...format for two rows of text
Is there a way to enter two rows of text in a single cell
or row of cells?
To start a new line in a text, press Alt+Enter
> Is there a way to enter two rows of text in a single cell
> or row of cells?
Excel FAQ, Tips & Book List
...Need VBA code to enter text into a textbox !!!!
Does anybody know one line of code that will allow me to
enter a number into a textbox on a worksheet.
when I record a macro I get..
ActiveSheet.Shapes("Text Box 27").Select
Selection.Characters.Text = "123"
I thought this implies I could code this like so...
Dim sht as sheet
set sht = activesheet.shapes("Text Box 27")
sht.characters.text = "123"
set sht = nothing
But this does not work !! what is the correct way of
doing this ?
Dim sht As W...Find number in Row 1, Copy Paste Values in Rows below
I'm looking for help with a macro that will allow me to find every column
(from D:W) with a number in row1 (any number) and will copy the formula on
row 2 to row 100 on that column.
if cell D1 = 3 then copy the formula on D2 and paste on D3:D100
(also, IF POSSIBLE, copy D3:D100 AGAIN and paste as values on the same range)
repeat for all column where row1 has a number
Any help would be appreciated.
Give this macro a try...
Dim Cell As Range
For Each Cell In Range("D1:W1").SpecialCells( _
xlCellTypeCon...Seperating text, backwards to frontwards
I have a field which is like the below example:
"Disappointed at failure - 68 Interior equipment - Repair group: Body -
Now I want to split this into fields, as per below:
A B C
..Archive Repair group: Body 68 Interior equipment Dissapointed
I know that I can use text to columns to split the field by the "-" but
then how do I get it reversed?
NOT all of the fields can be split into 4, sometimes there can be up to
7 or as little as 1.
Does anyone have an answer?