Cell contains bold / non-bold characters: Link on the cell shall be formatted identically
Hello,
cell A1 contains the fix value Grasshopper ("shop" in bold)
Cell B2 contains the formula "=A1"
Is it possible to get Grasshopper also in B2 by modification of the formula in B2 or using another technique?
Thank you in advance for your help
Florian
Are you prepared to use VBA?
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Yes, I am (I know how to implement VBA code into the VBA editor and apply/run the resulting macros)
Is this a requirement for only one cell?
OR are you wanting something that will work for any cell containing formula like =A1
If your requirements are not that simple, please provide details
thank you
The VBA below does exactly what you requested (and nothing more)
- type anything into cell A1
- format some of the text as bold
- cell B2 immediately mirrors A1
Place in sheet module:
More cells can be added within the same sheet with further line immediately below Call MatchBold ...
Please Login or Register to view this content.
Comment
- as it stands, I cannot see how this is adding a lot of value (you could simply type directly into cell B2)
- perhaps you want to do more than is specified in your first post
- if so, let me know
Hi kev_
your macro seems to work fine; thank you very much for this.
Indeed, my need is to use the functionality anywhere in a sheet (e.g. as a customized worksheet function or similar).
Possible?
Regards
Florian
A UDF (user defined function) returns a value and cannot format
(It behaves exactly the same as Excel's in-built functions in that respect)
I will post something that can give you similar capability shortly
It is complicated because it is dynamic
Try in attached workbook
Cells previously set up are automatically updated
- Enter text in A1 and A2 of "Sheet A" and make some of the text bold
- cells B2 and C6 now contain mirror text
- that is because they are on list in sheet "MasterList"
- cell addresses are dynamic (to allow rows & columns to be inserted\deleted) because of generated cell reference formula:
=ADDRESS(ROW('Sheet A'!$A$1),COLUMN('Sheet A'!$A$1))
- sheet names are NOT dynamic
- after testing, sheet MasterList should be hidden
Add another cell to that list like this
- select a cell that is the mirror (like B2)
- use shortcut {CTRL}{SHIFT} B
- select the originating cell (like A1) with mouse or enter cell reference in box
- hit "OK"
- check master list to confirm updated
- the 2 cells can be in different sheets
Does this give you what you want?
In ThisWorkbook module
Please Login or Register to view this content.
In standard module
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by kev_; 03-23-2018 at 07:12 AM.
Have you lost interest in this thread?
Or found a different solution?
If you have a solution please post it
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks