Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E. Giagozoglou
 
Posts: n/a
Default How do I link the same format when using the "=" command

I am trying to link from s/sheet A to s/sheet B by using the = command. So
when I change the wording in s/heet A, s/heet B changes automatically. The
issue is that one word is in bold however, in s/heet B it doesn't come across
as Bold. How do I get the same format to come accross. Don't want to copy
and paste special because it wont link the fields. Want to be able to change
it in s/sheet A and then s/heet B to change accordingly
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
 
Posts: n/a
Default How do I link the same format when using the "=" command

Formulae return values, not formatting, so there's no way for a formula
or link to return your cell's formatting.

You can use a VBA event macro to do this. One way (put this in the
destination sheet's worksheet code module: right-click the worksheet tab
and choose View Code):

Private Sub Worksheet_Activate()
CopyA1
End Sub

Private Sub Worksheet_Calculate()
CopyA1
End Sub

Private Sub CopyA1()
Dim rSource As Range
Dim i As Long
Set rSource = Sheets("Sheet2").Range("B1")
With Range("A1")
.Value = rSource.Text
For i = 1 To Len(.Text)
.Characters(i, 1).Font.Bold = _
rSource.Characters(i, 1).Font.Bold
Next i
End With
End Sub


Change the sheet name, "A1" and "B1" to suit.

In article ,
"E. Giagozoglou" <E. wrote:

I am trying to link from s/sheet A to s/sheet B by using the = command. So
when I change the wording in s/heet A, s/heet B changes automatically. The
issue is that one word is in bold however, in s/heet B it doesn't come across
as Bold. How do I get the same format to come accross. Don't want to copy
and paste special because it wont link the fields. Want to be able to change
it in s/sheet A and then s/heet B to change accordingly

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link the format of one cell to another's Fabiano Excel Worksheet Functions 1 December 6th 05 04:49 PM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
can't format cell - have tried unlocking and unprotecting griffin Excel Discussion (Misc queries) 1 April 5th 05 02:11 AM
why does currency format change to number format? Cassie Excel Discussion (Misc queries) 3 March 18th 05 06:57 PM
Keep custom format in new worksheet Buddy Excel Discussion (Misc queries) 2 March 14th 05 10:03 AM


All times are GMT +1. The time now is 12:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"